Support Board
Date/Time: Tue, 16 Sep 2025 00:18:59 +0000
[User Discussion] - SYNTAX ERROR HELP
View Count: 786
| [2021-12-06 18:59:33] |
| Litz - Posts: 131 |
|
=AND(CROSSFROMBELOW(AA3:AA6,AB3,AB6),CROSSFROMBELOW(AA3:AA6,AF3:AF6) NOT WORKING JUST A MA CROSSOVER ALERT OF A 5 MA CROSSING 13 AND 21
|
| [2021-12-06 19:27:16] |
| John - SC Support - Posts: 41827 |
|
If you copied and pasted the formula, then the problem is that you have a comma where you should have a colon - in the second range of the first CROSSFROMBELOW (you have AB3,AB6, but it should be AB3:AB6).
For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2021-12-06 20:31:52] |
| Litz - Posts: 131 |
|
TNX STILL GET THE SYNTAX ERROR WITH =AND(CROSSFROMBELOW(AA3:AA6,AB3:AB6),CROSSFROMBELOW(AA3:AA6,AF3:AF6) |
| [2021-12-06 20:38:27] |
| Sawtooth - Posts: 4263 |
|
The AND needs a closing parenthesis: =AND(CROSSFROMBELOW(AA3:AA6,AB3:AB6),CROSSFROMBELOW(AA3:AA6,AF3:AF6)) |
| [2021-12-06 21:33:23] |
| Litz - Posts: 131 |
|
YUP that works tnx Tom
|
To post a message in this thread, you need to log in with your Sierra Chart account: