CryptoCurrency Portfolio Template for Google Sheets
I’m sharing my cryptocurrency portfolio template for Google Spreadsheet.
There are many crypto exchanges and many ways to store your coins. I’m relatively new to cryptocurrency but it was not easy to manage where all my coins are stored. I also wanted to track how my coins are doing.
I’ve used JavaScript to get coin information from coinmarketcap.com. You can register a timer to run the script to get prices periodically/automatically.
Just enter your COIN ID, and number of coins where they are stored. The script will automatically fetch coin prices and additional information such as symbol, price changes and rank.
The prices of each coins are calculated as BTC, USD and EUR. You can change secondary currency(EUR) to other currency.
The graph displays percent of each coins you are holding.
Also ratio between local wallets and exchanges are calculated and displayed. Make sure you HODL your coins in your local wallet.
Here is the link to the template:
https://docs.google.com/spreadsheets/d/14UcwwmrHAdTl_zFHgbVJR2UW0ange0Hvt4Bz51FC42o/edit?usp=sharing
There is more detailed description included in the file.
Please comment if you have any questions or suggestions.
Actually, this is so good I promoted it again with one SBD !
Nice! Spreading the love. That's what it's all about.
Thanks dude
Thank you for your contribution to the Crypto community. See you in S.C.M. ;-)
Go Go Supoman Support!! :-) Awesome Tool, thanks for sharing @mix1009
Thanks a lot! This is indeed very helpful!
Are there any dangers from allowing access to the CryptoCoin script?
No, anyone can see the code. It only gets information from coinmarketcap.com.
But it's possible to log your portfolio technically from a script. People with knowledge of little programming should be able to find out and report it.
great!
very cool article
Fantasic mate and thanks for sharing. Going to have a longer play tomorrow.
Nice post!! Thanks for sharing!!
Saw this on S.C.M had to check it out.
I had made a similar spreadsheet in excel that I had been keeping track with. This one is much much better Thank you so much. I will be looking out for more post!