Login Page - Create Account

Support Board


Date/Time: Tue, 16 Sep 2025 03:56:16 +0000



Post From: Spreadsheet only updates when a fill happened, not continuously

[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