StockFetcher Forums · General Discussion · Filter out industry groups<< >>Post Follow-up
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,358 posts
msg #49808
Ignore TheRumpledOne
modified
2/4/2007 11:01:26 AM

I created a "tool" to display the Industry and Sector numbers.

Fetcher[
/* Industry and Sector Numbers Display Filter */
set{Indnum, industry }
set{Secnum, sector }

add column industry
add column Indnum
add column sector
add column Secnum

sort column 5 ascending

Indnum above -1
]



Once you know what the industry and/or sector number is that you want to omit you use the follow filter

Fetcher[
set{Leaveout, count( sector equal 3, 1 ) }

Leaveout equal 0

add column industry

sort column 5 ascending
]



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,358 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,358 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.







StockFetcher Forums · General Discussion · Filter out industry groups<< >>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 2016 - 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