Support Board
Date/Time: Tue, 18 Mar 2025 07:24:55 +0000
Post From: How to Specify an Intraday Time Period
[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! |