After searching online for hours last night for a LIVE Cryptocurrency Spreadsheet and finding the one made by Pablo Yabo above in March 2017 I realized that his spreadsheet wasn’t at all what I am looking for.
So I figured I’d solve the problem for the #SteemitCommunity and myself.
I’m now building out a LIVE #CoinMarketCap Spreadsheet that we can use for daily snapshots of all 100 Cryptocurrencies.
**The spreadsheet automatically refreshes every 5 minutes!**
When I’m done I’ll invite each of you so you can use it how you wish, or we can track certain digi-currencies together.
I’m Using the =CRYPTOFINANCE call within the document I’ll show you how to build your own with an upcoming Steemit post in a few days.
=CRYPTOFINANCE(“XXX”, “change”, “1h”)
=CRYPTOFINANCE(“XXX”, “change”, “24h”)
=CRYPTOFINANCE(“XXX”, “change”, “7d”)
XXX is the coin, e.g. BTC
YYY is the fiat money, e.g. USD
Live Updated Cryptocurrency Investment Tracking Spreadsheet (Update 2)
What other ideas can we come up with to make this Spreadsheet more AWESOME???
***NOTE: the ERROR in certain cells of the sheet is because the Cryptocurrency has to be only 3 characters, but some are more, for example; DASH has 4 letters so certain cells cannot go live.
Here’s a sneek peek of the Live CoinMarketCap Spreadsheet: