I've been searching for a good week but haven't found anything that actually works! I'm trying to bring the real time prices of crypto into my 2016 spreadsheet. I've used the suggested ways using the query along with suggested api URLs but the cursor just spins constantly for hours. I also have my coinmarketcap api key. Any suggestions? TIA
Tried the following:
https://pro-api.coinmarketcap.com/v1/cryptocurrency/quotes/latest?symbol=BTC,ETH,STEEM&CMC_PRO_API_KEY=*****
https://api.coinmarketcap.com/v1/ticker/
Also used the suggested header with my key.
X-CMC_PRO_API_KEY
and a few other versions
Tried the following:
https://pro-api.coinmarketcap.com/v1/cryptocurrency/quotes/latest?symbol=BTC,ETH,STEEM&CMC_PRO_API_KEY=*****
https://api.coinmarketcap.com/v1/ticker/
Also used the suggested header with my key.
X-CMC_PRO_API_KEY
and a few other versions