Support Board
Date/Time: Sat, 20 Dec 2025 02:07:38 +0000
Post From: Compare range of individual values
| [2023-12-11 17:00:51] |
| John - SC Support - Posts: 43555 |
|
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 |