Support Board
Date/Time: Fri, 04 Jul 2025 15:22:47 +0000
[User Discussion] - CROSSFROMBELOW Formula Errors
View Count: 1198
| [2019-01-27 03:14:29] |
| User348651 - Posts: 3 |
|
Hi guys, I am trying to follow a tutorial on setting up basic MA crossover buy/sell alerts, however I get the following error: Error: SYNTAX! | Formula: = *CROSSFROMBELOW(ID5.SG1,1D6.SG1) ID5 = MA1 ID6 = MA2 It seems simple enough, but I can not see where the syntax error is, and I have entered it verbatim to the tutorial... Any ideas would be great. Screenshot attached. https://www.sierrachart.com/Download.php?Folder=SupportBoard&download=25497 |
 formula error.JPG / V - Attached On 2019-01-27 03:12:42 UTC - Size: 64.69 KB - 504 views |
| [2019-01-27 04:16:17] |
| Sawtooth - Posts: 4231 |
|
The syntax you are using is only for Simple Alerts. And it contains an error. It should be: =CROSSFROMBELOW(ID5.SG1,ID6.SG1) The syntax for spreadsheets requires a range comparison and row references: =CROSSFROMBELOW(ID5.SG1@3:ID5.SG1@4,ID6.SG1@3:ID6.SG1@4) |
| [2019-01-27 05:31:36] |
| User348651 - Posts: 3 |
|
thank you, the first one seems to have fixed it
|
| [2019-01-27 15:40:36] |
| User875891 - Posts: 63 |
|
Ive done the same thing 100 times substituting an (1) for a (I) in the ID |
To post a message in this thread, you need to log in with your Sierra Chart account: