Coming soon - Get a detailed view of why an account is flagged as spam!
view details

This post has been de-listed

It is no longer included in search results and normal feeds (front page, hot posts, subreddit posts, etc). It remains visible only via the author's post history.

3
Google sheet that tells you returns and volatility of your portfolio. Uses information ratio, which is similar to Sharpe ratio (risk adjusted return).
Post Flair (click to view more posts with a particular flair)
Post Body

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 big bug, day was shifted by one.

Google Sheet: 12 Month | 6 Month

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

Here is a clip of it in action: https://i.imgur.com/kVmaLz5.mp4

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.

Comments
[not loaded or deleted]

Thank you so much for the response!
On a second thought can I DM you sometimes? To know if you have some new Gems unearthed.

What are your top 5 or top 10 bullish gems? Would love to know them!

Also, this is just top-notch research you did there, really loved it.

Author
Account Strength
100%
Account Age
7 years
Verified Email
Yes
Verified Flair
No
Total Karma
56,209
Link Karma
20,210
Comment Karma
34,155
Profile updated: 3 days ago

Subreddit

Post Details

We try to extract some basic information from the post title. This is not always successful or accurate, please use your best judgement and compare these values to the post title and body for confirmation.
Posted
3 years ago