curmudgeon
103 posts
msg #49768
- Ignore curmudgeon |
2/2/2007 9:25:49 AM
I've tried a few different phrases but cant seem to get it to work. "and industry is not basic materials" doesn't do the trick.
|
TheRumpledOne
6,411 posts
msg #49808
- Ignore TheRumpledOne
modified |
2/4/2007 11:01:26 AM
I created a "tool" to display the Industry and Sector numbers.
Once you know what the industry and/or sector number is that you want to omit you use the follow filter
If you omit more than one than you will have to add up the LeaveOuts:
set{Leaveout2, count( sector equal 3, 1 ) }
set{Leaveout1, count( Industry equal 4, 1 ) + Leavout2 }
set{Leaveout, count( sector equal 11, 1 ) + Leaveout1}
For the record Basic Materials is a SECTOR NOT an Industry.
HTH.
|
curmudgeon
103 posts
msg #49814
- Ignore curmudgeon |
2/4/2007 3:26:18 PM
Thanks TRO. Very smart workaround. Seems for every include there should be an exclude as well.
>>>5502 matches
So all those "-1's" are funds? Is almost 1/2 the market not actually companies?
|
TheRumpledOne
6,411 posts
msg #49821
- Ignore TheRumpledOne
modified |
2/4/2007 7:16:31 PM
Those -1s are N/A.
Not sure if that means NOT APPLICABLE, NOT AVAILABLE, or something else... TomB a little help here!!
|
TheRumpledOne
6,411 posts
msg #49822
- Ignore TheRumpledOne
modified |
2/4/2007 7:19:17 PM
One other thing...
Download the entire file to EXCEL, then you don't have to bother running it again.. you can use <F3> to find the stock symbol, industry or sector you are looking for.
Not to mention you can sort on industry / sector and extract groups of stocks.
Or you can have SF watchlists for each industry / sector.
|