StockFetcher Forums · General Discussion · exclude certain sectors<< 1 2 >>Post Follow-up
mazskingdom
6 posts
msg #51162
Ignore mazskingdom
4/16/2007 6:09:21 PM

I would like to exclude certain sectors in my filter - how can i do that?

rharmelink
81 posts
msg #51171
Ignore rharmelink
4/17/2007 12:09:34 AM

A search would have found the information pretty quickly. I just did and found:

http://help.stockfetcher.com/sfhelp/?qrid=1176782795&p=feedback&topic=Screens_and_Examples&subtopic=Examples&question=Industries

http://forums.stockfetcher.com/sfforums/?q=view&fid=1002&tid=50867&qrid=

mazskingdom
6 posts
msg #51174
Ignore mazskingdom
4/17/2007 11:57:56 AM

Thanx for the help - actually i did a search but couldnt find the proper way to do it. How do you exclude a sector?

nikoschopen
2,824 posts
msg #51176
Ignore nikoschopen
4/17/2007 12:23:42 PM

Use the below filter to omit the undesired sectors or industries. Change "SERVICES" for any other sector you wish to omit from your search. For industries, just change the wording from "sector" to "industries" accordingly.

Fetcher[
set{Nonsector, count(SECTOR is SERVICES,1)}
set{Anything_But, 1 - Nonsector}
Anything_But is above 0
add column sector
]



mazskingdom
6 posts
msg #51177
Ignore mazskingdom
4/17/2007 1:04:23 PM

thanx so much, thats what i needed
how do you put 2 sectors to the exclude list?

nikoschopen
2,824 posts
msg #51180
Ignore nikoschopen
4/17/2007 3:03:45 PM

Fetcher[
set{Nonsector, count(SECTOR is SERVICES,1) + count(SECTOR is FINANCIAL,1)}
set{Anything_But, 1 - Nonsector}
Anything_But is above 0
add column Anything_But
add column sector
]



jbesr1230
28 posts
msg #51184
Ignore jbesr1230
4/18/2007 11:20:06 AM

Hello,

When I use the following setup I get Energy stocks as well as Service and Technology. Why?
Do I have a misunderstanding in the "or" Boolean Logic theory? (as posted by TheRumpledOne--Thanks for posting this TRO)

Thanks


set{A, count(SECTOR is SERVICES,1)}
set{b, count(SECTOR is Technology,1)}
set{OR1, A + B}
show stocks where OR1 is above 0
add column sector


nikoschopen
2,824 posts
msg #51186
Ignore nikoschopen
4/18/2007 11:56:44 AM

The Rumpie filter is meant to INCLUDE the "services" and "technology" sectors. Mine was written to exclude them (eg. set{Anything_But, 1 - Nonsector}). If you add "set{Anything_But, 1 - OR1}" to Rumpie's filter, you'll get the same result:

Fetcher[
set{A, count(SECTOR is SERVICES,1)}
set{b, count(SECTOR is Technology,1)}
set{OR1, A + B}
set{Anything_But, 1 - OR1} /* <-- HERE*/
show stocks where Anything_But is above 0
add column sector
]



nikoschopen
2,824 posts
msg #51187
Ignore nikoschopen
4/18/2007 12:00:49 PM

Just in case you're not aware of the specifics, what I've done was to initially find services and technology stocks that met the search criteria. Then I subtracted those number of stocks from the rest of the stock universe. Hence, what you're left is "anything but" those two sectors.

jbesr1230
28 posts
msg #51190
Ignore jbesr1230
4/18/2007 12:42:46 PM

Thanks nikoschopen. I understood (I think) the logic of your filter. What I was trying to do was just get the stocks in the "services" and "technology" sectors only. My filter also returns "energy" sector stocks. Why?

nikoschopen,
How would you write your filter to get only "services" and "technology" sectors only?

Thanks. Following you filter has been a good learning experience. Thanks for posting

JB


StockFetcher Forums · General Discussion · exclude certain sectors<< 1 2 >>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.