Title Type Timestamp Account Currency Total Amount in Account Currency Buy / Sell Ticker ISIN Price per Share in Account Currency Stamp Duty Quantity Venue Order ID Order Type Instrument Currency Total Amount in Instrument Currency Price per Share FX Rate
.csv files are expected with these columns headings. Only the bold heading are used. TAB separated files are also accepted.
Rows with a duplicate ID are omitted, so if your .csv files have overlapping dates, duplicate orders will not be included.
The share price is calculated from the Account Currency (usually GBP), Total Amount in Account Currency divided by Quantity, so all Fx fees, costs, taxes are included in the calculated net share price. I have not tested any examples where the user’s account currency was not in GBP.