Login Page - Create Account

Support Board


Date/Time: Sat, 21 Dec 2024 17:46:46 +0000



[User Discussion] - Enable Spreadsheet Auto Trading Based on Condition or Time

View Count: 766

[2015-07-14 05:37:13]
djcurcio - Posts: 236
I would like to turn on and off Auto trading at a specific time. For example: =TurnOnAutoTrading = (j41-int(j41))>timevalue("23:28:00")
[2015-07-14 13:56:19]
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")

To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account