Support Board
Date/Time: Wed, 17 Dec 2025 20:41:26 +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: 43520 |
|
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 |