Login Page - Create Account

Support Board


Date/Time: Sun, 12 Jan 2025 18:34:56 +0000



Formula Conditions

View Count: 867

[2017-03-10 17:19:22]
User104854 - Posts: 457
I have a formula that I use with 4 conditions that is TRUE if all 4 conditions are met. Can you direct me to where I can find information to have it be TRUE if say, any 2 out of the 4 conditions are met?
[2017-03-10 18:07:49]
Sierra Chart Engineering - Posts: 104368
We do not provide formula programming help. This is simply a programming help question.

It does sound somewhat complex to program that formula.
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service:
Sierra Chart Teton Futures Order Routing
[2017-03-10 20:09:26]
Sawtooth - Posts: 4149
You'll need to use the OR function with several AND functions:

=OR(
AND(condition1,condition2),
AND(condition1,condition3),
AND(condition1,condition4),
AND(condition2,condition3),
AND(condition2,condition4),
AND(condition3,condition4))
[2017-03-10 22:21:14]
User104854 - Posts: 457
I tried that and ran out of text room under the alert condition. I'm using the color bar based on alert condition study. Is there another way to go about this?
[2017-03-10 23:02:13]
User104854 - Posts: 457
Disregard. I just used the same indicator 4 times with each condition and it works fine. Thanks.

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

Login

Login Page - Create Account