Login Page - Create Account

Support Board


Date/Time: Thu, 28 Mar 2024 17:08:57 +0000



[Programming Help] - Bulding Alert - two conditions doesn't work with operator

View Count: 523

[2019-10-14 16:40:53]
User33743 - Posts: 83
Hello,
I'm trying build background color alert. I create two formulas (ID1.SG1)>300; (ID11.SG1)>(ID8.SG1), which working separatly but when put operator "AND" it doesn't work.

examle:
=(ID1.SG1)>300,AND(ID11.SG1)>(ID8.SG1) ( Id1 -Number bar calculated value, ID11- VOLUME, ID8 simple moving average based on volume)



What is wrong with this formula? ->this conditions happened on chart, so it should color background.
[2019-10-14 17:20:41]
User907968 - Posts: 800
Your AND operator is not in the correct position, refer here for guidance -

Study/Chart Alerts And Scanning: Alert Condition Formula Format
https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#AND_Function

=AND(ID1.SG1>300,ID11.SG1>ID8.SG1)

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

Login

Login Page - Create Account