Support Board
Date/Time: Wed, 27 Nov 2024 20:27:11 +0000
Formula exit spreadsheet not work
View Count: 396
| [2023-06-27 14:52:29] |
| Hopeman - Posts: 166 |
|
Hi, I have this output formula, although the program doesn't read the second OR, it always outputs because of the first condition. I've tried different formulas and I can't find the solution. Do you know if there is a solution for this? =AND ( OR (ID0.SG4@3<ID3.SG5@3), OR ( R3, X3, AL3, AP3, AU3)) |
| [2023-06-27 19:58:52] |
| John - SC Support - Posts: 36344 |
|
Your syntax is incorrect, as you have an OR with only a single entry. Try the following: =AND(ID0.SG4@3<ID3.SG5@3, OR(R3, X3, AL3, AP3, AU3)) For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2023-06-30 17:22:02] |
| Hopeman - Posts: 166 |
|
Hi @John, The formula still doesn't work, it doesn't recognize the second line |
| [2023-06-30 18:39:25] |
| John - SC Support - Posts: 36344 |
|
When you say the "Second Line" we assume you are referring to the "OR" section. If that is the case, then keep in mind that the way this reads. It states the following: - The result will be True if ID0.SG4@3<ID3.SG5@3 and if any one of the following is also true (non-zero): R3, X3, AL3, AP3, AU3 Are any of R3, X3, AL3, AP3, and AU3 non-zero? If so, then it is working properly. If they are all zeros then that would indicate a problem. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2023-06-30 18:57:45] |
| Hopeman - Posts: 166 |
|
I am looking for the second line in this case to be R3, X3, AL3, AP3, and AU3, When they are all 1 it should give the signal, do you think it is better to make a reference cell to all this group of cells? |
| [2023-06-30 19:22:22] |
| John - SC Support - Posts: 36344 |
|
In that case they just need to be part of the AND. So it would be the following: =AND(ID0.SG4@3<ID3.SG5@3, R3, X3, AL3, AP3, AU3) This states that the result will be true only if ALL the items in the list are non-zero. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2023-07-01 05:44:31] |
| Hopeman - Posts: 166 |
|
Even so, I need the first line to be an independent condition from the other,
|
| [2023-07-03 12:51:09] |
| John - SC Support - Posts: 36344 |
|
Tell us in words exactly what you want to occur.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2023-07-03 13:18:45] |
| Hopeman - Posts: 166 |
|
Have two closing variables independent of each other, one is (ID0.SG4@3<ID3.SG5@3) and the other is if all together are 1 in their corresponding box, (R3, X3, AL3, AP3, AU3) )
|
| [2023-07-03 13:34:58] |
| John - SC Support - Posts: 36344 |
|
Then you would have the following condition: =OR(ID0.SG4@3<ID3.SG5@3, AND(R3, X3, AL3, AP3, AU3)) 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: