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.
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.
-
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.
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 :
-
Go to Integrations and choose Spreadsheet (CSV file).
-
Choose an Account Name. This can be whatever you want. No pressure, you can change it later if needed.
-
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.
-
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.
-
Click Add the account to confirm.
-
Click Import new trades, then Choose File.
-
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
