Hi guys I'm Amit, I've just got started in Crypto from June this year and I've been loving everything about crypto and especially the communities. I've learnt so much from the subreddits over the last few months and thought it is time to give back. I've developed my own excel spreadsheet that tracks my crypto portfolio (update the prices through a macro from coinmarketcap.com) and produces a nice pie chart. It also has another worksheet that tracks the prices / market cap of the top 50 coins from coinmarketcap.com to highlight the big movers and losers over a 24 hour period.
I hope some of you will find it useful (link below). Also, let me know if you have any questions on how to use it or if it doesn't work for you. Thanks again!
Pics:
https://imgur.com/a/1REs6How to use:
1) Download the spreadsheet
2) Press the update button located on the second and last page.
DL:
https://drive.google.com/file/d/1VznoytXSezQ9bBZ7qN0pMuiUbT94oTm4/viewPassword: crypto123
Virustotal:
https://www.virustotal.com/#/file/2f11e629445deb29570f9bd62f45a8c0220ddebc9c5c76bffe3ed0646c816949/detectionEdit: The tool was developed in a Windows environment and does not appear to be compatible with Mac-OS. If someone knows how to modify the code to make it compatible for Macs, please let me know and I can update the uploaded file
