Customizable Automated Google Spreadsheet to Help you Track Your Crypto Holdings
CryptoHodlings
Hey guys, I'm new here - glad to be a part of the steemit community!
I wanted to share something that I made which may be useful for those of you who hold cryptocurrencies. I posted this on Bitcointalk but it didn't get too much traction there yet... ;)
Features:
- Gets crypto prices from coinmarketcap API automatically every 5 minutes
- Every time the sheet updates (every 5 mins), I save the previous price and date in the spreadsheet
- It continuously generates a graph of net cryptocurrency worth over time
- Shows holdings in EURO & USD
- Tracks 24 Hour Volume of cryptos and saves the data to generate graphs. These graphs make it easier to spot P&Ds for each coin
- Shows breakdown of coin holdings as percentages and generates a graph
- Shows graph of individual holdings over time
You can download and use this spreadsheet as you please and I have included instructions for how to get it up and running for your own coins!
Link:
https://docs.google.com/spreadsheets/d/1NKJTm6YVTk_IkNNHosrPqQPfKdfBDjMcMskPpIlPdFs/edit?usp=sharing
Screenshots:
Have a good one!
-CC
Perfectly!
Thanks for the spreadsheet
Congratulations @coffeecoder! You have received a personal award!
Click on the badge to view your Board of Honor.
Do not miss the last post from @steemitboard!
Participate in the SteemitBoard World Cup Contest!
Collect World Cup badges and win free SBD
Support the Gold Sponsors of the contest: @good-karma and @lukestokes
Congratulations @coffeecoder! You received a personal award!
You can view your badges on your Steem Board and compare to others on the Steem Ranking
Vote for @Steemitboard as a witness to get one more award and increased upvotes!