Support Board
Date/Time: Tue, 24 Jun 2025 00:35:01 +0000
Post From: Multiple of ATR as BuyExit & SellExit
| [2022-02-10 03:27:54] |
| Sawtooth - Posts: 4229 |
|
To resolve the SYNTAX errors: - The OR function should be closed at the end of this formula. - ID2.SG1 requires @3 to designate the row. This: =OR(ID0.SG4@$3 <= $J$9-(ID2.SG1*3)), CROSSFROMBELOW(ID0.SG4@3:ID0.SG4@4, ID5.SG1@3:ID5.SG1@4) should be this: =OR(ID0.SG4@$3 <= $J$9-ID2.SG1@3*3, CROSSFROMBELOW(ID0.SG4@3:ID0.SG4@4, ID5.SG1@3:ID5.SG1@4)) Notes: - Calculation precedence will do '*' before '-' so you don't need to enclose ID2.SG1@3*3 - You can simplify the formula by referencing E$3 instead of ID0.SG4@$3 : =OR(E$3 <= $J$9-ID2.SG1@3*3, CROSSFROMBELOW(E3:E4, ID5.SG1@3:ID5.SG1@4)) Date Time Of Last Edit: 2022-02-10 03:37:24
|