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

"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.

Publish0x

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.