StockFetcher Forums · Filter Exchange · OR function - help with TheRumpledOne's code<< >>Post Follow-up
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

StockFetcher Forums · Filter Exchange · OR function - help with TheRumpledOne's code<< >>Post Follow-up

*** Disclaimer *** StockFetcher.com does not endorse or suggest any of the securities which are returned in any of the searches or filters. They are provided purely for informational and research purposes. StockFetcher.com does not recommend particular securities. StockFetcher.com, Vestyl Software, L.L.C. and involved content providers shall not be liable for any errors or delays in the content, or for any actions taken based on the content.


Copyright 2022 - Vestyl Software L.L.C.Terms of Service | License | Questions or comments? Contact Us
EOD Data sources: DDFPlus & CSI Data Quotes delayed during active market hours. Delay times are at least 15 mins for NASDAQ, 20 mins for NYSE and Amex. Delayed intraday data provided by DDFPlus


This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.