Support Board

Date/Time: Tue, 04 Nov 2025 02:11:42 +0000

[Programming Help] - Logic for calculating an average of only specific bars

[2021-08-18 17:06:30] #1 [Go To First Post]
BenjFlame - Posts: 342
Hi, what's the general logic for calculating an average but only of bars that meet a special condition? Say I want to calculate average range of only up bars (Close > Open). I could create an intermediate subgraph with fabs(Open - Close), but won't there be gaps in the subgraph? How to handle this situation?

[2021-08-18 18:12:00] #2 [Go To First Post]
Sawtooth - Posts: 4285
This spreadsheet example could be modified to do what you want: Spreadsheet Example Formulas and Usage: Simple Moving Average - Skip Zeros

To post a message in this thread, you need to log in with your Sierra Chart account: