Very easy-to-use helpful Excel sheet for hard the positive factors (after commissions) in Bitcoin buying and marketing utilizing LIFO methodology.
That is one other package to meet demand of my precious prospects to assist them calculate buying and marketing positive factors/losses utilizing LIFO methodology.
Simply put your buying and marketing particulars in columns A:D and it'll present LIFO positive factors. It's also possible to set trade fee for purchase/sale in share in cells B1 and B2. Spreadsheet is able to calculate as much like 2000 dealing, which will be simply prolonged extra by dragging the formulation (rows) as per your requirement.
You'll simply must fill 4 Fields i.e. Transaction Kind (purchase/sale) , Date of Transaction, BTC Amount and Value 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 notice Gain/Loss after each dealing (for every Lot) on LIFO foundation in column N and Complete LIFO Gain in column O. Apart from this, spreadsheet may also present you different vital knowledge e.g. Cumulative Value of BTC Bought, Cumulative Incomes from Sale of BTC, Complete BTC Bought, BTC in Hand and Value of Stability BTC after each dealing.
0 Comments