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 |