Login Page - Create Account

Support Board


Date/Time: Tue, 01 Jul 2025 03:45:10 +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: 40676
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