Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Thu, 25 Apr 2024 02:12:55 +0000

How to Post a Message for Support

Post From: Set timing for spreadsheet automated trading system

[2013-12-06 13:34:50]
[Go To First Post]
Sawtooth - Posts: 3976
You can do this using cell J28:

=AND(J8=0,OR(J41-INT(J41)<TIMEVALUE("08:30:00"),J41-INT(J41)>TIMEVALUE("16:00:00")))

J41 is the chart time, which matches the timezone set in Global Settings >> Data/Trade Service Settings, so it will work both live and in replay.