Login Page - Create Account

Support Board


Date/Time: Tue, 16 Sep 2025 04:12:08 +0000



Post From: Reset Condition on New Bar- J72

[2020-02-12 04:20:57]
Sawtooth - Posts: 4263
...cancel all working order except the working attached orders.
Use cell J78 for this.
Spreadsheet Systems, Alerts and Automated Trading: Cancel All Orders except working Attached Orders (read/write) [v1:J78, v2:J91]

To reset at each new bar, try something like this:
=AND(FRACTIME(J41)>=FRACTIME(A3),FRACTIME(J41)<FRACTIME(A3)+5/86400)
This will go TRUE at the bar open, and go FALSE after 5 seconds. This assumes there is a chart update in the 1st 5 seconds of the bar.