Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Fri, 21 Feb 2025 18:32:05 +0000

How to Post a Message for Support

Post From: how to set if condition in the alert

[2021-01-17 08:01:38]
[Go To First Post]
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?