Support Board

Date/Time: Sun, 19 May 2024 04:55:33 +0000

Post From: Time based order SS

[2015-09-30 14:08:20] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 4000
You'll need to compare the Bar End Time to the chart update time. Use cell J41, like this in cell K3: =AND($J$41-INT($J$41)>=AA3,$J$41-INT($J$41)<AA3+1/1440) This gives a 1 minute window for an entry because there might not be a chart update exactly at the top of the hour. You could also do it without the Bar End Time study: =AND($J$41-INT($J$41)>=TIMEVALUE("13:00:00"),$J$41-INT($J$41)<TIMEVALUE("13:01:00")) In a fast market like AAPL, you could alter the window to something less, like this 10 second window starting 1 second before 13:00 =AND($J$41-INT($J$41)>=TIMEVALUE("12:59:59"),$J$41-INT($J$41)<TIMEVALUE("13:00:09")) Date Time Of Last Edit: 2015-09-30 14:15:48