Login Page - Create Account

Support Board


Date/Time: Sat, 08 Nov 2025 16:36:46 +0000



Post From: Spreadsheet auto-cancel/flattens, J89 and J29

[2018-11-18 22:19:02]
User376341 - Posts: 37
Hi,
Showing a 1 in J29, on attached, using the formula suggested here:
Spreadsheet Systems, Alerts and Automated Trading: Flatten and Cancel Working Orders (read/write) [v1:J29, v2:J90]

=(J41-INT(J41)) > TIMEVALUE("15:55:00")

once the time is eclipsed, as expected.

Also have tried J89 to do similar (without formula, just the time)...

but not seeing flattening during replay, order just rolls into next hour.
What else could factor-in here?
imagej29.PNG / V - Attached On 2018-11-18 22:15:38 UTC - Size: 179.92 KB - 385 views