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
|