I made a Cryptocurrency tracking spreadsheet complete with live crypto price updates, moon math, and a full history of your Portfolio and trading performance (Updated).
This is a spreadsheet that I have developed for myself gradually over the last couple years. I have found it very helpful for keeping track of my bitcoin holdings (great for tax purposes). No need to trust third party apps to keep your personal information – track it yourself.
There is a lot in here including;
Automatically updates prices from coinmarketcap. The top 100 coins included. 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.
You don’t need to record details of every trade. Just keep track of your crypto purchases (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 (it logs this data every time you save the sheet)