Login Page - Create Account

Support Board


Date/Time: Fri, 29 Mar 2024 12:41:00 +0000



[User Discussion] - Trading Hours Question

View Count: 1550

[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: 3952
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:

Login

Login Page - Create Account