Very easy-to-use helpful Excel sheet for shrewd 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 a great deal like 2000 dealings, which will be simply prolonged additive 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 cognition and you will notice Gain/Loss after each dealings (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 cognition 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 dealings.
Post a Comment