To download the excel Closed Positions report: Account > P/L Analysis > Closed Positions > Export.
The Closed Positions excel report follows the FIFO valuation method and can be read as:
- Amount – this is the amount/number of units of the closed position e.g. for a sell transaction of 55 units of XYZ at GBP 16, then the ‘Amount’ of 55 represents the closed position
- Amount Open – the amount/ number of units purchased e.g. 50 units of XYZ were purchased at a price of GBP 15, then the ‘AmountOpen’ is 50 units. A further 10 units of XYZ are purchased at a price of GBP 16.50 and there is another ‘AmountOpen’ registered of 10 units
- Amount Close – is the amount/ number of units that have been closed of a specific open position. A close position of 55 units is made up first by closing the 50 units open position and then partially closing the 10 units open position - this follows the FIFO valuation method
Below is an illustration of the above examples: