Support Board
Date/Time: Tue, 04 Nov 2025 12:53:23 +0000
Create a Trading System with Spreadsheet
View Count: 1132
| [2014-12-19 14:24:37] |
| User59228 - Posts: 47 |
|
Hello, in your documentation there is mentioned a possiblity for a buy Exit oder. This formula is: OR(AND($J$8>0,$E$3<=$J$9-1), AND($J$8>0, $E$3>=$J$9+2)) When I try to use this formula i get an error. Can you help ? Thank you Mario |
| [2014-12-19 15:14:21] |
| Sawtooth - Posts: 4285 |
|
The formula does not give an error when I try it. A buy exit formula would go in cell L3, and would most likely not use an absolute reference to E3 =OR(AND($J$8>0,E3<=$J$9-1),AND($J$8>0,E3>=$J$9+2)) You could also write the formula this way: =AND($J$8>0,OR(E3<=$J$9-1,E3>=$J$9+2)) |
| [2014-12-19 15:27:06] |
| User59228 - Posts: 47 |
|
Thank you for answer. hm, I get a invalid formula with your second formula too. Is it necessary to have a Long Position when put this formula in or I have to use maybe ; when i sit in Germany ?? |
| [2014-12-19 16:37:29] |
| Sawtooth - Posts: 4285 |
|
Maybe it is the Regional Settings. Try using a semicolon ; instead of a comma, =OR(AND($J$8>0;E3<=$J$9-1);AND($J$8>0;E3>=$J$9+2)) |
| [2014-12-19 17:27:45] |
| User59228 - Posts: 47 |
|
Now it works :-) thank you. It tried it with ; before, but probably i tiped in something wrong. Thank you very much again. Mario |
To post a message in this thread, you need to log in with your Sierra Chart account: