Alright change that back. It looks like its being flagged because you're missing parentheses after JSON. Put one after JSON and then one after Headers"
You should just be able to copy and paste this into the cell
=VALUE(ImportJSON("https://min-api.cryptocompare.com/data/price?fsym=BTC&tsyms=USD","/USD","noHeaders"))
Oh I didn't even notice it was excel. I'm using Google Sheets. Not sure about fixing it in excel, should work in Sheets just fine. Sorry about the confusion
That's this
=VALUE(ImportJSON("https://min-api.cryptocompare.com/data/price?fsym=BTC&tsyms=USD","/USD","noHeaders"))
Are you getting the #NAME error in the cell where you're trying to get the current price?
Here is a screen:
Can that help?
It looks like you're using semi colons instead of commas in those quotations right after USD.
Here is what I get with commas:
Alright change that back. It looks like its being flagged because you're missing parentheses after JSON. Put one after JSON and then one after Headers"
You should just be able to copy and paste this into the cell
=VALUE(ImportJSON("https://min-api.cryptocompare.com/data/price?fsym=BTC&tsyms=USD","/USD","noHeaders"))
No, parentheses are OK. I suspect this version of Excel is pure garbage :(
Oh I didn't even notice it was excel. I'm using Google Sheets. Not sure about fixing it in excel, should work in Sheets just fine. Sorry about the confusion