StockFetcher Forums · Filter Exchange · How to filter out Industry - Mining<< >>Post Follow-up
selfhigh05
23 posts
msg #139087
Ignore selfhigh05
11/5/2017 12:35:37 PM

I want to filter out and have Mining stocks not appear in my filter how do I do that. I have tried

And no apply Industry(mining-gold), I've tried no Industry-mining as well. Any help would be greatly appreciated. thanks

johnpaulca
12,034 posts
msg #139088
Ignore johnpaulca
modified
11/5/2017 1:43:38 PM

you tried this?

Fetcher[
industry is not (Mining - Gold)
and add column separator
and add column exchange
and add column sector
and add column industry
and add column separator
]



johnpaulca
12,034 posts
msg #139089
Ignore johnpaulca
modified
11/5/2017 1:49:25 PM

***

selfhigh05
23 posts
msg #139104
Ignore selfhigh05
11/6/2017 7:15:03 AM

so how would I filter the miner out, I dont want them to show up? I guess I could add each industry and then comment miners out. I was just hoping for a No statement of some sorts. Thanks

selfhigh05
23 posts
msg #139106
Ignore selfhigh05
11/6/2017 8:23:39 AM

I just commented out mining after putting this together:

apply to industry (Advertising Marketing Services)
apply to industry (Aerospace - Defense)
apply to industry (Aerospace - Defense Equipment)
apply to industry (Agriculture Operations)
apply to industry (Agriculture Products)
apply to industry (Appliances - Household)
apply to industry (Auction Valuation Services)
apply to industry (Audio And Video Products)
apply to industry (Auto - Domestic)
apply to industry (Auto - Foreign)
apply to industry (Auto - Truck Original Parts)
apply to industry (Auto - Truck Replacement Parts)
apply to industry (Banks - Foreign)
apply to industry (Banks - Major Regional)
apply to industry (Banks - Midwest)
apply to industry (Banks - Northeast)
apply to industry (Banks - Southeast)
apply to industry (Banks - Southwest)
apply to industry (Banks - West)
apply to industry (Beverages - Alcohol)
apply to industry (Beverages - Soft)
apply to industry (Biofuels)
apply to industry (Broadcast - Radio And Tv)
apply to industry (Building - Cmt And Cnt And Ag)
apply to industry (Building - Heavy Construction)
apply to industry (Building - Maint And Service)
apply to industry (Building - Mobile Homes And Rv)
apply to industry (Building - Residential And Comm)
apply to industry (Building And Construction - Misc)
apply to industry (Building Products - Air Heating)
apply to industry (Building Products - Ltg Fx)
apply to industry (Building Products - Wood)
apply to industry (Building Products Retail - Wholesale)
apply to industry (Business Information)
apply to industry (Business Office Products)
apply to industry (Business Services)
apply to industry (Business Software Services)
apply to industry (Cable Tv)
apply to industry (Chemical - Diversified)
apply to industry (Chemical - Plastics)
apply to industry (Chemical - Specialty)
apply to industry (Coal)
apply to industry (Communication Network Software)
apply to industry (Communications Components)
apply to industry (Communications Infrastructure)
apply to industry (Computer - Integrated Systems)
apply to industry (Computer - Mainframe)
apply to industry (Computer - Mini)
apply to industry (Computer - Networks)
apply to industry (Computer - Optical)
apply to industry (Computer - Services)
apply to industry (Computer - Software)
apply to industry (Computer - Storage Devices)
apply to industry (Computers - Peripheral Equipment)
apply to industry (Conglomerates - Div Operations)
apply to industry (Consulting)
apply to industry (Consumer Products - Misc Discretionary)
apply to industry (Consumer Products - Misc Staple)
apply to industry (Consumer Services - Misc)
apply to industry (Containers - Metal And Glass)
apply to industry (Containers - Paper Products)
apply to industry (Cosmetics And Toiletries)
apply to industry (Diversified Comm Services)
apply to industry (E&p Mlp)
apply to industry (Electrical - Manufacturing)
apply to industry (Electrical Construction)
apply to industry (Electrical Power)
apply to industry (Electronic Manufacturing)
apply to industry (Electronic Misc Services)
apply to industry (Electronic Test Equipment)
apply to industry (Electronics - Connectors)
apply to industry (Electronics - Measuring Inst)
apply to industry (Electronics - Military)
apply to industry (Electronics - Misc Components)
apply to industry (Electronics - Parts Distrib)
apply to industry (Electronics - Semiconductors)
apply to industry (Electronics Products - Misc)
apply to industry (Emerging Markets Integrated)
apply to industry (Engineering And R&d Services)
apply to industry (Engines - Internal Combustion)
apply to industry (Fertilizers)
apply to industry (Fiber Optics)
apply to industry (Finance - Consumer Loans)
apply to industry (Finance - Investment Brokers)
apply to industry (Finance - Investment Funds)
apply to industry (Finance - Investment Mgmt)
apply to industry (Finance - Leasing Companies)
apply to industry (Finance - Misc Services)
apply to industry (Finance - Mortgage And Rel Svs)
apply to industry (Finance - Savings And Loan)
apply to industry (Finance - Sbic And Commercial)
apply to industry (Financial Transaction Services)
apply to industry (Food - Confectionery)
apply to industry (Food - Dairy Products)
apply to industry (Food - Meat Products)
apply to industry (Food - Misc And Diversified)
apply to industry (Food Items - Wholesale)
apply to industry (Funeral Services And Related)
apply to industry (Furniture)
apply to industry (Gaming)
apply to industry (Glass Products)
apply to industry (Government Services)
apply to industry (Hotels And Motels)
apply to industry (Indices)
apply to industry (Industrial Controls)
apply to industry (Industrial Robotics)
apply to industry (Industrial Scientific)
apply to industry (Industrial Services)
apply to industry (Insurance - Accident And Health)
apply to industry (Insurance - Brokers)
apply to industry (Insurance - Life)
apply to industry (Insurance - Multi Line)
apply to industry (Insurance - Property And Casualty)
apply to industry (International E&p)
apply to industry (Internet - Content)
apply to industry (Internet - Services)
apply to industry (Internet - Software)
apply to industry (Internet Commerce)
apply to industry (Internet Services - Delivery)
apply to industry (Internet Software Services)
apply to industry (It Services)
apply to industry (Large Cap Pharma)
apply to industry (Lasers - Systems And Components)
apply to industry (Leisure And Recreation Services)
apply to industry (Leisure And Recreational Products)
apply to industry (Machinery - Construct And Mining)
apply to industry (Machinery - Elect Utilities)
apply to industry (Machinery - Electrical)
apply to industry (Machinery - Farm)
apply to industry (Machinery - General Industrial)
apply to industry (Machinery - Material Handling)
apply to industry (Machinery - Printing)
apply to industry (Machinery - Thermal Processing)
apply to industry (Machinery - Tools And Related)
apply to industry (Media Conglomerates)
apply to industry (Medical - Biomedical)
apply to industry (Medical - Dental Suppliers)
apply to industry (Medical - Drugs)
apply to industry (Medical - Generic Drugs)
apply to industry (Medical - Hmo)
apply to industry (Medical - Hospitals)
apply to industry (Medical - Nursing Homes)
apply to industry (Medical - Outpatient And Hm Care)
apply to industry (Medical Information Systems)
apply to industry (Medical Instruments)
apply to industry (Medical Products)
apply to industry (Medical Services)
apply to industry (Metal Production And Fabrication)
apply to industry (Metal Products - Distribution)
apply to industry (Metal Products - Fasteners)
apply to industry (Mining - Gold)
apply to industry (Mining - Iron)
apply to industry (Mining - Misc)
apply to industry (Mining - Non Ferrous)
apply to industry (Mining - Silver)
apply to industry (Movie And Tv Production And Dist)
apply to industry (Nanotechnology)
apply to industry (Office Automation And Equipment)
apply to industry (Office Supply And Forms)
apply to industry (Oil - Exploration And Product)
apply to industry (Oil - Integrated)
apply to industry (Oil - Field Services)
apply to industry (Oil - International Integrated)
apply to industry (Oil - International Specialty)
apply to industry (Oil - Production And Pipeline)
apply to industry (Oil - Refining And Marketing)
apply to industry (Oil - Us Exploration And Product)
apply to industry (Oil - Us Integrated)
apply to industry (Oil - Us Royalty Trusts)
apply to industry (Oil And Gas - Drilling)
apply to industry (Oil Field Machinery And Equip)
apply to industry (Oil Gas Prod Pipeline Mlp)
apply to industry (Oil Refining And Marketing Mlp)
apply to industry (Other Alt Energy)
apply to industry (Outsourcing)
apply to industry (Paint And Related Products)
apply to industry (Paper And Related Products)
apply to industry (Pollution Controls)
apply to industry (Precious Metals And Jewelry)
apply to industry (Printing - Commercial)
apply to industry (Protection - Safety)
apply to industry (Publishing - Books)
apply to industry (Publishing - Newspapers)
apply to industry (Publishing - Periodicals)
apply to industry (Real Estate Developers)
apply to industry (Real Estate Operations)
apply to industry (Reit - Equity Trust Other)
apply to industry (Reit - Equity Trust Resident)
apply to industry (Reit - Equity Trust Retail)
apply to industry (Reit - Mortgage Trusts)
apply to industry (Retail - Apparel And Shoes)
apply to industry (Retail - Catalog Shopping)
apply to industry (Retail - Consumer Electronics)
apply to industry (Retail - Convenience Stores)
apply to industry (Retail - Discount)
apply to industry (Retail - Drug Stores)
apply to industry (Retail - Home Furniture)
apply to industry (Retail - Jewelry)
apply to industry (Retail - Mail Order)
apply to industry (Retail - Major Dept Stores)
apply to industry (Retail - Misc And Diversified)
apply to industry (Retail - Regional Dept Stores)
apply to industry (Retail - Restaurants)
apply to industry (Retail - Supermarket)
apply to industry (Retail - Wholesale Auto And Trucks)
apply to industry (Retail - Wholesale Auto Parts)
apply to industry (Retail - Wholesale Computers)
apply to industry (Rubber And Plastics)
apply to industry (Rubber Tires)
apply to industry (Satellite Communication)
apply to industry (Schools)
apply to industry (Securities Exchanges)
apply to industry (Semi Analog And Mixed)
apply to industry (Semi Communications)
apply to industry (Semi Discretes)
apply to industry (Semi Fab Foundries)
apply to industry (Semi General)
apply to industry (Semi Graphical)
apply to industry (Semi Memory)
apply to industry (Semi Power)
apply to industry (Semi Pro Logic Devices)
apply to industry (Semi Radio Frequency)
apply to industry (Semi-eqpt Material Services)
apply to industry (Semi-eqpt Photomask)
apply to industry (Semi-eqpt Wafer Companies)
apply to industry (Semi-eqpt Wafer Fabrication)
apply to industry (Shoes And Related Apparel)
apply to industry (Soap And Cleaning Products)
apply to industry (Solar)
apply to industry (Staffing)
apply to industry (Steel - Pipe And Tube)
apply to industry (Steel - Producers)
apply to industry (Steel - Specialty)
apply to industry (Technology Services)
apply to industry (Textile - Apparel)
apply to industry (Textile - Home Furnishings)
apply to industry (Textile - Products)
apply to industry (Tobacco)
apply to industry (Tools - Hand Held)
apply to industry (Toys And Game And Hobby)
apply to industry (Transportation - Air Freight)
apply to industry (Transportation - Airline)
apply to industry (Transportation - Equip And Lease)
apply to industry (Transportation - Rail)
apply to industry (Transportation - Services)
apply to industry (Transportation - Ship)
apply to industry (Transportation - Truck)
apply to industry (Unclassified)
apply to industry (Uniform And Related)
apply to industry (Utility - Electric Power)
apply to industry (Utility - Gas Distribution)
apply to industry (Utility - Water Supply)
apply to industry (Waste Removal Svcs)
apply to industry (Wire And Cable Products)
apply to industry (Wireless Equipment)
apply to industry (Wireless National)
apply to industry (Wireless Non-us)
apply to industry (Wireline National)
apply to industry (Wireline Non-us)
apply to industry (Wireline Regional)



SAFeTRADE
561 posts
msg #139124
Ignore SAFeTRADE
11/6/2017 4:35:55 PM

Credit TRO for this:

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

Leaveout equal 0

add column industry

sort column 5 ascending
]



selfhigh05
23 posts
msg #139126
Ignore selfhigh05
11/7/2017 7:24:26 AM

thanks Safe but how do I use that to filter out unwanted industries, that appears to just list them all without have that long list.

SAFeTRADE
561 posts
msg #139138
Ignore SAFeTRADE
11/7/2017 1:05:00 PM

See this link.

http://www.stockfetcher.com/forums2/General-Discussion/Filter-out-industry-groups/49768/-1/49808

StockFetcher Forums · Filter Exchange · How to filter out Industry - Mining<< >>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 2018 - 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


This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.