Support Board
Date/Time: Thu, 23 Jan 2025 05:02:08 +0000
[User Discussion] - Simple Alert
View Count: 1117
| [2014-01-20 14:25:09] |
| kirstenjd - Posts: 34 |
|
I want to activate a simple alert on my Default Worksheet. The alarm must go of when AN3<or>0. =IF(OR(AN3<0,AN3>0),1,0) =AN3<>0 I have tried both these formulas without success. DefaultWorksheetStudy >>>Settings>>>Alerts>>> (Check: Reset Alert Condition on New Bar)(Alert Sound:Alert4) Any advice, please. |
| [2014-01-21 00:53:29] |
| Sawtooth - Posts: 4162 |
|
1) The Draw Style cannot be Ignore. 2) If you are using the Spreadsheet Study study, you'll need to put a formula on the Alerts tab to get an alert when a row 3 cell goes TRUE or >0, like this for K3: =SG1 In order for the price graph to be unaffected, you'll also need to use this formula instead: =IF(AN3<>0),E3,0) 3) If you are using either of the other two spreadsheet studies, the alert is set in the study settings. Alerts for columns V-BR are combined with the setting labeled Column V-Z Alert. If you want to segregate alerts in individual columns V-BR, you'll need to set the V-Z Alert to No Alert, and put a formula that includes the ID# of the spreadsheet study, on the Alerts tab of any other study (or on the Alerts tab in Chart Settings) to get an alert when a row 3 cell goes TRUE or >0, like this for BR3: =ID1.SG60 Date Time Of Last Edit: 2014-01-21 01:25:46
|
| [2014-06-05 11:05:42] |
| James D - Posts: 9 |
|
Hello, How do I create an alert when MACD becomes greater than Zero (0)? Thank you |
| [2018-11-16 12:55:43] |
| James D - Posts: 9 |
|
Hello, How do I create an alert when Parabolic Sar change direction(from above to below price and below to above price)? Thank you |
| [2018-11-16 13:01:25] |
| Sawtooth - Posts: 4162 |
|
Here's an example: Color Background Based on Alert Condition and the Parabolic SAR (PSAR) |
To post a message in this thread, you need to log in with your Sierra Chart account: