| rjmoats1 8 posts
 msg #73764
 - Ignore rjmoats1
 | 4/22/2009 1:43:23 AM 
 hey thanks for your help, appeciate it .
 
 what do you mean by keep the orginal and add a new line?
 
 
 | 
| chetron 2,817 posts
 msg #73769
 - Ignore chetron
 modified
 | 4/22/2009 6:34:27 AM 
 ALF'S FILTER GOT YOU TO B2B, NO NEED TO REINVENT IT, NOW JUST ADD YOUR B2B2B TO THAT VARIABLE AND SO ON.
 
 
 HTH
 
 
 | 
| alf44 2,025 posts
 msg #73774
 - Ignore alf44
 modified
 | 4/22/2009 10:02:41 AM 
 rj...first of all, 3 consecutive NR7s...is pretty rare !
 
 You could build a filter that looks ONLY for "3 consecutive NR7s"...but you would prolly have very few hits.
 
 In fact, yesterday...in the previous "back2back filter" I posted...only JAVA popped up.
 
 That's only 1 stock out of the entire NASDAQ 100...and that screened for "2 consecutive NR7s" !
 
 So...with that in mind...why create a filter that is SO restrictive...you may go days without any hits.
 
 Instead create a filter that scans for NR7s AND consecutive NR7s...and tells you when one or ALL are present.
 
 
 That's what THIS filter does:
 
 -----------------------------------------------------------
 
 
 
 
 -----------------------------------------------------------
 
 This will alert you to ALL 3 possibilities.
 
 Obviously, a "1" in each of the 3 columns would indicate that "3 consecutive NR7s" have taken place over the last 3 days...each day narrower in range than the day before it.
 
 It's sorted descending by "nr7 now"...since that would need to occur in  order to have consecutives.
 
 
 Regards,
 
 alf44
 
 
 
 | 
| alf44 2,025 posts
 msg #73779
 - Ignore alf44
 | 4/22/2009 2:23:45 PM 
 One More Time !!!
 
 This filter makes "2 consecutive NR7s" (today & yesterday) OR "NR7 2 days ago" (day before yesterday)  the scan criteria.
 
 This eliminates the check for single NR7s (today)...and combines it into a check for "2 consecutives" (today & yesterday). By doing this you eliminate a column and greatly reduce the number of hits. It's sorted so that the stocks that had 2 consecutive NR7s (today & yesterday) come to the top.
 
 So...
 
 A "1" in the first column indicates back to back NR7s (today & yesterday) !
 A "1" in the second column indicates an NR7 (day before yesterday) !!
 A "1" in BOTH columns would indicate "3 consecutive NR7s !!!
 
 ----------
 
 
 
 
 -----
 
 Regards,
 
 alf44
 
 
 
 |