Support Board

Date/Time: Wed, 05 Nov 2025 02:10:07 +0000

Post From: Spreadsheet System for Trading - Flatten Positions And Cancel Orders At Set Time

[2019-08-22 13:16:19] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 4285
You have more flexibility if you use J28 and J29 instead of J85-J89: J28: =AND(J8=0,OR(FRACTIME(J41)<TIMEVALUE("07:30:00"),FRACTIME(J41)>TIMEVALUE("13:00:00"))) This sets a time window for entries and exits, and allows exits after the time window. J29: =FRACTIME(J41)>=TIMEVALUE("13:05:00")