Purpose
Seems like a lot of you liked my last post, Excel Portfolio - How To Get Live Prices & Stats, but a few of you on reddit asked if this was possible to do on Google Sheets. Here I'm going to be simplifying the process I found here and showing you how to get live data on Sheets.
Steps
First you need to create your spreadsheet. Under the Tools tab, select "Script Editor".
Next, we are going to copy some code from this github repo. Click the "Raw" button, and use ctrl-a to select everything.
Once we have the code copied, clear the pre-fill contents of the script and paste the new code in. You should have 392 lines of code, if you have more you probably copied from the github page instead of looking at the raw data.
Next, rename the script "ImportJSON.gs" and save it. You shouldn't get any errors, but if you do, try re-copying the code.
Finally, we go back to our Google Sheets, select a cell, and enter:
Simply change the label from "btc" to "eth" to see other coins.
Special thanks to Paul Gambill who wrote the original article and source code.
Great post!! Simple and I was able to setup my API within minutes. Thank you!! You got my follow :D
If you're looking to import data into Excel, see my comprehensive guide here.
another good share you have there...thanks
Congratulations @tomshwom! You have completed some achievement on Steemit and have been rewarded with new badge(s) :
Click on any badge to view your own Board of Honnor on SteemitBoard.
For more information about SteemitBoard, click here
If you no longer want to receive notifications, reply to this comment with the word
STOPBy upvoting this notification, you can help all Steemit users. Learn how here!
How's it going? Thanks for this. Unfortunately, I keep getting the error -
"DNS error: http://coinmarketcap-nexuist.rhcloud.com/api/btc (line 131)."
when I paste =ImportJSON("http://coinmarketcap-nexuist.rhcloud.com/api/btc", "/", "noInherit, noTruncate")
into a cell in google sheets
any thoughts?
Cheers,
M
If you plug that URL into a browser you get a DNS error, so it's an issue with the site right now. They may have upgraded to a new cloud provider and that URL may not work anymore