Support Board
Date/Time: Sun, 19 May 2024 13:52:34 +0000
Two Alerts created work fine, want to set Order Entry from either one
View Count: 738
[2019-06-07 18:38:33] |
John M - Posts: 166 |
I have two alerts that work fine for order entry: =AND(CROSSFROMBELOW(ID2.SG1,ID3.SG1), ID8.SG1>ID9.SG1) and =CROSSFROMBELOW(ID8.SG1,ID9.SG1) I want to combine them into a single Alert for the Spreadsheet for Trading so Order Entry can enter from either one of them. What is the syntax for an "Either/or" Alert setup? I have searched in the documentation but it's escaping me. thank you. |
[2019-06-08 10:24:25] |
bradh - Posts: 859 |
If you want to combine two AND formulas so either one being true will be true, then put both of them in an OR function like this: =OR(AND(CROSSFROMBELOW(ID2.SG1,ID3.SG1), ID8.SG1>ID9.SG1), CROSSFROMBELOW(ID8.SG1,ID9.SG1))
|
[2019-06-08 16:15:15] |
John M - Posts: 166 |
Thank you, I always manage to mess up the syntax. I finally found the OR Boolean function and feasibly have a simpler method to enter the same thing in the Spreadsheet for Trading. It's appreciated, thanks again. |
[2019-06-09 13:03:39] |
Sierra Chart Engineering - Posts: 104368 |
You use OR in the same way as you use the AND function. Refer to the information here: https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#OR_Function Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to 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: