Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Mon, 06 May 2024 22:27:16 +0000
Spreadsheet system for trading question
View Count: 605
| [2016-08-29 20:22:15] |
| 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] |
| |
|
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] |
| Sawtooth - Posts: 3993 |
|
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: