How to import trades with a CSV file

Written by John
Updated 7 months ago

When working with FixyTrade, you can use CSV files to import you trades into FixyTrade. This allows you to import trades from all brokers worldwide and from all existing assets. To do this we use CSV integration.

By importing your trades with the automatic CSV file import feature, we automatically convert your trades in FixyTrade.

In this article, we will show you how to import your trades with a CSV file and how to convert your spreadsheets (Excel, Google Sheet) easily to import them into FixyTrade.

Important: FixyTrade does not currently support CSV files from brokers. It will therefore be necessary to copy your data using the CSV file format shown below.

CSV file structure

The CSV file contains 10 columns. Below is an example of the expected CSV file. It is important not to change the design or the title of the columns.

Columns description

  • TradeId

Accepted format: 1, 2, 3...

This number is mandatory and must be unique for each trade. We recommend that you include the number "1" at the top of the list and then continue with "2", "3", and so on.

  • Open Date/Time

Accepted format: DD/MM/YYYY hh:mm:ss

This is the date and time your trade was opened. The oldest trade should be the first on the list.

It is important to respect the following structure: DD/MM/YYYY hh:mm:ss

Example: 10/10/2022 07:26:00

  • Close Date/Time

Accepted format: DD/MM/YYYY hh:mm:ss

This is the date and time that your was closed.

It is important to respect the following structure: DD/MM/YYYY hh:mm:ss

Example: 10/10/2022 08:26:00

The "Close Date/Time" cannot be an earlier date and time than the "Open Date/Time".

  • Symbol

Accepted format: Numbers and letters without special characters, deposit, withdrawal

This is the asset of the trade. It can be an index (DAX), a stock (APPLE), a currency (EUR/USD), a cryptocurrency (BTC/USD) or any other asset! You can indicate what you want in this field.

You can also put "deposit" or "withdrawal". In this case, please write it in lower case as indicated above.

  • Side

Accepted format: BUY or SELL

Indicate in this column whether your trade was buy or sell.

Please leave this box blank if it was a deposit or a withdrawal.

  • Size

Accepted format: Number (Example: 15, 37...)

Indicate in this column the size of your trade.

This column supports five-digit values maximum after decimal "0.00000". If you put for example six-digit values or more, like "0.000001", it will not be supported and can result in an error.

Please leave this box blank if it was a deposit or a withdrawal.

  • Entry

Accepted format: Number (Example: 15199.06)

Indicate in this column the entry price level of your trade.

Please leave this box blank if it was a deposit or a withdrawal.

  • Exit

Accepted format: Number (Example: 15206.19)

Indicate in this column the exit price level of your trade.

Please leave this box blank if it was a deposit or a withdrawal.

  • Cost

Accepted format: Number (Example: 3, 10, 18.12)

Indicate in this column your broker's fee for the trade.

Please enter a positive number.

  • Profit

Accepted format: Number (Example: 12.87, -23,92)

Indicate in this column the profit or loss earned.

If it is a profit or a deposit, you must indicate a positive number (Ex: 40). If it is a loss or a withdrawal, you must indicate a negative number (Ex: -23).

Import your CSV file in FixyTrade

To import your trades into FixyTrade, your CSV file must follow the structure explained above. If your CSV file does not respect this structure, you will get an error message and you will not be able to import your file.

We recommend that you also follow a chronological structure for all transactions. The oldest ones should be at the top of the file.

1 - Use the CSV file template

In order to help you, we have created a CSV template that you can import directly into FixyTrade. This will allow you to understand how it works. It's quick and easy.

Download CSV file template

After downloading it, we recommend that you use it to add your trades, deposits and withdrawals by following the procedure below.

2- Add your trades

Add your trades by replacing the information of the file by yours and by respecting the structure of the columns of the file.

Here are for example two trades, a winner and a loser:

3- Add your deposits or withdrawals

Add your deposits or withdrawals by replacing the information of the file by yours and by respecting the structure of the columns of the file.

Here are for example one withdrawal and one deposit:

A deposit is always a positive number and a withdrawal is always a negative number.

4 - Save the spreadsheet file (Excel, Google Sheet, Numbers) as CSV file

To work, the import can only be done with a file format: .csv

Example: template-csv-fixytrade.csv

Depending on your software (Excel, Google Sheet, Numbers...), we recommend that you check with the developer about the process of saving in CSV format.

This will often be indicated as below:

5 - Import the CSV file in FixyTrade for the first time

Once you have added your trades and saved your file, it is time to import it into FixyTrade.

To import your file for the first time into FixyTrade, we will need to use the CSV functionality in FixyTrade :

  1. Go to Integrations and choose Spreadsheet (CSV file).

  2. Choose an Account Name. This can be whatever you want. No pressure, you can change it later if needed.

  3. Enter your Account Balance and Open Date/Time. Be careful because you will not be able to add trades before this date. We recommend that this date be the date of your oldest trade.

  4. Choose the Account Type. Is this a real account or a demo account? Be careful because you will not be able to modify this choice afterwards.

  5. Click Add the account to confirm.

  6. Click Import new trades, then Choose File.

  7. To confirm, click on Import

Please be patient, your trading data is being processed and will be automatically imported into FixyTrade.

6 - Import new trades with CSV file

If you then wish to add new trades, it is possible. However, we advise you to keep the same file that you used for your first import, and add new trades to your file just below the older ones.

You will then just have to add the new file containing all your trades. FixyTrade will automatically add your new trades to your account.

Import errors

If you get an error message when importing, please check that you are following the column structure as shown above.
If your file seems to be correct, please contact support and they will be happy to help you.

Did this answer your question?