Support Board
Date/Time: Tue, 26 Nov 2024 10:31:53 +0000
Post From: Compare range of individual values
| [2023-12-11 17:00:51] |
| John - SC Support - Posts: 36286 |
|
Spreadsheets do not iterate, that is correct. But you can use the "EARLIESTNONZEROVALUE" to find the first instance of a Swing Low within a range of data. Refer to the following: https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#EARLIESTNONZEROVALUE_Function You would have to use multiple columns to get consecutive values to test against your condition, then have a column that gives you the answer you want. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |