cire0015 6 posts msg #138181 - Ignore cire0015 | 
9/15/2017 8:58:26 AM
  I am trying to pull together a filter that uses a combination of various momentum based criteria then filtered by relative strength against major indices.
 
 I am trying to use the following:
 
 /* OR Implementation */ 
 /* by definition OR is TRUE IF A is TRUE, B is TRUE, or A AND B is TRUE*/
 /* THEREFORE by counting and adding, if the sum is greater than 0 the OR condition is TRUE. */
 /* Copyright 2003 by Avery T. Horton, Jr. */ 
 /* Permission to use OR Implementation withing StockFetcher Granted */ 
 /* Permission to publish or post on any other forum DENIED */ 
 /* ----------------------------------------------------------------*/ 
 set{A, count(close above 100, 1)} 
 set{B, count(volume above 50,000,000, 1)} 
 set{OR1, A + B} show stocks where OR1 above 0
 
 I have substituted as follows (filter already has sets B and C, and this is trying to pull stocks that are outperforming the following three indices):
 
 set{D, count(Relative Strength(^DJI,45) is more than 1.25} 
 set{E, count(Relative Strength(^NDX,45) is more than 1.25} 
 set{F, count(Relative Strength(^SPX,45) is more than 1.25} 
 set{OR1, D + E + F} show stocks where OR1 above 0
 
 However this seems to throw off my whole filter such that de-beugging shows nothing working.
 
 Thoughts welcome.
 
 Many thanks
 Eric 
 
  | 
Kevin_in_GA 4,599 posts msg #138183 - Ignore Kevin_in_GA | 
9/15/2017 11:36:16 AM
  You can only do one mathematical operation in set{} statement - you cannot add A +B + C in one set{} statement, please use two.
 
  | 
cire0015 6 posts msg #138184 - Ignore cire0015 | 
9/15/2017 11:43:51 AM
  Thanks very much Kevin.
 
 So would that mean return a share if it outperformed Index A or B; or Index A or C?
 
 I was actually hoping to run this against 10+ indices, i.e. show the stock if it outperforms any one index in a list.
 
 Would that be possible?
 
 Thanks
 Eric
 
  | 
Kevin_in_GA 4,599 posts msg #138186 - Ignore Kevin_in_GA | 
9/15/2017 12:46:00 PM
  yes, but you will need 10 separate set{} statements to do this.  That may be more than the current regular SF subscription will allow (since they are "nested" one within another).
 
  | 
mahkoh 1,065 posts msg #138190 - Ignore mahkoh | 
9/15/2017 3:09:01 PM
  set{D, count(Relative Strength(^DJI,45) is more than 1.25} 
 set{E, count(Relative Strength(^NDX,45) is more than 1.25} 
 set{F, count(Relative Strength(^SPX,45) is more than 1.25} 
 set{OR1, D + E}
 set{OR2,OR1 + F}
 OR2 above 0
 
  |