Hey guys,
I made a little Altcoin portfolio tracker in Google Sheets and I thought others might find it useful (Got a positive response over at 4chan's /biz/
)
Link:
https://docs.google.com/spreadsheets/d/1NKJTm6YVTk_IkNNHosrPqQPfKdfBDjMcMskPpIlPdFs/edit?usp=sharingScreenshot:
https://i.imgur.com/f7Pj0RD.jpgI upgraded the spreadsheet based on suggestions/comments, so feel free to use this for your own purposes.
I've included instructions on how to customize this sheet for your own use toward the bottom of the spreadsheet (below the graphs).
Features:1. Gets the 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
Other suggestions always welcome