How to import your trades from a CSV file

You can import your trades from a CSV file. The file has to have the following fields.

Compulsory fields

Column header1 Description Accepted values Example
Date The date of the trade. YYYY-MM-DD (ISO 8601 date format) 2020-12-30
Security ID The ISIN code of the security for stocks and ETFs or symbol for cryptocurrencies (e.g. BTC or ETH). ISIN or cryptocurrency symbol US0378331005
Trading currency A currency in which the instrument was bought or sold. Three-letter (alphabetic) currency codes (ISO 4217 currency codes) USD
Unit price Price per share in the trading currency. Positive decimal number 3.64
Quantity The amount of shares bought or sold. The quantity is positive when you bought new shares and negative when you sold some shares. Decimal number -3

Optional fields

Column header1 Description Accepted values Example
Fee amount The total transaction/brokerage fee paid for the trade in the fee currency. If you fill in this field, you also have to specify fee currency. Positive decimal number 1.23
Fee currency The currency in which the fee was paid. Three-letter (alphabetic) currency codes (ISO 4217 currency codes) EUR

Example file

date security_id trading_currency unit_price quantity fee_amount fee_currency
2020-01-02 US0378331005 USD 296.24 16 8 EUR
2020-01-02 BTC USD 6946.82 1
2020-04-01 IE00B4L5Y983 USD 47.92 208 8 EUR
2020-10-01 IE00B4L5Y983 USD 64.61 -154 8 EUR

  1. All field names are case insensitive and names containing multiple words can be separated by an underscore. So for example for unit price, all following column headers are valid: Unit price, Unit Price, unit price or unit_price