Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Sun, 24 Nov 2024 05:04:41 +0000

How to Post a Message for Support

Post From: Spreadsheet trading non trade time

[2013-09-08 13:49:39]
[Go To First Post]
Sawtooth - Posts: 4118
If you are using the Spreadsheet System for Trading study, use cell J28 and the TIMEVALUE function:

=OR(J41-INT(J41)<TIMEVALUE("09:30:00"),J41-INT(J41)>TIMEVALUE("16:00:00"))

To also avoid a lunchtime trade:

=OR(OR(J41-INT(J41)<TIMEVALUE("09:30:00"),J41-INT(J41)>TIMEVALUE("16:00:00")),AND(J41-INT(J41)>TIMEVALUE("11:30:00"),J41-INT(J41)<TIMEVALUE("13:30:00")))

Edit the times between the quotes as needed.