This is a very handy Excel sheet to easily calculate trading gains/losses using LIFO method.

Just put your trading details in columns A:D and it will show LIFO gains. You can also set an exchange commission for buy/sale in percentage in cells B1 and B2. The spreadsheet is ready to calculate up to 2000 transactions, which can easily be extended further by dragging the formulas (rows) as per your requirement.

You will just need to fill 4 fields i.e. Transaction Type (buy/sale) , Date of Transaction, BTC Quantity and Price in columns A:D and click on the macro button LIFO. Macro and formulas in columns E:Q will process this data and you will see Gain/Loss after every transaction (for each Lot) on LIFO basis in column N and Total LIFO Gain in column O. Besides this, the spreadsheet will also show you other important data e.g. Cumulative Cost of BTC Purchased, Cumulative Earning from Sale of BTC, Total BTC Purchased, BTC in Hand and Cost of Balance BTC after every transaction.

Alternate buy option using Cryptos:


Besides PayPal, you can also buy this calculator for any of the following cryptos. Please send the equivalent amount of crypto to any of the addresses given below and put transaction details as checkout Note. You will get the tool in your mailbox after payment confirmation.

LTC : LKFcSetKJY2xufP7UUNZdA8EbPwegKAxg3
BCH: qzkg4ws5s04nq95xrk09zlrk7vqu9g84wgv5jex69u

LIFO Gain Excel Calculator