Login Page - Create Account

Support Board


Date/Time: Wed, 01 May 2024 22:19:14 +0000



Multiple spreadsheets

View Count: 682

[2016-10-31 12:26:01]
joer - Posts: 41
I have a chartbook with 2 5 minute charts, one for es and one for cl and both have the same 30 days of intraday data loaded. I created a spreadsheet system for trading that has 2 sheets, sheet1 for the es chart and sheet2 for the cl chart. I ran the Autotrade system replay backtest separately for each one and noted the results. When I ran the es backtest I disabled autotrading on sheet2 for the cl chart by setting cell J28 to 1 and did the reverse when I ran the cl test. Then I enabled autotrading on both sheet1 and sheet2, checked the replay box that enables the test "For all charts in chartbook", set the interval to 1 second and reran the backtest. The results were significantly different even though neither spreadsheet uses any information from the other. Can you tell me what causes this; are there any settings I need to change for this to work properly. My goal is to be able to autotrade multiple symbols simultaneously.
[2016-10-31 17:16:44]
Sierra Chart Engineering - Posts: 104368
How did you do this?:
I ran the Autotrade system replay backtest separately for each one

checked the replay box that enables the test "For all charts in chartbook", set the interval to 1 second and reran the backtest.
This is a different type of back test.

Also refer to:
http://www.sierrachart.com/index.php?page=doc/Backtesting.php#BackTestingMultipleCharts
http://www.sierrachart.com/index.php?page=doc/Backtesting.php#DifferencesBackTestRealTime
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service:
Sierra Chart Teton Futures Order Routing

To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account