StockFetcher Forums · General Discussion · Exclude Industry<< >>Post Follow-up
louisleow
2 posts
msg #124687
Ignore louisleow
8/19/2015 11:51:00 AM

Hi,

Anyone know what to key in to exclude all stocks that are classified "BIOTECH" and "UTILITIES"?

Thank u !

four
4,001 posts
msg #124689
Ignore four
modified
8/19/2015 6:35:56 PM

SET{A, COUNT(INDUSTRY EQUAL 20,1)}
SET{B, COUNT(INDUSTRY EQUAL 36,1)}
SET{C, A + B}
ADD COLUMN INDUSTRY
C < 1

/*
I started the list to accomplish your request. If anyone wishes to 'manually' go past Industry equals 38...
Industry=N/A and others seem to cross into other industries.

You may run the above filter and then manually ignore any that "just show up"

Hope this helps. Interesting that Yepher's effort for this in his manual http://yepher.com/stockfetcher/command.html ... the numbers for the industries are different.
SET{A, COUNT(INDUSTRY EQUAL 38,1)}
SET{B, COUNT(INDUSTRY EQUAL 1,1)}
SET{C, A + 0}
c > 0

ADD COLUMN INDUSTRY
add column a > 0

1=Retail - Drug Stores
2=Computer - Software
3=Building And Construction - Misc
4=Transportation - Ship
5=Computer - Software
6=Leisure And Recreational Products
7=Aerospace - Defense Equipment
8=Furniture
9=Broadcast - Radio And Tv
10=Auto
11=Conglomerates
12=Internet - Software
13=Reit
14=Business Services
15=Consumer Products
16=Publishing , Radio And Tv
17=Transportation
18=Oil
19=Electronic Manufacturing
20=Utility -
21=Drilling, exploration
22=Banks
23=Retail, wholesale
24=Misc
25=Electronics
26=Conglomerate
27=Medical
28=Drugs, medical
29=iIsurance
30=Misc
31=Computer
32=Retail
33=Insurance
34=Protection - Safety
35=Systems
36=Medical - Biomedical
37=Insurance
38=Banks
*/


StockFetcher Forums · General Discussion · Exclude Industry<< >>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