LIFO Gain Calculator for Bitcoin Cryptocurrency Equity Stocks Trading

Description
This is another tool to fulfill the demand of my valuable customers to help them calculate trading gains/losses using LIFO method.

The spreadsheet is ready to calculate up to 2000 transactions, which can be easily extended as per your requirement.


How to Use:
(Please make sure to enable the macro while opening the file)
1. Create separate tabs for all your Coins/Stocks by copying the COIN tab and then renaming it as the Coin/Stock code.
2. Arrange the transaction data (in sorted order by dates) and paste it into the Coin/Stock sheet.
3. Formulas in the tabs will check for some common data entry mistakes and show errors in top rows by highlighting the cells to help you correct those mistakes. When you correct the mistake error message disappears.
4. Click on the LIFO button (shown in cell C1 in every Coin/Stock tab). It will run a macro to calculate the LIFO gains. You need to click on the LIFO button every time you make changes in your transaction data to recalculate the data. The LIFO button only calculates the data inside the tab, so you need to click this button on all the tabs one by one.
5. After calculating the LIFO gains for all tabs you can see their summary in the Summary sheets. Just put the tab name in column B of the Summary sheet. It will fetch a summary from that tab and show it in a row. It is ready to show up to 100 rows (which can be extended as per your needs).




I have spent several hours implementing this complex LIFO-based calculation into a very easy-to-use format.

Please let me know if you have any questions or suggestions to improve this template. If you want further customization, I will be happy to make changes as per your requirement for a reasonable fee.