Import crypto prices into excel 2016

[jarhead58]

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

 

[jarhead58]

I am going to also post in excel forum. I will provide a link shortly.

Import crypto prices into excel 2016