Backtesting with data from CSV file

Spotware's avatar

Spotware since: 23 Sep 2013;

  19 Sep 2014, 11:24
Backtesting with data from CSV file

AlexanderRC said:

Very encouraging screenshot. Any predictions when optimizer will be released?

Optimization is currently in beta stage. You can check it in Spotware cAlgo. We plan to release Optimization for all our brokers in 2 weeks.

TRADERS FIRST™ Vote for your favorite features: https://ctrader.com/forum/suggestions

emeeder since: 06 May 2014;

  06 Oct 2014, 22:20

Any idea if backtesting multiple symbols and timeframes will be available soon?

Are there any other options for me available anywhere where i can backtest multiple currency/symbol cbots?

Spotware's avatar

Spotware since: 23 Sep 2013;

  07 Oct 2014, 10:01
RE:

emeeder said:

Any idea if backtesting multiple symbols and timeframes will be available soon?

Are there any other options for me available anywhere where i can backtest multiple currency/symbol cbots?

multi-timeframe backtesting is already available. We cannot provide an ETA but multi-symbol backtesting is planned.

TRADERS FIRST™ Vote for your favorite features: https://ctrader.com/forum/suggestions

asdk since: 18 Oct 2014;

  28 Oct 2014, 15:34
RE: RE: RE:

Spotware said:

chanet said:

Spotware said:

Tick data backtesting has been released:

Hello, From which date I can use this new feature tick data backtesting?

The available data range depends on specific Symbol and Broker. You can check the available data range by using data range slider

Is tick data being downloaded from broker server to user's computer? if yes, where can i find them? if no, would like to know how reliable is tick data backtest in calgo. afaik, in mt4, tick data has to be downloaded locally so not sure if calgo does the same?

and it also seems like users need to be connected to the internet to run a backtest, why?

Spotware's avatar

Spotware since: 23 Sep 2013;

  29 Oct 2014, 09:30

Is tick data being downloaded from broker server to user's computer? if yes, where can i find them? if no, would like to know how reliable is tick data backtest in calgo. afaik, in mt4, tick data has to be downloaded locally so not sure if calgo does the same?

cAlgo automatically downloads tick data from Spotware's servers. Tick data is broker specific. Tick data is 100% reliable because it contains every tick. You can find tick data on your machine in the following directory:

C:\Users\%UserName%\AppData\Roaming\%BrokerName%-cAlgo\BacktestingCache\Ticks

and it also seems like users need to be connected to the internet to run a backtest, why?

We plan to remove this restriction in the future. Thank you for your feedback.

TRADERS FIRST™ Vote for your favorite features: https://ctrader.com/forum/suggestions
AlexanderRC's avatar

AlexanderRC since: 04 Feb 2014;

  29 Oct 2014, 15:45
RE:

Spotware said:

Is tick data being downloaded from broker server to user's computer? if yes, where can i find them? if no, would like to know how reliable is tick data backtest in calgo. afaik, in mt4, tick data has to be downloaded locally so not sure if calgo does the same?

cAlgo automatically downloads tick data from Spotware's servers. Tick data is broker specific. Tick data is 100% reliable because it contains every tick. You can find tick data on your machine in the following directory:

C:\Users\%UserName%\AppData\Roaming\%BrokerName%-cAlgo\BacktestingCache\Ticks

For every date there is a separate file in folder named after the symbol. The files are in a proprietary format with scrambling (reversible encryption). The only value of looking at them is to check whether the specific date and symbol has been cached or not.

and it also seems like users need to be connected to the internet to run a backtest, why?

We plan to remove this restriction in the future. Thank you for your feedback.

Please add the ability to use user specified tick data from a CSV file at the same time.

Romanov Capital -- NDD STP broker \\\ https://en.romanovcapital.com \\\ Custom Robot and Indicator development \\\ email: calgo(at)romanovcapital.com

NonciAzzecco since: 08 Dec 2014;

  26 Jan 2015, 17:20
RE: Formatting proper CSV File for Backtesting and optimisation

Hi

Using Tickhistory Lite, and triking a little the output format I can easily export data for backtesting and optimisation. This is a short examples of data for EURUSD. Unfortunately It does not work The parse did not like it. The only thing I can see is that volume is not an integer but a float number,

2014.12.24,00:01,1.21747,1.21772,1.21747,1.21768,46.9399999380112
2014.12.24,00:02,1.21768,1.21768,1.21768,1.21768,11.2000000476837
2014.12.24,00:03,1.21768,1.21774,1.21768,1.21774,21.9799998998642
2014.12.24,00:04,1.21775,1.21776,1.21774,1.21776,39.1200000047684
2014.12.24,00:05,1.21776,1.21777,1.21776,1.21777,8.96000003814697
2014.12.24,00:06,1.21777,1.21778,1.21775,1.21775,10.2300000190735

Any Idea how to fix it?

Thank you

Spotware said:

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

Before backtesting, you will have the option to choose data source - Either one minute trend bars from a broker server or one minute trend bars from a CSV file on your local disk. If you choose to use a CSV file you will need to specify its location, after which cAlgo will analyze the file and adjust minimum and maximum available dates for backtesting.

CSV file format

In order to use trend bars from the file you need to have comma-separated CSV file with 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

SwapBridgeCapital's avatar

SwapBridgeCapital since: 01 Oct 2014;

  01 Feb 2015, 15:22
tick

 The files are in a proprietary format with scrambling (reversible encryption). The only value of looking at them is to check whether the specific date and symbol has been cached or not.

Will the tick data be available for multipurpose in the future ( without  encryption). 

AlexanderRC's avatar

AlexanderRC since: 04 Feb 2014;

  02 Feb 2015, 18:46
RE: tick

RedRhinoFX said:

 The files are in a proprietary format with scrambling (reversible encryption). The only value of looking at them is to check whether the specific date and symbol has been cached or not.

Will the tick data be available for multipurpose in the future ( without  encryption). 

As has been suggested elsewhere on this forum you can write a simple cBot which would log the ticks in any format you like. Maybe even someone has already written it.

Romanov Capital -- NDD STP broker \\\ https://en.romanovcapital.com \\\ Custom Robot and Indicator development \\\ email: calgo(at)romanovcapital.com

Nobody since: 14 Jan 2016;

  14 Jan 2016, 18:53
RE: RE: Formatting proper CSV File for Backtesting and optimisation

This post was removed by moderator because it duplicates another post. /forum/calgo-support/7782