How to use :
Get all of CoinMarketCap data in a single sheet:
Create a new sheet, name it cryptodata, then on cell A1 type the formula:
=CRYPTOFINANCE("COINMARKETCAP")
This will create as many rows as there are coins tracked on CoinMarketCap, over 1,500 as of now.The same method is available for Cryptopia, Bittrex and Binance to pull all their markets data with 1 API call, respectively:
=CRYPTOFINANCE("CRYPTOPIA")
=CRYPTOFINANCE("BITTREX")
=CRYPTOFINANCE("BINANCE")
...
[Show More] Follow the link to see more >>>>
https://jbuty.com/how-to-get-crypto-currencies-rates-and-more-in-google-sheet-1a57e571bc14
How to refresh rates :
Your sheet should auto-refresh each time you open it. But this is rather uncertain and will not refresh if the time interval between each open is too short. Once open your sheet should refresh (again, not 100% sure) about each 2min for about 10min. These behaviours are Google Sheets defaults and CRYPTOFINANCE has no control over them.
Here is how to setup a manual refresh trigger for your sheet:Input the number 0 into cell A1
Make the 4th argument to all your CRYPTOFINANCE function call a locked reference to cell A1. If you don’t have 2nd or 3rd arguments, just make them an empty string "" .
Change the content of the cell A1 to refresh the rates. This works because Google Sheets will see the function CRYPTOFINANCE has an argument (the 4th) that changed and will force the refresh.
For example:
If your function call was:
=CRYPTOFINANCE("KRAKEN:BTC/EUR")
your function call becomes:
=CRYPTOFINANCE("KRAKEN:BTC/EUR"; ""; $A$1)
If your function call was:
=CRYPTOFINANCE("BTC/USD";"change")
your function call becomes:
=CRYPTOFINANCE("BTC/USD"; "change"; ""; $A$1)
Tips: Make the content of A1 a function that update itself reasonably regularly, like =GOOGLEFINANCE("USDEUR"), to have the sheet always up to date.
[More - detail ] Follow me to see how to work now >>>
https://steemit.com/@nmc237
Leave your comments this post if you want to ask about it..