Google Sheet Version of Bitcoin Cryptocurrency LIFO (Last In First Out) Gain Calculator
  • Google Sheet Version of Bitcoin Cryptocurrency LIFO (Last In First Out) Gain Calculator
Originally published: 21/07/2019 10:42
Last version published: 24/10/2019 11:19
Publication number: ELQ-80985-2
View all versions & Certificate
certified

Google Sheet Version of Bitcoin Cryptocurrency LIFO (Last In First Out) Gain Calculator

This is easy-to-use handy Google sheet for calculating the gains in bitcoin and other crypto trading using LIFO method.

Description
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 can be easily extended to more rows 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.

Sheet automatically highlights Sale and Buy transaction rows in Red and Green colors respectively just for more clear identification of the type of trade.

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

Please let me know if you have any question or suggestion to improve this template.

This Best Practice includes
1 PDF file with with Google Sheet URL

Acquire business license for $15.00

Add to cart

Add to bookmarks

Discuss

Further information

To calculate trading gains using LIFO mathod

Reviews

  • Be the first to review this Downloadable Tool

    Write a review


Any questions on Google Sheet Version Of Bitcoin Cryptocurrency LIFO (Last In First Out) Gain Calculator?

The user community and author are here to help. Go ahead!


0.0 / 5 (0 votes)

please wait...