Support Board
Date/Time: Sat, 05 Jul 2025 18:47:06 +0000
[Programming Help] - Count Bars Since Alert Condition
View Count: 1940
| [2019-03-11 08:58:00] |
| User993113 - Posts: 77 |
|
I need to count the number of bars since the last time an Alert Condition occured. Is there a way to do this with a study or a spreadsheet formula? Thank You |
| [2019-03-11 13:14:36] |
| Sawtooth - Posts: 4234 |
|
You can do it with a spreadsheet study. Here's an example: Spreadsheet Example Formulas and Usage: Formula to Count Bars Since An Event |
| [2019-03-11 18:40:32] |
| jenda3 - Posts: 21 |
|
Or you can use Spredsheet study with this formula IF(ID16.SG1>0,ID11.SG1[-1]+1,0) ID16 is Alert condition and ID11 is Spredsheet study. And for Spredsheet study subgraph use draw stlye: line
|
| [2019-03-13 09:37:58] |
| User993113 - Posts: 77 |
|
tomgilb and jenda3 thank you , it's working.
|
To post a message in this thread, you need to log in with your Sierra Chart account: