Login Page - Create Account

Support Board


Date/Time: Tue, 01 Jul 2025 14:39:03 +0000



Post From: Spreadsheet trading: inconsistent execution.

[2020-10-19 18:48:42]
Sawtooth - Posts: 4231
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)))