Support Board
Date/Time: Wed, 05 Nov 2025 09:12:03 +0000
Post From: Compare range of individual values
| [2023-12-11 00:27:12] |
| User273277 - Posts: 87 |
|
I want to find the first swing low in the most recent 100 bars that is above the current bar low. Something like this where it returns the first occurrence: L<ID1.SG2[0:-100] But it looks like spreadsheets can not iterate over a range of values: Study/Chart Alerts And Scanning: Referencing A Range of Data "... this is not valid: =SG1[0:-10] > 100 ... This requires an iteration which is not possible with Spreadsheet formulas." The documenation page does not specify how this iteration would be done. Any help would be appreciated. |