CryptoCurrency Portfolio Template for Google Sheets

in #cryptocurrency7 years ago

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.

CryptoCurrency Portfolio.png

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.
Wallet vs Exchange.png

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.

Sort:  

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!