Support Board
Date/Time: Sat, 23 Nov 2024 02:36:51 +0000
Post From: How to wait for 2 new bars before calculating a value in the Spreadsheet alert study?
| [2024-09-20 13:50:43] |
| John - SC Support - Posts: 36238 |
|
Since you are looking for a 5 bar range, we assume that you really are wanting to look at the value 2 bars back from the current bar, that way you have the 2 bars ahead and you can then look back 2 bars. To get the Highest High over those 5 bars entering the following formula in row 3 of a formula column: =IF(ID1.SG2@5 <> 0, MAX(ID0.SG2@3:ID0.SG2@7), 0) Where ID1 is the ID of the Zig Zag study and SG2 is the subgraph that has the values from 0 - 5. We leave it to you to setup the Minimum situation. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |