Login Page - Create Account

Support Board


Date/Time: Mon, 03 Mar 2025 21:32:57 +0000



Post From: Closing All Open Positions/Order Outside of Allowed Iime Range of System for Trading

[2021-11-05 13:17:58]
Sawtooth - Posts: 4179
Instead of using J85,J86,J87, use a formula like this in J28...:
=AND(J8 = 0, OR(FRACTIME(J41) < TIMEVALUE("06:30:00"), FRACTIME(J41) > TIMEVALUE("09:00:00")))
...and a formula like this in J29:
=FRACTIME(J41) > TIMEVALUE("16:00:00")

J8=0 in this J28 formula allows exits outside of the entries window.
The J29 formula needs to be a later time than the entries window.

Spreadsheet Example Formulas and Usage: Disable Autotrading Outside of Regular Trading Hours