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:

=ImportJSON("http://coinmarketcap-nexuist.rhcloud.com/api/btc", "/", "noInherit, noTruncate")

Simply change the label from "btc" to "eth" to see other coins.

---

_{Consider leaving a like or even resteem if you found this helpful! If you're really crazy, you can donate Ethereum and ERC20 tokens to 0x93cB484e1130358EaBE927a46c094889D9f15E2B. Please leave comments below about what content you'd like to see in the future!}

Special thanks to Paul Gambill who wrote the original article and source code.