Support Board
Date/Time: Fri, 22 Nov 2024 23:14:49 +0000
[User Discussion] - Trading Hours Question
View Count: 1673
| [2013-06-09 13:36:47] |
| Richard Reyes - Posts: 98 |
|
I want to start trading Sunday (1) evening at 19:00:00 hours and stop trading on Fridat (6) at 15:00:00 hours. Would the following work? =OR(AND(WEEKDAY(J41)=1,J41-INT(J41)<TIMEVALUE("19:00:00")),AND(WEEKDAY(J41)=6,J41-INT(J41)>TIMEVALUE("15:00:00"))) If the above would work, how would I integrate it into my spreadsheet - cells H3 to H9 and J28? Many Thanks |
| [2013-06-09 20:29:42] |
| Sawtooth - Posts: 4118 |
|
Go to the Old Support Board and do an advanced search for reyes, and user tomgilb. This will bring up posts with formulas I gave you before.
|
To post a message in this thread, you need to log in with your Sierra Chart account: