Backtesting with data from CSV file

lec0456's avatar

lec0456 since: 14 Nov 2012;

  13 Dec 2013, 16:39
Backtesting with data from CSV file

I've always wanted to do back testing without having to be connected to the server.  That way I don't even have to be connected to the internet.   But I don't have my own data.  Any suggestions?

cogs since: 02 Oct 2013;

  23 Dec 2013, 07:48

I have this:

but need 2013.07.19,00:00, etc. as stated in previous post.

The problem lies with the 'period' or decimal place when using excel for csv files.

Any ideas?

daemon's avatar

daemon since: 30 Aug 2012;

  27 Dec 2013, 14:51

You can right click -> Format Cells (highlight the column) the choose the format with the period.

jeex's avatar

jeex since: 18 Oct 2013;

  28 Dec 2013, 01:21
Suggestion

@ lec0456

You can export data from MT4 quite easy. But you have to generate them first with the Hostiry function. Then export to CSV and you have all the data you can dream of in all possible timeframes and pairs.

bendyarm's avatar

bendyarm since: 24 Dec 2013;

  28 Dec 2013, 19:56
RE: Suggestion

jeex said:

@ lec0456

You can export data from MT4 quite easy. But you have to generate them first with the Hostiry function. Then export to CSV and you have all the data you can dream of in all possible timeframes and pairs.

You can also download tick data from http://www.dukascopy.com/swiss/english/marketwatch/historical/

bendyarm's avatar

bendyarm since: 24 Dec 2013;

  29 Dec 2013, 02:40
RE:

Spotware said:

A new feature will be available in the next release of cAlgo: Backtesting with data from a CSV file.

x

Any update on a release date yet?

Thanks

Spotware's avatar

Spotware since: 23 Sep 2013;

  30 Dec 2013, 11:55
RE: RE:

bendyarm said:

Spotware said:

A new feature will be available in the next release of cAlgo: Backtesting with data from a CSV file.

x

Any update on a release date yet?

Thanks

Backtesting with data from a CSV file has already been released.

/forum/whats-new/1931

TRADERS FIRSTâ„¢ Vote for your favorite features: https://ctrader.com/forum/suggestions

cogs since: 02 Oct 2013;

  31 Dec 2013, 05:08

I get this error, any suggestions?

daemon's avatar

daemon since: 30 Aug 2012;

  31 Dec 2013, 09:24
RE:

cogs said:

I get this error, any suggestions?

Remove the first column and probably the first row.

The example in the first page is:

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

cogs since: 02 Oct 2013;

  31 Dec 2013, 13:27

I removed the first column and worked perfectly.

Thanks.