This is a spreadsheet that I have developed for myself over the last year or so. I have found it very helpful for keeping track of my crypto holdings (great for tax purposes) and how well my trading decisions have been (not great). I figure it's time to share.
There is a lot in here including;
Automatically updates crypto prices from coinmarketcap. Nearly 2000 coins. Just select which ones you want to track by typing in the name.
You can even choose your local Fiat currency and get live conversion rates for any country.
No need to record details of every trade. Just keep track of your crypto purhcases (from fiat) and what coins you currently hold. The spreadsheet will calculate the rest and keep a record of how your portfolio and holdings have changed over time.
This data gets saved every time you save the spreadsheet.
I find this very handy to see if your trading is actually profitable compared to the HODL method.
Oh yes and there are plenty of 'moon math' and analytics to see how bitcoin is trending and how far off you are from a lambo. This includes a full history of bitcoins price which updates every time you open the sheet.
Plenty more bits and pieces that I have tinkered with over time.
free download from here. Instructions inside. You probably need a fairly recent version of microsft excel with macros enabled (if you want it to do the fancy stuff).
https://www.dropbox.com/s/2n8xpn9r8oyetli/Cryptoprices9%20-%20For%20others.xlsm?dl=0
Let me know if you have any issues.