How to get crypto-currencies rates and more in Google Sheet
Julien Buty
9.1K455

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(“XXXYYY”, “marketcap”)
=CRYPTOFINANCE(“XXXYYY”)
=CRYPTOFINANCE(“XXXYYY”, “total_supply”)
=CRYPTOFINANCE(“XXXYYY”, “volume”)
=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
_______

Also see: 
Live Updated Cryptocurrency Investment Tracking Spreadsheet (Update 2)

https://blog.coinfabrik.com/live-cryptocurrency-investment-tracking-history

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:

https://s3-us-west-1.amazonaws.com/cryptocurrency-steemit/LIVE+CoinMarketCap+Spreadsheet.jpg

One clap, two clap, three clap, forty?

By clapping more or less, you can signal to us which stories really stand out.