Very easy-to-use useful Excel sheet for calculating the positive aspects (after commissions) in bitcoin buying and selling utilizing LIFO technique.
This is one other software to satisfy demand of my priceless clients to assist them calculate buying and selling positive aspects/losses utilizing LIFO technique.
Just put your buying and selling particulars in columns A:D and it’ll present LIFO positive aspects. You can even set trade fee for purchase/sale in proportion in cells B1 and B2. Spreadsheet is able to calculate as much as 2000 transaction, which will be simply prolonged additional by dragging the formulation (rows) as per your requirement.
You will simply must fill four fields i.e. Transaction Type (purchase/sale) , Date of Transaction, BTC Quantity and Price in columns A:D and click on on the macro button LIFO. Macro and formulation in columns E:Q will course of this knowledge and you will note Gain/Loss after each transaction (for every Lot) on LIFO foundation in column N and Total LIFO Gain in column O. Besides this, spreadsheet may even present you different essential knowledge 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 each transaction.
cryptocurrency-excel-templates/bitcoin–cryptocurrency-lifo-last-in-first-out-gain-calculator-for-taxation” goal=”_blank”>https://www.eloquens.com/tool/3B4lfy9X/engineering/cryptocurrency-excel-templates/bitcoin–cryptocurrency-lifo-last-in-first-out-gain-calculator-for-taxation
Comments