Login Page - Create Account

Support Board


Date/Time: Mon, 25 Nov 2024 14:57:30 +0000



Combining formulas to one Alert Condition

View Count: 187

[2024-02-29 16:02:13]
User14953 - Posts: 236
How to combine these formulas into a single 'Color Bar Based on Alert Condition' study alert?

four black candles
O[-1]>C[-1] and O[-2]>C[-2] and O[-3]>C[-3] and O[-4]>C[-4]

forming lower lows
C[-1]<C[-2] and C[-2]<C[-3] and C[-3]<C[-4]

followed by a white candle
O<C

that opens below the prior close and closes above the first day's open.
O<C[-1] and C>O[4]
Date Time Of Last Edit: 2024-02-29 16:05:05
[2024-02-29 17:47:53]
John - SC Support - Posts: 36244
Since these are all conditions that need to be put together with AND, you would just use a single AND() function and put everything into it:
=AND(O[-1] > C[-1], O[-2] > C[-2], O[-3] > C[-3], O[-4] > C[-4], C[-1] < C[-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:

Login

Login Page - Create Account