I always get #NAME error :(
RE: Cryptocurrency Spreadsheet
You are viewing a single comment's thread from:
Cryptocurrency Spreadsheet
Authors get paid when people like you upvote their post.
If you enjoyed what you read here, create your account today and start earning FREE STEEM!
If you enjoyed what you read here, create your account today and start earning FREE STEEM!
can you reply with the api command?
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Excuse me, I don't know what “api command” is :(
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
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?
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Here is a screen:
Can that help?
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
It looks like you're using semi colons instead of commas in those quotations right after USD.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Here is what I get with commas:
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
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"))
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
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