Support Board
Date/Time: Wed, 05 Nov 2025 03:24:52 +0000
[Programming Help] - Is there a study/method that can remove all negative values from another study's output?
View Count: 402
| [2023-12-31 21:51:01] |
| gjockey - Posts: 48 |
|
Hello, For example, is there a way to apply a moving average study to only the positive values of a "Ask Bid Volume Difference Bars" study? ie. is there a process or study that can remove the negative numbers from the "Ask Bid Volume Difference Bars" study output so that I can then apply a moving average to the remaining positive only values? Thanks |
| [2024-01-01 16:52:18] |
| Sawtooth - Posts: 4285 |
|
Try this: - Add the Spreadsheet Formula study, with a formula like this in its Formula field: =IF(ID1.SG4>0,ID1.SG4,0) where ID1.SG4 is the Ask Bid Volume Difference Bars study's Close. Hide this study. - Add the Moving Average - Simple Skip Zeros study, 'Based On' the Spreadsheet Formula study. |
To post a message in this thread, you need to log in with your Sierra Chart account: