Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Fri, 26 Apr 2024 20:40:07 +0000
[User Discussion] - Profiling spreadsheet to identify what need to be optimize with acsil
View Count: 667
| [2020-08-31 16:08:06] |
| User734806 - Posts: 4 |
|
Hello, How do I profile a spreadsheet strategy (I guess while back-testing) to see where most of the CPU goes so I can identify what need to be optimized and potentially do it with ACSIL? What CPU and memory profiler do you advise to use? I'm on windows with visual studio thank you for your help Date Time Of Last Edit: 2020-08-31 16:26:47
|
| [2020-09-01 19:46:19] |
| bradh - Posts: 854 |
|
How do I profile a spreadsheet strategy (I guess while back-testing) to see where most of the CPU goes so I can identify what need to be optimized and potentially do it with ACSIL?
First thing to do is look at the Study Settings window and see how many ms each study is taking. Most likely the spreadsheet study has a higher number than the rest. I don't know of any way to profile individual sections of the spreadsheet, but there are things you can try like reducing the number of rows in the spreadsheet and not sharing spreadsheets between chartbooks. High CPU Usage | Inactive User Interface | Poor Performance | Long Time to Load Chart Data | Charts Reloading Often: 30.2 - Spreadsheet Study Spreadsheets are inherently slower than ACSIL because of the overhead involved in converting inputs to cells, calculating the cells, and converting back to outputs. |
To post a message in this thread, you need to log in with your Sierra Chart account: