Box 4301, Road Town, Tortola, BVI.Įxness ZA (PTY) Ltd is authorised by the Financial Sector Conduct Authority (FSCA) in South Africa as a Financial Service Provider (FSP) with registration number 2020/234138/07 and FSP number 51024.
The registered office of Exness (VG) Ltd is at Trinity Chambers, P.O. “Don” Martina 31, Curaçao.Įxness (VG) Ltd is authorised by the Financial Services Commission (FSC) in BVI with registration number 2032226 and investment business licence number SIBA/L/20/1133. is a Securities Intermediary registered in Curaçao with registration number 148698(0) and authorised by the Central Bank of Curaçao and Sint Maarten (CBCS) with licence number 0003LSI. The registered office of Exness (SC) Ltd is at 9A CT House, 2nd floor, Providence, Mahe, Seychelles.Įxness B.V. Please let me know if you have any question or suggestion to improve this template.Exness (SC) Ltd is a Securities Dealer registered in Seychelles with registration number 8423606-1 and authorised by the Financial Services Authority (FSA) with licence number SD025. Similarly Summary highlights Stocks with Loss in Orange and Stocks with Profit in Green. Sheet highlights Sell transactions in Orange and Buy Transaction in Green. You may show or hide them as per your choice.Ģ.Ĝolumn AC shows Error message if user inputs (by mistake) a higher value of Sell quantity for any stock than its Buy quantity.ģ. Ratio of Balance Stock: To display cost of balance stock (in percentage) for the top 10 most weighted stocks in user’s portfolio.Ĥ.Ĝost of Balance Stock: To display cost of balance stock for the top 10 most weighted stocks in user’s portfolio.ġ.Ĝolumns T:X contain formulas for calculating intermediate results. Top Losers: To display top 10 stocks with the worst returns in ascending order.ģ. Top Gainers: To display top 10 stocks with the best returns in descending order.Ģ. It also shows Total of all trades in 1st row.Ĭhart sheet displays 4 different charts for graphical representations of important statistics:ġ. It shows Number of Stocks Purchased/Sold/In Hand, Cost of Stocks Purchased/ Sold/In Hand, Proceeds from Sale of Stock, FIFO Gain, Applicable Tax and Percentage Return for every stock. Summary sheet displays stock-wise summary of all trades. Cumulative Cost of Stock Purchased, Cumulative Proceeds from Sell of Stock, Number of Stocks Purchased/ Sold /In Hand after every transaction. Besides this, spreadsheet will also show you other important data e.g. You will see Gain/Loss after every sell transaction on FIFO basis in column AA. For USD transaction the value in column H could be 1 or leave the cell empty.Įxcel formulas will automatically calculate FIFO gains and other important data after every transaction in separate rows. If you trade in non-USD currency please put USD Conversion Rate for that transaction in column H. Transaction Type (buy/sale), Date & Time of Transaction, Stock Ticker, Quantity, Price etc. You will just have to put your trading details i.e.
Prepare raw data for your trades in similar format/layout as shown in Raw Data Tab.Ģ.Ĝopy/Paste Special (Values) the raw data in columns A:H in Trade Sheet.ģ.ğormulas in columns I:AB in Trade sheet will calculate and show important data after every transaction and stock-wise summary of all trades will be displayed in Summary sheet. Weighted average cost of capital (wacc)Įquity stock trading calculator stock trading calculator fifo calculator share trading calculator shares trading excel sheet shares trading fifo calculator fifo equity calculator fifo excel sheet fifo profit calculatorĮasy-to-use Excel calculator for calculation of profits in equity stocks trading using FIFO method.ġ.International financial reporting standards (ifrs).
0 kommentar(er)
