Crypto Tracking in Google Sheets with autoupdate - Simple but Strong

I've created a spreadsheet crypto tracker to keep track of where all your cryptos are kept and and a quick view of exactly how each one is going.

I have on purpose made it as simple as possible without a lot of bells and whistles, so as to make the code easy to follow and not become to complicated.

I created it because I really wanted to make it easy to expand upon it with other fields such as thoughts on that particular crypto

It's really simple to use. Click the 'Add Crypto' button and enter the symbol (must match the one on coinmarketcap) and the crypto name. it will then create a new row after the last crypto and insert the current values in there.

You can also add your own holdings in the exchange columns (feel free to rename them to your own main ones). I've found this really handy to know quickly whereabouts my cryptos are being held.

Hit the 'Refresh' button to update the current prices for the cryptos you've added.

Click on the link below and please make your own copy before starting to input your own cryptos in there.

https://docs.google.com/spreadsheets/d/1BQivqzkOxQGxmiUqB7fl48rGH0JGdD1obLY4OTFWwFI/edit?usp=sharing

Feel free to change the copy, and if you make any changes you think I, or others may find useful, please post them here as I'd love to hear everyones thoughts.

By the way, I use the cryptocompare api to retrieve the latest figures. It's a great API to grab historical data as well. Find out more at https://min-api.cryptocompare.com/

Hope you enjoy it.