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"))
RE: Cryptocurrency Spreadsheet
You are viewing a single comment's thread from:
Cryptocurrency Spreadsheet
No, parentheses are OK. I suspect this version of Excel is pure garbage :(
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
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
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit