Bitcoin Cryptocurrency LIFO Gain Google Sheet Calculator

"Bitcoin Cryptocurrency LIFO Gain Google Sheet Calculator" is a very easy-to-use, handy Excel sheet for calculating the gains in Bitcoin and other crypto trading using LIFO method.

Google Sheet is ready to calculate FIFO gains up to 2000 transactions, which can easily be extended further by dragging the formulas as per your requirement.

Sheet automatically highlights the rows for Buy and Sell transactions in Green and Orange colors so user can easily identify a Buy or sell transaction.

Google Sheet Version of Bitcoin Cryptocu

Just put your trading details in columns A:D and it will show LIFO gains. You can also set exchange commission for buy/sale in percentage in cells B1 and B2. Spreadsheet is ready to calculate up to 2000 transaction, which can be easily 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, 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.

Acquire business license from Eloquens marketplace (Use coupon code FIFOLIFO to get discount)


Please send equivalent amount ($19) to the addresses given below and email your transaction detail to You will get the tool in your mailbox after payment confirmation.

BTC : 1NYqYEUGY7h1cbKVkW12wmFfcZMnv6DEa7

ETH : 0x3Cbd9480E480f1d755E5b2389b0E57cABE41e982

LTC : LKFcSetKJY2xufP7UUNZdA8EbPwegKAxg3