Strategy testing with Candles from csv file. StockSharp

Strategy testing with Candles from csv file

4/24/2017

Shubha

We want to perform strategy backtesting on history data stored in txt file. As we understand from the samples, the txt file should be converted to S# format before we can run strategy and testing on them. Please update if this understanding is correct.

We need sample code how we can covert txt file to S# format through code. What are the classes we should look at?

Or alternatively, can we run strategy on history data stored in txt file directly? Please share sample code if this is possible.

Regards
Shubha

Tags:

Thanks:

Support from S#.Team

14 Answers

Support

Date: 4/25/2017

Send an example of your txt file.

Thanks:

Shubha

Date: 4/25/2017

Hello,

Attaching txt file where the history data is stored. Data is stored in the format date, time, O, H, L, C and Volume values separated by comma.

Thank you.

ACCN.txt 457.2KB (5)

Topic starter

Thanks:

Support

Date: 4/26/2017

Ok, we will prepare an example for you.

Thanks:

Shubha

Date: 4/27/2017

Hello! Looking forward for the example code as mentioned above, it will be really helpful.

Thank you.

Topic starter

Thanks:

Support

Date: 4/28/2017

The optimal solution is to convert your data into the s# candle format of the store. An example of a converter is attached.

CandleConverter.7z 115.9KB (8)

Thanks:

Shubha

Date: 5/3/2017

Thank you for the code. We have multiple files where the 5 minute candle data is stored for each stock on the exchange. Please recommend the best approach for running strategy on these files.

One solution is to convert all of these data to S# bin format as you have specified above. Please let me know if there are other approaches we can consider.

Thank you,

Topic starter

Thanks:

Support

Date: 5/3/2017

Ok.

Thanks:

Shubha

Date: 5/10/2017

Hello,

I am trying to run a simple SMA strategy on the converted candles using HistoryEmulationConnector on the Data folder. I am specifially using the sample code in the Lesson Video 8 - TestingAndTrading sample.

The sample works fine and shows the PnL curve when using the sample code and sample data provided with the examples.

string path = Path.GetFullPath(@"..\..\..\..\History\");
((LocalMarketDataDrive)storage.DefaultDrive).Path = path;

// создаем инструмент для тестирования
_security = new Security
{
Id = "RIM5@FORTS",
Code = "RIM5",
Name = "RTS-6.15",
PriceStep = 10,
StepPrice = 2,
Board = ExchangeBoard.Forts
};

When I change the code to point to the converted candles data folder, it does not work.

string path = Path.GetFullPath(@"..\..\..\..\History\");
string path = Path.GetFullPath(@"C:\Data\NETProjects\StockSharp\ExampleStrategy\CandleConverter\bin");

*_security = new Security
{
Id = "ACCN@NYSE",
Code = "ACCN",
Name = "ACCN",
PriceStep = 10,
StepPrice = 2,
Board = ExchangeBoard.Nyse
};

The strategy just does not execute. It does not hit the code for Onstarted of strategy and ProcessCandle.

Please advise what is missing in the data that is converted.

Thank you!

Topic starter

Thanks:

Shubha

Date: 5/10/2017

Topic starter

Thanks:

Shubha

Date: 5/10/2017

Hello,

Also, when I try to create a candle chart with the above data containing ACCN@NYSE folder, it does not create any candles. I am using SampleChart sample from Samples/Chart/Sample example that comes with the SDK. It is not able to plot the chart when I point the folder to the right folder and update the security details.

I am not sure why the data is not being read to create a chart. Maybe this is the reason why strategy is not run. Because it is not able to read the candles. Please let me know what am I missing.

Thank you.

SampleChart.png 133.9KB (14)

Topic starter

Thanks:

Support

Date: 5/11/2017

Send your code in full..

Thanks:

Sam

Date: 4/27/2019

Any resolution to this? I'm having the same problem.

Thanks:

Mikhail Sukhov

Date: 4/27/2019

The resolution was by email. We do not spread customers codes.

Thanks:

Sam

Date: 4/29/2019

Good. You wouldn't be worth your salt if you gave out customer code. Perhaps you could tell me what I'm doing wrong then when I try to load the candles in designer, it doesn't show anything using even the basic sample in the designer. The candles are in the bin format. What piece of info is missing that it won't draw them?

Thanks:

Attach files by dragging & dropping, , or pasting from the clipboard.