Login Page - Create Account

Support Board


Date/Time: Tue, 18 Mar 2025 16:37:36 +0000



[User Discussion] - How to Specify an Intraday Time Period

View Count: 391

[2022-09-14 00:26:02]
bradyfans - Posts: 16
I'm trying to only have a trade trigger if the time period is between 830 am and 12 pm and the other chart conditions are met.

I used the following formula for a trade triggering at 830, which seems to work:

=AND((FRACTIME(MROUND(A3,1/86400))=TIMEVALUE("08:30:00")),B3>AA3,AE3=65)

I can't quite figure out how to have the time be between 830 and 12, however. I thought something like =AND((FRACTIME(MROUND(A3,1/86400))>TIMEVALUE("08:30:00")),(FRACTIME(MROUND(A3,1/86400))<TIMEVALUE("12:00:00"))B3>AA3,AE3=65)
might work, but it doesn't seem to. I may just not understand the coding very well.

Can anyone help? Thanks!
[2022-09-14 02:54:34]
Sawtooth - Posts: 4186
Try this edited version:
=AND(FRACTIME(MROUND(A3,1/86400))>TIMEVALUE("08:30:00"),FRACTIME(MROUND(A3,1/86400))<TIMEVALUE("12:00:00"),B3>AA3,AE3=65)

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

Login

Login Page - Create Account