Support Board
Date/Time: Tue, 22 Apr 2025 05:16:51 +0000
my Effective backtest accurate trading systeme backtest mode
View Count: 653
[2023-02-05 17:51:09] |
User719206 - Posts: 93 |
Assuming that the accurate trading systeme backtest mode "all chart in chartbook" is slower than the other ones . neverless I timed my replay to know how fast it's going and get this result. context :new powerfull computer , GBPUSD FXCM, 9 chart , update interval 100 ms , unit storage 4 sec , speed replay 20 and more i made different test the result is the same. Test 1 : 1 spreadshhet system trading, 18 vbp study , 300 row , 24 column =>>> effective speed : 1.2 Test 2 : 1 spreadshhet system trading, 0 study , 300 row , 24 column =>>> effective speed : 2 Test 3 : 1 empty spreadshhet system trading, 0 study , 1 row , 1 column =>>> effective speed : 3 I try to improve the effective speed of my backtest for 2 weeks following each your advice and I just made that test, the progression make sens ,but my question is the following: Can I Hope better ? the result of the test 3 is it normal ? with no study , 1 column and 1 row in my empty spreasheet is it normal to get a maximum effective speed of 3 ? Or there is something somewhere which affect the speed ? Date Time Of Last Edit: 2023-02-06 11:06:53
|
[2023-02-08 23:12:53] |
Sierra_Chart Engineering - Posts: 19290 |
Seems like you should be able to get a much higher speed than that. After changing the Intraday Data Storage Time Unit, did you fully re-download the data in the chart? 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, use the Teton service: Sierra Chart Teton Futures Order Routing |
[2023-02-11 15:48:55] |
User719206 - Posts: 93 |
yes I Re downloaded after change the storage unit , I Did some change which improved a little the result without study , I use the same spreadsheet for all chart , I increased "tick size" and disableded "split data record" , as mentionned in the CPU perdofermance in your doc , I watched this doc because i have some lag in real time (i hope to fix it with sub instance ), but the CPU usage in my task manager is ok. context :new powerfull computer , EURUSD FXCM, 9 chart , update interval 100 ms , unit storage 1 sec , speed replay 20 and more i made different test the result is the same. test 1: 9 chart on the same spreadsheet (empty spreadsheet), 300 row , 26 column , 0 study : effective speed x 8 if i add my formulas in spreadsheet x 3 so my formula are slowing the replay test 3: 9 chart , 0 spreadsheet , 18 vbp study : effective speed x 3.5 so the 18 vbp are slowing the replay drasticaly even without spreadsheet test 4: 9 chart on the same spreadsheet (FULL spreadsheet with all formula ),18 vbp study , 300 row , 26 column : effective speed x 1 So it looks that vbp and spreadsheet formula affect drasticaly the speed , but without them i get "only " x 8. I dont know how to improve the vbp probleme , maybe I ask too much for the softwear , for the spreadsheet maybe all the formula are over , I Wrote some formula out of the "formula colomn" ( k3:an302, for my 26 column 300 row) dos it affect the performance ? What are my option ? Date Time Of Last Edit: 2023-02-11 21:35:46
|
Private File ![]() |
[2023-02-14 01:30:23] |
User719206 - Posts: 93 |
attached here my chartbook too.
|
![]() |
[2023-02-17 07:40:46] |
User719206 - Posts: 93 |
Far away from me the idea to put on you any pression , do you have a start of explaination or of solution for me ?
|
[2023-02-23 17:38:33] |
Sierra_Chart Engineering - Posts: 19290 |
It is too involved for us to be doing detailed analysis of this particular case. Make sure that the Input Volume at Price Data with the Spreadsheet study is set to No. 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, use the Teton service: Sierra Chart Teton Futures Order Routing Date Time Of Last Edit: 2023-02-23 17:38:44
|
To post a message in this thread, you need to log in with your Sierra Chart account: