Home >> Support Board

Support Board

Date/Time: Fri, 09 May 2025 14:07:04 +0000

How to Post a Message for Support

Spreadsheet system for trading question

View Count: 698

[2016-08-29 20:22:15] #1 [Go To First Post]
User14682 - Posts: 83
I am trying to disable trading between 14:55 in the afternoon until 05:00 in the morning? Whats wrong with this code? =AND(J41-INT(J41)<TIMEVALUE("05:00:00"),J41-INT(J41)>TIMEVALUE("14:55:00"))

[2016-08-29 20:36:33] #2 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
Use this: =OR(J41-INT(J41)<TIMEVALUE("05:00:00"),J41-INT(J41)>TIMEVALUE("14:55:00")) Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, change to the Teton service: Sierra Chart Teton Futures Order Routing

[2016-08-29 20:38:50] #3 [Go To First Post]
Sawtooth - Posts: 4213
Use OR instead of AND when crossing midnight: =OR(J41-INT(J41)<TIMEVALUE("05:00:00"),J41-INT(J41)>TIMEVALUE("14:55:00"))

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