Support Board
Date/Time: Sun, 22 Mar 2026 06:33:45 +0000
Post From: Spreadsheet trading: inconsistent execution.
| [2020-10-19 18:48:42] |
| Sawtooth - Posts: 4321 |
|
Just like J8, you need to use absolute references to cells J41 and J42: Buy Stop =AND(AND(AND($J$8 > 0, A3 > $J$42), $J$41 > A3),(E3 < MIN(D4, D5))) Sell Stop =AND(AND(AND($J$8 < 0, A3 > $J$42), $J$41 > A3),(E3 > MAX(C4, C5))) |