Hi, I want to use excel to track my capital gains from my cryptocurrencies. If you don't know what cryptocurrencies are, just assume they're stocks, as it's the same thing for all intents and purposes.
Basically whenever I buy or sell a crypto, I want to enter the trading symbol (e.g. BTC), how much I bought or sold, the price per coin, and the fees.
I then want the spreadsheet to automatically calculate my capital gains whenever I sell, using LIFO accounting.
Is this possible?