i am trying to check if the daily range was Highest High in 7 days from 15 minute timeframe. the prob that i see is that it shows true in the last 15 minute bar and all the rest of the bars next day. i have set my intraday settings from 9.30 to 15.59
here is the code. TimeFrameSet( inDaily ); // switch to DAILY rang = H - L; CheckPrice = ( C<20 AND C>O ) OR C > 20; HHVtoday=IIf( rang == HHV( rang, 7 ),True,False); HH7Date = ValueWhen( HHVtoday==True,DateNum() ) ; Buy_COMPRESSED = Filter = HHVtoday ; TimeFrameRestore(); // restore time frame to original BUYEXPANDED=Filter=TimeFrameExpand( Buy_COMPRESSED, inDaily,expandLast); AddColumn(BUYEXPANDED,"BUYEXPANDED"); when i explore aapl, i get Ticker Date/Time BUYEXPANDED AAPL 06/03/2009 3:45:00 PM 1.00 AAPL 09/03/2009 9:30:00 AM 1.00 AAPL 09/03/2009 9:45:00 AM 1.00 AAPL 09/03/2009 10:00:00 AM 1.00 AAPL 09/03/2009 10:15:00 AM 1.00 AAPL 09/03/2009 10:30:00 AM 1.00 AAPL 09/03/2009 10:45:00 AM 1.00 AAPL 09/03/2009 11:00:00 AM 1.00 AAPL 09/03/2009 11:15:00 AM 1.00 AAPL 09/03/2009 11:30:00 AM 1.00 AAPL 09/03/2009 11:45:00 AM 1.00 AAPL 09/03/2009 12:00:00 PM 1.00 AAPL 09/03/2009 12:15:00 PM 1.00 AAPL 09/03/2009 12:30:00 PM 1.00 AAPL 09/03/2009 12:45:00 PM 1.00 AAPL 09/03/2009 1:00:00 PM 1.00 AAPL 09/03/2009 1:15:00 PM 1.00 AAPL 09/03/2009 1:30:00 PM 1.00 AAPL 09/03/2009 1:45:00 PM 1.00 AAPL 09/03/2009 2:00:00 PM 1.00 AAPL 09/03/2009 2:15:00 PM 1.00 AAPL 09/03/2009 2:30:00 PM 1.00 AAPL 09/03/2009 2:45:00 PM 1.00 AAPL 09/03/2009 3:00:00 PM 1.00 AAPL 09/03/2009 3:15:00 PM 1.00 AAPL 09/03/2009 3:30:00 PM 1.00 AAPL 23/03/2009 3:45:00 PM 1.00 AAPL 24/03/2009 9:30:00 AM 1.00 AAPL 24/03/2009 9:45:00 AM 1.00 AAPL 24/03/2009 10:00:00 AM 1.00 AAPL 24/03/2009 10:15:00 AM 1.00 AAPL 24/03/2009 10:30:00 AM 1.00 AAPL 24/03/2009 10:45:00 AM 1.00 AAPL 24/03/2009 11:00:00 AM 1.00 AAPL 24/03/2009 11:15:00 AM 1.00 AAPL 24/03/2009 11:30:00 AM 1.00 AAPL 24/03/2009 11:45:00 AM 1.00 AAPL 24/03/2009 12:00:00 PM 1.00 AAPL 24/03/2009 12:15:00 PM 1.00 AAPL 24/03/2009 12:30:00 PM 1.00 AAPL 24/03/2009 12:45:00 PM 1.00 AAPL 24/03/2009 1:00:00 PM 1.00 AAPL 24/03/2009 1:15:00 PM 1.00 AAPL 24/03/2009 1:30:00 PM 1.00 AAPL 24/03/2009 1:45:00 PM 1.00 AAPL 24/03/2009 2:00:00 PM 1.00 AAPL 24/03/2009 2:15:00 PM 1.00 AAPL 24/03/2009 2:30:00 PM 1.00 AAPL 24/03/2009 2:45:00 PM 1.00 AAPL 24/03/2009 3:00:00 PM 1.00 AAPL 24/03/2009 3:15:00 PM 1.00 AAPL 24/03/2009 3:30:00 PM 1.00 AAPL 01/04/2009 3:45:00 PM 1.00 AAPL 02/04/2009 9:30:00 AM 1.00 AAPL 02/04/2009 9:45:00 AM 1.00 AAPL 02/04/2009 10:00:00 AM 1.00 AAPL 02/04/2009 10:15:00 AM 1.00 AAPL 02/04/2009 10:30:00 AM 1.00 AAPL 02/04/2009 10:45:00 AM 1.00 AAPL 02/04/2009 11:00:00 AM 1.00 AAPL 02/04/2009 11:15:00 AM 1.00 AAPL 02/04/2009 11:30:00 AM 1.00 AAPL 02/04/2009 11:45:00 AM 1.00 AAPL 02/04/2009 12:00:00 PM 1.00 AAPL 02/04/2009 12:15:00 PM 1.00 AAPL 02/04/2009 12:30:00 PM 1.00 AAPL 02/04/2009 12:45:00 PM 1.00 AAPL 02/04/2009 1:00:00 PM 1.00 AAPL 02/04/2009 1:15:00 PM 1.00 AAPL 02/04/2009 1:30:00 PM 1.00 AAPL 02/04/2009 1:45:00 PM 1.00 AAPL 02/04/2009 2:00:00 PM 1.00 AAPL 02/04/2009 2:15:00 PM 1.00 AAPL 02/04/2009 2:30:00 PM 1.00 AAPL 02/04/2009 2:45:00 PM 1.00 AAPL 02/04/2009 3:00:00 PM 1.00 AAPL 02/04/2009 3:15:00 PM 1.00 AAPL 02/04/2009 3:30:00 PM 1.00 AAPL 06/04/2009 3:45:00 PM 1.00 AAPL 07/04/2009 9:30:00 AM 1.00 AAPL 07/04/2009 9:45:00 AM 1.00 AAPL 07/04/2009 10:00:00 AM 1.00 AAPL 07/04/2009 10:15:00 AM 1.00 AAPL 07/04/2009 10:30:00 AM 1.00 AAPL 07/04/2009 10:45:00 AM 1.00 AAPL 07/04/2009 11:00:00 AM 1.00 AAPL 07/04/2009 11:15:00 AM 1.00 AAPL 07/04/2009 11:30:00 AM 1.00 AAPL 07/04/2009 11:45:00 AM 1.00 AAPL 07/04/2009 12:00:00 PM 1.00 AAPL 07/04/2009 12:15:00 PM 1.00 AAPL 07/04/2009 12:30:00 PM 1.00 AAPL 07/04/2009 12:45:00 PM 1.00 AAPL 07/04/2009 1:00:00 PM 1.00 AAPL 07/04/2009 1:15:00 PM 1.00 AAPL 07/04/2009 1:30:00 PM 1.00 AAPL 07/04/2009 1:45:00 PM 1.00 AAPL 07/04/2009 2:00:00 PM 1.00 AAPL 07/04/2009 2:15:00 PM 1.00 AAPL 07/04/2009 2:30:00 PM 1.00 AAPL 07/04/2009 2:45:00 PM 1.00 AAPL 07/04/2009 3:00:00 PM 1.00 AAPL 07/04/2009 3:15:00 PM 1.00 AAPL 07/04/2009 3:30:00 PM 1.00 AAPL 16/04/2009 3:45:00 PM 1.00 AAPL 17/04/2009 9:30:00 AM 1.00 AAPL 17/04/2009 9:45:00 AM 1.00 AAPL 17/04/2009 10:00:00 AM 1.00 AAPL 17/04/2009 10:15:00 AM 1.00 AAPL 17/04/2009 10:30:00 AM 1.00 AAPL 17/04/2009 10:45:00 AM 1.00 AAPL 17/04/2009 11:00:00 AM 1.00 AAPL 17/04/2009 11:15:00 AM 1.00 AAPL 17/04/2009 11:30:00 AM 1.00 AAPL 17/04/2009 11:45:00 AM 1.00 AAPL 17/04/2009 12:00:00 PM 1.00 AAPL 17/04/2009 12:15:00 PM 1.00 AAPL 17/04/2009 12:30:00 PM 1.00 AAPL 17/04/2009 12:45:00 PM 1.00 AAPL 17/04/2009 1:00:00 PM 1.00 AAPL 17/04/2009 1:15:00 PM 1.00 AAPL 17/04/2009 1:30:00 PM 1.00 AAPL 17/04/2009 1:45:00 PM 1.00 AAPL 17/04/2009 2:00:00 PM 1.00 AAPL 17/04/2009 2:15:00 PM 1.00 AAPL 17/04/2009 2:30:00 PM 1.00 AAPL 17/04/2009 2:45:00 PM 1.00 AAPL 17/04/2009 3:00:00 PM 1.00 AAPL 17/04/2009 3:15:00 PM 1.00 AAPL 17/04/2009 3:30:00 PM 1.00 AAPL 17/04/2009 3:45:00 PM 1.00