Login Page - Create Account

Support Board


Date/Time: Fri, 03 May 2024 16:33:27 +0000



[User Discussion] - Alert true for remainder of session once triggered

View Count: 1493

[2013-09-26 09:00:28]
RMF2 - Posts: 43
Is there a way to have an alert stay true for the whole session once triggered?

I am using a color bar alert to show when it crosses above a line. I would like it to stay TRUE for the remainder of the session once it is triggered.

I have tried: = OR (H>ID1.SG1,SG1[-1]=1).

But the alert seems to be activated only when the first argument is TRUE and then turns off when the argument is FALSE.
[2013-09-26 21:43:02]
Sawtooth - Posts: 3992
This is not possible with Simple Alerts. However, you can do it with the Spreadsheet Study study.

Add the Spreadsheet Sstudy study, give it a name in the Spreadsheet Name field.
-Set the Draw Style of M(SG3) to your choice.

On the spreadsheet:

Cell K3:
=AND(AA4>C4,C3>AA3)
where the line output is in column AA (column C is the High).

Cell L3:
=AND(A3-INT(A3)>TIMEVALUE("09:30:00"),A3-INT(A3)<TIMEVALUE("16:00:00"))
where the session times are those between the quotes.

Cell M3:
=IF(AND(L3,K4=FALSE,K3),TRUE,IF(AND(L3=FALSE),FALSE,M4))
This is the column that will have cells that are TRUE at the first crossover and remain TRUE until the session end.

This setup will not sound an alert, but is intended to color the bars or background. It is possible to have an audible alert but it will sound on every bar.


[2013-09-29 10:28:05]
RMF2 - Posts: 43
Thank you, tomgilb.

I was hoping to "let the chart do the work" with a study that didn't use spreadsheets but, I think you're right, a spreadsheet is the only way on this one.

You listed really clean and succinct spreadsheet equations, though. Thanks!

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

Login

Login Page - Create Account