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 header |
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 header |
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 |