Login Page - Create Account

Support Board


Date/Time: Tue, 14 Oct 2025 22:34:39 +0000



[Locked] - Simple formula

View Count: 112

[2025-09-18 11:22:05]
yitz - Posts: 5
Can you please tell me why the following formula isn't working;
AND(
ABS(ID1.SG11) >= 0.10,
OR(
AND(H >= ID6.SG1 - 10*TICKSIZE, L <= ID6.SG1 + 10*TICKSIZE),
AND(H >= ID6.SG2 - 10*TICKSIZE, L <= ID6.SG2 + 10*TICKSIZE),
AND(H >= ID6.SG3 - 10*TICKSIZE, L <= ID6.SG3 + 10*TICKSIZE),
AND(H >= ID6.SG4 - 10*TICKSIZE, L <= ID6.SG4 + 10*TICKSIZE),
AND(H >= ID6.SG5 - 10*TICKSIZE, L <= ID6.SG5 + 10*TICKSIZE),
AND(H >= ID6.SG6 - 10*TICKSIZE, L <= ID6.SG6 + 10*TICKSIZE),
AND(H >= ID6.SG7 - 10*TICKSIZE, L <= ID6.SG7 + 10*TICKSIZE),
AND(H >= ID6.SG8 - 10*TICKSIZE, L <= ID6.SG8 + 10*TICKSIZE),
AND(H >= ID6.SG9 - 10*TICKSIZE, L <= ID6.SG9 + 10*TICKSIZE),
AND(H >= ID6.SG10 - 10*TICKSIZE, L <= ID6.SG10 + 10*TICKSIZE),
AND(H >= ID6.SG11 - 10*TICKSIZE, L <= ID6.SG11 + 10*TICKSIZE),
AND(H >= ID6.SG12 - 10*TICKSIZE, L <= ID6.SG12 + 10*TICKSIZE),
AND(H >= ID6.SG13 - 10*TICKSIZE, L <= ID6.SG13 + 10*TICKSIZE),
AND(H >= ID6.SG14 - 10*TICKSIZE, L <= ID6.SG14 + 10*TICKSIZE),
AND(H >= ID6.SG15 - 10*TICKSIZE, L <= ID6.SG15 + 10*TICKSIZE),
AND(H >= ID6.SG16 - 10*TICKSIZE, L <= ID6.SG16 + 10*TICKSIZE),
AND(H >= ID6.SG17 - 10*TICKSIZE, L <= ID6.SG17 + 10*TICKSIZE),
AND(H >= ID6.SG18 - 10*TICKSIZE, L <= ID6.SG18 + 10*TICKSIZE),
AND(H >= ID6.SG19 - 10*TICKSIZE, L <= ID6.SG19 + 10*TICKSIZE),
AND(H >= ID6.SG20 - 10*TICKSIZE, L <= ID6.SG20 + 10*TICKSIZE)
)
)

it seems that sierra is not understanding to only highlight bars when there is at least 10% difference between the bid and ask.
[2025-09-18 14:58:40]
John - SC Support - Posts: 42379
This is a repeat posting.
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