Home >> Support Board

Support Board

Date/Time: Tue, 30 Apr 2024 11:03:43 +0000

How to Post a Message for Support

[Programming Help] - Spreadsheet questions

View Count: 620

[2019-09-14 21:04:40] #1 [Go To First Post]
User183724 - Posts: 183
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] #2 [Go To First Post]
Sawtooth - Posts: 3985
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: