Login Page - Create Account

Support Board


Date/Time: Wed, 12 Mar 2025 16:29:27 +0000



Post From: SPREADSHEET TRADING

[2022-05-04 22:35:38]
Sawtooth - Posts: 4182
I personally don't use J85-J89.
I think if J89 is >= J87, J89 doesn't happen, and there is no way to override J87 for exits.

To avoid this I use formulas like these:
J28:
=AND(J8=0,OR(FRACTIME(J41)<TIMEVALUE("09:00:00"),FRACTIME(J41)>TIMEVALUE("15:00:00")))
J29:
=FRACTIME(J41)>TIMEVALUE("15:15:00")

J8=0 disallows entries after the end time but allows J28 to remain FALSE (autotrading enabled) after 15:00 so that J29 can execute.
J29 needs to be later than the end time.