Support Board

Date/Time: Thu, 03 Jul 2025 16:01:23 +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: 4231
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")