Clickalgo Knowledge Center
Return to Website

Data Import Issues

Please read below for common problems we have identified for creating CSV files to be imported into cTrader for backtesting.
 
 

Users PC has Incorrect Regional Time Settings

When you install Windows 10 the default time setting is 24 hours and this is what is required for this tool to work correctly, if the time is changed to AM and PM then it will not work.

Sometimes the CSV file that is created by the Market Data Converter shows the time in the 2nd column with a format of PM or AM as shown below. When you attempt to import this into cTrader for backtesting an error occurs.

 

cTrader data fuzzy 

The problem is that the Time column is incorrect it showing AM and PM, you need to change this in your regional settings on your PC to 24hrs.

The cTrader format is 16:00 and not 4:00 PM, the correct cTrader format for importing data is shown below.

 

CSV file format

In order to use trend bars from the file you need to have comma-separated CSV file with the following columns:

  • Date
  • Time
  • Open Price
  • High Price
  • Low Price
  • Close Price
  • Volume

Example:

2003.06.18,16:01,1.11423,1.11428,1.11332,1.11374,19
2003.06.18,16:02,1.11364,1.11436,1.11361,1.11405,7
2003.06.18,16:03,1.11402,1.11455,1.11400,1.11440,5
2003.06.18,16:04,1.11446,1.11461,1.11401,1.11447,14

 

Windows 10 - How To Change Clock to 24 hours

1. Click on the clock at the bottom right of your screen.

 

cTrader Clock Change 24

 

2. In the left side of the window, scroll down to ‘Formats’ and click on ‘Change date and time formats’

 

ctrader windows 10 time

3. Under ‘Short time’ select ‘hh:mm’

4. Under ‘Long time’ select ‘hh:mm:ss’

5. close the money and you are done.

 

Start again and download the historical data from Ducascopy and run the cTrader data converter wizard.