Login Page - Create Account

Support Board


Date/Time: Mon, 06 May 2024 23:24:55 +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 Position and Cancel Working Orders [J29]

=(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 - 331 views