Support Board
Date/Time: Thu, 20 Feb 2025 19:51:39 +0000
[Programming Help] - how to set if condition in the alert
View Count: 797
| [2021-01-17 08:01:38] |
| User61576 - Posts: 445 |
|
i have read here:Spreadsheet Functions: Using the Equivalent of COUNTIF, AVERAGEIF, MAXIF, MINIF, SUMIF and here Study/Chart Alerts And Scanning: Operators when applying to following next formula in the alert =IF((abs(sg4-sg2)>(sg4-sg3),(1-(sg4-sg3)/sg2-sg3),(sg4-sg3)/(sg2-sg3))>0.5 I am getting an error: Alert Formula Error - Chart: ESH21_FUT_CME[M] 1 Min #1 | Study: Volume Difference Bars | Error: #SYNTAX! | Formula: =IF((ABS(SG4-SG2)>(SG4-SG3),(1-(SG4-SG3)/SG2-SG3),(SG4-SG3)/(SG2-SG3))>0.5 | No alert sound/email. is this alert referring to the missing alert sound selected or it's something els I did wrong? |
| [2021-01-17 11:53:18] |
| User907968 - Posts: 832 |
|
There is a problem with the syntax, the opening and closing parentheses are not equal in number. Try removing one of the parentheses before the ABS function.
|
To post a message in this thread, you need to log in with your Sierra Chart account: