Login Page - Create Account

Support Board


Date/Time: Thu, 25 Apr 2024 00:10:27 +0000



[Programming Help] - Count Bars Since Alert Condition

View Count: 1499

[2019-03-11 08:58:00]
User993113 - Posts: 71
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: 3976
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: 71
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:

Login

Login Page - Create Account