Support Board
Date/Time: Sun, 02 Nov 2025 17:10:01 +0000
Spreadsheet only updates when a fill happened, not continuously
View Count: 218
| [2025-09-11 18:04:45] |
| Andre - Posts: 33 |
|
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: 21275 |
|
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: 21275 |
|
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 |
| [2025-09-16 08:35:45] |
| Andre - Posts: 33 |
|
Hi SC Support, You are right regarding bid/ask etc. not sure what was happening on my side. One question remains and that is that e.g. =SECOND(J41) only updates when there is a print. Is there any chance to get the time to update continously? I played around with the Clock - Real Time study to somehow create a work around but was not successful. Thank you in advance |
| [2025-09-17 15:11:45] |
| Sierra_Chart Engineering - Posts: 21275 |
|
We will add a new field, with the market depth update date 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 |
| [2025-09-24 20:16:23] |
| Sierra_Chart Engineering - Posts: 21275 |
|
We did add the new Market Depth Update Date-Time field but it only shows with the new version 2 fields: Spreadsheet Study Inputs: Use Column I and J Values Version 2 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: