Importing External CSV Data

Spotware
11 Jan 2016, 18:24

Dear Trader,

Thank you for reporting it. We will investigate.

danny.weckhuyzen
11 Jan 2016, 23:28

Hi, is it possible to import tick-data ? In which directory they should be installed ?

Spotware
12 Jan 2016, 16:31

Dear Trader,

Currently it not possible to import tick data to backtesting mode. This feature will be available in the future. However, we cannot provide you with an ETA. Stay tuned. 

Additionally, you can post your ideas/suggestions to http://vote.spotware.com/

davidp13
27 Jul 2016, 09:25 ( Updated at: 21 Dec 2023, 09:20 )

RE:

Hi. Was this error ever sorted out? I got the same error today.

Paul_Hayes said:

Hi Spotware,

Can you help me please.

I am trying to import an external csv historical data file into cAlgo for back-testing, the file is 1 Min of data as shown below in the example snapshot.

Data File Format

The correct format for the data to be used with cAlgo is specified below:

cAlgo Specified CSV file format
•    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

The error I am getting from cAlgo when attempting to back-test is as follows:

Do you have any idea what is wrong with the data or if there is a problem with the platform import.

Thank you very much.

Paul.

 

ctid332555
29 May 2017, 23:20

RE:

Hi Spotware,

I am trying to load data in cAlgo in order to run a Backtest, but I cannot understand what's wrong with my CSV file. The data format is:

2012.07.19,12:16,1.22854,1.22871,1.2284,1.2285,50
2012.07.19,12:17,1.22854,1.22863,1.2282,1.22839,69
2012.07.19,12:18,1.2284,1.22853,1.2281,1.22822,85
2012.07.19,12:19,1.2283,1.22855,1.2282,1.2284,89
2012.07.19,12:20,1.22851,1.22874,1.228,1.22851,77
2012.07.19,12:21,1.2284,1.22862,1.2281,1.22845,48
2012.07.19,12:22,1.22834,1.22861,1.2283,1.22854,85

Can you pls help me better understanding how to load a .CVS file? Maybe it's my fault. Thanks

Spotware said:

Dear Trader,

Thank you for reporting it. We will investigate.

Spotware
18 Jul 2017, 17:27

Dear Trader,

Thanks for reporting the problem. Can you please send us the csv file at feedback@spotware.com so we can investigate further? Please also reply to this post as soon as you send it so we can check for it.

Best Regards, 

cTrader Team