Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Sun, 19 May 2024 01:39:14 +0000

How to Post a Message for Support

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

[2019-08-22 13:16:19]
[Go To First Post]
Sawtooth - Posts: 4000
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")