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.
|
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
|
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:
|
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
|