Support Board
Date/Time: Sun, 02 Feb 2025 14:42:04 +0000
[Programming Help] - Spreadsheet questions
View Count: 696
| [2019-09-14 21:04:40] |
| User183724 - Posts: 191 |
|
is there a way to determine the value of an event that happened n bars ago? how do you loop / count backwards in a sheet to the event in question and then determine that events value? I read this: Formula to Count Bars Since An Event Spreadsheet Example Formulas and Usage and this is on track to what i'm looking for. any assistance appreciated |
| [2019-09-15 04:33:42] |
| Sawtooth - Posts: 4164 |
|
This will return the Volume 8 bars ago: =OFFSET(F3,8,0) If you want to return the value at the most recent event some unknown bars ago, e.g. in P3: =IF(Event,O3,P4) The most recent event could be in any column at any row, and the value in column O at that row is made persistent until another event, or to the current row (Row 3). There are also other ways to return values at previous events. |
To post a message in this thread, you need to log in with your Sierra Chart account: