Support Board
Date/Time: Wed, 05 Nov 2025 09:12:22 +0000
Post From: Compare range of individual values
| [2023-12-11 17:00:51] |
| John - SC Support - Posts: 42772 |
|
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 |