Support Board
Date/Time: Mon, 21 Apr 2025 16:10:10 +0000
Spreadsheet data becomes misaligned on chart
View Count: 67
| [2025-02-26 18:04:22] |
| User299107 - Posts: 60 |
|
Hi guys, I have some formulas within a Spreadsheet which I output to a Chart. The output is numerically accurate but within several minutes the output becomes misaligned (lags). It's as if the chart is not updating properly???? Everything is restored once I recalculate the chart, but this only lasts for a couple of minutes. If someone could assist, so that the output is accurate from a time perspective, I would be appreciative. Thanks, Eliza |
| [2025-02-26 18:31:14] |
| John - SC Support - Posts: 39378 |
|
Spreadsheets only update the most recent 10 rows in order to avoid heavy processing. So if there is older data that is changing, this will not be reflected in the chart, which it sounds like this is what you are seeing. The only way around this is to force a full recalculation. Refer to the following study that does this: Chart Recalculation - Periodic 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: