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.