Support Board
Date/Time: Tue, 22 Apr 2025 06:00:38 +0000
Post From: my Effective backtest accurate trading systeme backtest mode
| [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  EURUSD.StdyCollct - Attached On 2023-02-11 16:42:53 UTC - Size: 452.14 KB - 280 views |