Support Board
Date/Time: Mon, 23 Dec 2024 15:44:02 +0000
Post From: Time based order SS
[2015-09-30 14:08:20] |
Sawtooth - Posts: 4141 |
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
|