StockFetcher Forums · General Discussion · OR clause<< >>Post Follow-up
johnng74
9 posts
msg #66310
Ignore johnng74
8/17/2008 10:07:53 AM

Is there a way to specify "or" clause in the filter? for example, I want to find a list of stocks which price is over 100 or price is below 10 ...

Thanks
John


alf44
2,025 posts
msg #66311
Ignore alf44
modified
8/17/2008 10:33:00 AM

johnng74...there is no "OR" statement here at SF...BUT....

...THIS will do what you want to do...

----------------------------------------------------------


Fetcher[set{above100, count(Close above 100, 1)}
set{below10, count(Close below 10, 1)}

set{above100ORbelow10, above100 + below10}

Show stocks where above100ORbelow10 equals 1
]



-------------------------------------------------------------

You can add other parameters to narrow down the list of stocks this produces as it is quite lengthy !


Regards,

alf44

alf44
2,025 posts
msg #66312
Ignore alf44
8/17/2008 10:42:05 AM

Here's the same scan with share price sorted in descending order...

-----------------------------------------------

Fetcher[set{above100, count(Close above 100, 1)}
set{below10, count(Close below 10, 1)}

set{above100ORbelow10, above100 + below10}

Show stocks where above100ORbelow10 equals 1

sort column 2 descending
]



StockFetcher Forums · General Discussion · OR clause<< >>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.