Support Board
Date/Time: Mon, 25 Nov 2024 09:41:48 +0000
COLOR BAR ALERT CONDITION FORMULAS
View Count: 228
| [2024-03-20 18:32:59] |
| User357489 - Posts: 72 |
|
Hi, once again having major difficulties putting a formula together. i have 4 conditions i need for this. the conditions each work serperately, but when i combine them with "AND" it shits itself and gives syntax errors. i have tried every combination i can think of, been thru your documentation but to no avail. here are the conditions i need in order for the bar to colour "green": from numbers bars calc values (ID35 in my case). i need gamma, total vol, cum delta and #trades. sg3, 13, 10 and 12 respectively. ID35.SG3[-1] > 1000 AND ID35.SG10[-1] > ID35.SG10[-2] AND ID35.SG12[-1] > ID35.SG12[-2] AND ID35.SG13[-1] > ID35.SG13[-2], and for "red" candle color i thought id use ID35.SG3[-1] < -1000 AND ID35.SG10[-1] < ID35.SG10[-2] AND ID35.SG12[-1] > ID35.SG12[-2] AND ID35.SG13[-1] > ID35.SG13[-2]. Can SC handle multiple conditions in one alert study? i realise its quite specifi but thats the whole point. Your timely response would be appreciated. Thanks |
| [2024-03-20 18:34:32] |
| John - SC Support - Posts: 36238 |
|
What you have done is not the correct way to use AND for Alerts. Refer to the following: Study/Chart Alerts And Scanning: OR and AND Functions So your formula should be the following: =AND(ID35.SG3[-1] > 1000, ID35.SG10[-1] > ID35.SG10[-2], ID35.SG12[-1] > ID35.SG12[-2], ID35.SG13[-1] > ID35.SG13[-2]) For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
To post a message in this thread, you need to log in with your Sierra Chart account: