| SAFeTRADE 656 posts
 msg #114319
 - Ignore SAFeTRADE
 | 7/3/2013 12:30:02 PM 
 
 
 
 What am I not seeing as to why this is not working? Should return at least 4.
 
 Clarence
 
 
 | 
| four 5,087 posts
 msg #114322
 - Ignore four
 modified
 | 7/3/2013 1:09:19 PM 
 1. remove -- symlist(kbe)
 2. add column duo equals 1
 
 -- results = 491 market closed)
 
 
 
 
 
 
 | 
| SAFeTRADE 656 posts
 msg #114326
 - Ignore SAFeTRADE
 | 7/3/2013 7:15:17 PM 
 Thanks Four.   It is my understanding that the days since shows how many days since an event happened.
 If that is the case then kbe should show a 4 as duo triggered 4 days ago or maybe 5 now.  Am I incorrect in
 that assumption?
 
 Clarence
 
 
 | 
| four 5,087 posts
 msg #114327
 - Ignore four
 modified
 | 7/3/2013 9:29:18 PM 
 Try this...
 
 -  Looking at 10 days for both variables as individual results (not sure how you want to combine them as a final requirement)
 - The -1 forces the required event to have happened at least once in 10 day range
 - The column result of 0 is the required event happened today
 
 
 
 
 
 
 | 
| SAFeTRADE 656 posts
 msg #114328
 - Ignore SAFeTRADE
 | 7/3/2013 10:05:17 PM 
 Thanks Four you really jump right in there and I appreciate that.  I finally figured it out.
 here is the right code.
 
 
 
 
 Should not have been looking for 1 but zero instead in the "duo equal 0" instead of
 "duo equal 1"
 
 Thanks again!
 
 Clarence
 
 
 | 
| four 5,087 posts
 msg #114329
 - Ignore four
 modified
 | 7/3/2013 10:35:47 PM 
 Wondering about the correct phrase (in English) for your need...
 
 Is this correct?:
 
 ---> Only return stocks that :
 
 -1--- One of the 2 sets does not occur -or- both do not occur:  williams %r(90) > -.07 , cci(14) > 89
 -2--- Within one day of each other -or- the same day
 -3--- Item 2 occurs within the last 10 days
 
 PS Notice:  -07 -- needs a period = -.07
 
 
 | 
| SAFeTRADE 656 posts
 msg #114334
 - Ignore SAFeTRADE
 | 7/5/2013 3:45:08 AM 
 Four, not sure I understand your question completely.  I am looking for both Williams %r and CCI(14)
 to signal a 1.  The duo is a check for when both are 1's.  It keeps track of when they crossed over to 1.
 The Williams %r(90) is a -07 and not a -.07.  I hope this answers your question.  Just recently USO
 met these qualifications as well as KBE and KRE.
 
 Clarence
 
 
 | 
| SAFeTRADE 656 posts
 msg #114335
 - Ignore SAFeTRADE
 | 7/5/2013 5:50:53 AM 
 Four here is the rest of the filter.
 
 
 
 
 Clarence
 
 
 |