Login Page - Create Account

Support Board


Date/Time: Sat, 15 Mar 2025 02:24:35 +0000



Post From: Spreadsheet System for Trading: Flatten Positions and Cancel not working.

[2022-07-07 00:57:25]
Sawtooth - Posts: 4183
Positions are not being closed by the time specified in J89.
This is because autotrading is disabled at 12:49 in J87.

To get around this, use J28/J29 instead of J85-J89, like this:
J28:
=AND(J8=0,OR(FRACTIME(J41)<TIMEVALUE("06:30:00"),FRACTIME(J41)>TIMEVALUE("12:49:00")))
-With J8=0 in above formula, entries are only allowed between the times, but exits can occur between the times and after the latest time.

J29:
=FRACTIME(J41)>TIMEVALUE("12:58:00")
- The time in J29 needs to be later than the latest time in J28.

Spreadsheet Example Formulas and Usage: Disable Trading From Spreadsheet Study for Trading
Date Time Of Last Edit: 2022-07-07 02:19:43