Support Board

Date/Time: Sun, 22 Dec 2024 05:03:33 +0000

Post From: Enable Spreadsheet Auto Trading Based on Condition or Time

[2015-07-14 13:56:19] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 4141
You can enable/disable autotrading with a y/n in cell H2, e.g.: =OR(J41-INT(J41)<TIMEVALUE(J1),J41-INT(J41)>TIMEVALUE(J2),H2<>"y") where: the above formula is in J28 the start time is in J1 the end time is in J2. If your enable window crosses midnight: use this instead: =OR(AND(J41-INT(J41)<TIMEVALUE(J1),J41-INT(J41)>TIMEVALUE(J2)),H2<>"y")