Neosify - Buy, Stake & Earn Crypto
Neosify - Buy, Stake & Earn Crypto
Neosify - Buy, Stake & Earn Crypto

"Rate My Portfolio" the Google Sheet. Uses Risk Adjusted Return (Information Ratio)


You just enter your portfolio symbols and % and it gives you the risk adjusted returns. Works for 1-12 coin or token portfolios. Includes most top 300 coins by market cap. Has a 12 month version and a 6 month version since not all top 300s have been around for a year.  

Edit: Fixed a major bug, where all days were shifted by 1.

Google Sheet: 12 Month | 6 Month

cd3d67e8505a0d9c6df43f7ea065bb5657007da212b59e33686935252cc92f8f.gif

Copy to your google drive or download as excel file to use.  

Information Ratio is similar to Sharpe Ratio but uses a benchmark, I used CCI30.

For the IR of individual coins/tokens check these sheets:

IR google sheets: 12 Month | 6 Month  

Notes:

Higher number is better, benchmark is an IR of 0.

Higher volatility is more risky.

Investopedia on IR

Not financial advice

Data is from coingecko

If you make a BTC ETH 60:50 portfolio, it doesn't break. It'll just think you have $60 of BTC and $50 of ETH and do the math with that.

How do you rate this article?

16



LeafyPineGlass Crypto Thoughts
LeafyPineGlass Crypto Thoughts

A no-shill, data based approach to cryptocurrencies. Not a professional.

Send a $0.01 microtip in crypto to the author, and earn yourself as you read!

20% to author / 80% to me.
We pay the tips from our rewards pool.