Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Tue, 07 May 2024 12:59:19 +0000
Two Alerts created work fine, want to set Order Entry from either one
View Count: 732
| [2019-06-07 18:38:33] |
| John M - Posts: 165 |
|
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: 854 |
|
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: 165 |
|
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] |
| |
|
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: