Support Board
Date/Time: Sat, 23 Nov 2024 05:45:49 +0000
Spreadsheet study for trading study lag
View Count: 117
| [2024-09-04 17:42:00] |
| User488241 - Posts: 34 |
|
Hello, I have a spreadsheettradingstudy that is 2000 rows and has 60 formula columns. It's nothing too complicated, just references indicators study and doing basic sum or >< calculations for buy/sell conditions. It was working fine with a calculation time of about 40-60ms on average but I tried enabling the send orders to trade service to yes. Ever since then the calculation time on the spreadsheetstudy has shot up to 4000ms. I have tried resetting SC, My computer, Lowering the # of chart days down to 2 days, shrinking the # of rows on the spread sheet (this does lower the calculation time but it is still very high). Is there something I can do to fix this issue? Thank you! |
| [2024-09-04 17:42:59] |
| User488241 - Posts: 34 |
|
I forget to mentiokn that I did set send orders to trade service back to no and it is sill lagging very badly.
|
| [2024-09-05 16:53:56] |
| Sierra_Chart Engineering - Posts: 17145 |
|
This could not be the reason: but I tried enabling the send orders to trade service to yes. Ever since then the calculation time on the spreadsheetstudy has shot up to 4000ms.
The first thing we recommend you do is to examine all of the Cells that contain data in the Sheet in the Spreadsheet, and remove anything that is unnecessary. There may be some data or formulas that you are not aware of that is causing extra calculation time. 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 |
To post a message in this thread, you need to log in with your Sierra Chart account: