four
5,087 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
*/
|