Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Wed, 15 Oct 2025 04:32:54 +0000

How to Post a Message for Support

Post From: Simple formula

[2025-09-18 11:20:59]
[Go To First Post]
yitz - Posts: 5
I Know you don't like formula questions. I have worked so hard to understand why my simple formula won't work. 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.

Thank you