
Hi y’all!
I’ve made a Google Sheets spreadsheet that will assist in building & rebalancing an indexing style crypto portfolio based on the 30 top market cap currencies.
The holdings aren’t weighted by market cap, rather, by their market cap ranking. So instead of BTC having over half it’s share of the index, it’s at 6.45%, XRP=6.24%, ETH=6.02% etc, all the way to 0.65% for holding number 30.
The default data source is [investing.com](https://investing.com), which may not suit your portfolio (on my exchange, coinspot, there is no Binance coin for example). If this is the case, let me know and I’ll see if I can add it. Currently for the Aussies there is one other data source available through a drop down cell – coinspot.
If you’re any good with spreadsheets I’m sure you’d be able to adapt it to whatever indexing, or just custom portfolio aligning style you’d like. Please let me know if you’ve got any suggestions/questions.
[https://docs.google.com/spreadsheets/d/1yXN25oFdilR0SENOF0d5e7C0WlGdLKLdN4zbSdof2do/edit?usp=sharing](https://docs.google.com/spreadsheets/d/1yXN25oFdilR0SENOF0d5e7C0WlGdLKLdN4zbSdof2do/edit?usp=sharing)
View Source
View Reddit by pluckabgunja