Support Board
Date/Time: Tue, 16 Sep 2025 03:48:50 +0000
Spreadsheet only updates when a fill happened, not continuously
View Count: 54
| [2025-09-11 18:04:45] |
| Andre - Posts: 32 |
|
Hi SC Support, I noticed that on my spreadsheet for trading, the formula recalculations only happen when there is a print in the market (in this case ES) but not continuously. As an example, i have a formula that prohibits trading around the full minute mark +4 seconds, but while e.g. the sizes on the bid/offer constantly change on the chart, the spreadsheet only recalculates and gives new values when there was a print. During GLOBEX hours, it can happen that you do not have a print for 10s or so and that can screw up things for eg realtime stacking calculations. Is there a way to get the sheet to recalculate independently of fills in the market? Thank you for your help in advance. Date Time Of Last Edit: 2025-09-12 07:01:08
|
| [2025-09-15 15:56:21] |
| Sierra_Chart Engineering - Posts: 20894 |
|
This definitely should not be the case. We are quite sure, the spreadsheet is going to be updated even with a change only with the bid or ask prices.
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 |
| [2025-09-15 15:59:12] |
| Sierra_Chart Engineering - Posts: 20894 |
|
We have confirmed this is the case. Definitely the Sheet is updating, with bid and ask updates even though there is not a trade. There could not be a problem with this. That really is impossible. 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: