4th Street Bar Hive-Bar

Hive-Bar Powered by Hive beta-fdb5b5b

Community post

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:

  1. Gets crypto prices from coinmarketcap API automatically every 5 minutes
  2. Every time the sheet updates (every 5 mins), I save the previous price and date in the spreadsheet
  3. It continuously generates a graph of net cryptocurrency worth over time
  4. Shows holdings in EURO & USD
  5. 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
  6. Shows breakdown of coin holdings as percentages and generates a graph
  7. 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:

Spreadsheet_Cryptoholdings.jpg

Have a good one!
-CC

5 upvotes $0.00

Replies (4)

Review before signing

Posting as . Signing with . Keychain permission: Posting. Hive Keychain will ask you to approve this action next.


  
Technical details

Operation fingerprint: