Login Page - Create Account

Support Board


Date/Time: Fri, 26 Apr 2024 08:31:25 +0000



Post From: Reset Condition on New Bar- J72

[2020-02-12 04:20:57]
Sawtooth - Posts: 3976
...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 [J78]

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.