Login Page - Create Account

Support Board


Date/Time: Thu, 11 Sep 2025 15:48:08 +0000



Post From: How to wait for 2 new bars before calculating a value in the Spreadsheet alert study?

[2024-09-18 21:18:21]
John - SC Support - Posts: 41746
We are not sure how you are using Column O, but to look at a value from 2 bars prior to the current bar, you would need to reference row 5 rather than row 3. For instance, to look at the value of your ZigZag 2 bars back your formula would look like the following:
=ID35.SG6@5
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing