Support Board
Date/Time: Tue, 14 Oct 2025 22:31:58 +0000
Simple formula
View Count: 182
| [2025-09-18 11:20:59] |
| 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 |
| [2025-09-18 14:57:25] |
| John - SC Support - Posts: 42379 |
|
What study is ID6?
For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2025-09-18 19:09:02] |
| yitz - Posts: 5 |
|
Horizontal lines. I am using them to represent TPO value area high's and low's. Trying to get an alert triggered, when a bar with a 10% bid/offer imbalance is within 10 ticks of a horizonal line. Thank you |
| [2025-09-18 20:31:55] |
| John - SC Support - Posts: 42379 |
|
Everything looks OK with the formula. Do you have a situation that meets this criteria and for which you are not getting a signal? If you are having a problem verifying if it is working, then use the "Spreadsheet Formula" study, which uses the Alert syntax. You will have to put your lines together into a single line, but otherwise it will give you a 1 when the condition is true and zero otherwise, making it fairly easy to spot where it is true. We can't speak to your condition of "ABS(ID1.SG11) >= 0.10", as we do not know what study is ID1. But as long as that is valid, then the rest should work as well. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2025-09-18 21:58:18] |
| yitz - Posts: 5 |
|
ID1 is 'Number bars calculated values' and SG11 is the askV-bidV %. I don't know what you have done but it is now working. Thank you very much. |
| [2025-09-19 14:33:12] |
| John - SC Support - Posts: 42379 |
|
It may be what is referenced in the following section, but then it should not be working. But be aware of this nonetheless: Numbers Bars: Referencing Numbers Bars Calculated Values Subgraphs in Alert Formulas 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: