StockFetcher Forums · General Discussion · exclude certain sectors<< 1 2 >>Post Follow-up
nikoschopen
2,824 posts
msg #51199
Ignore nikoschopen
4/18/2007 4:35:46 PM

Ironically, services and technology are intricately strung together by Stockfetcher while, at the same time, it treats technology and energy as odd couples sharing the same bed. Nevertheless, you can still iron out the needless bug by simply adding the extra clause stating that you don't want the energy sector be included in the search. However, since you can't just write "sector is NOT energy" (as it should be IMHO), you would need to go about in a long-winded approach as in the above example.

Fetcher[
set{My_Sector1, count(SECTOR is SERVICES,1) + count(SECTOR is TECHNOLOGY,1)}
set{My_Sector, My_Sector1 - count(SECTOR is ENERGY,1)}
My_Sector above 0
add column sector
]



markd01
10 posts
msg #107288
Ignore markd01
7/29/2012 8:00:53 PM

Can someone tell me why this works for Services but not for Medical sector?

set{Nonsector, count(SECTOR is Services,1)}
set{Anything_But, 1 - Nonsector}
Anything_But is above 0
add column sector

set{Nonsector, count(SECTOR is Medical,1)}
set{Anything_But, 1 - Nonsector}
Anything_But is above 0
add column sector

mkujala
3 posts
msg #158039
Ignore mkujala
11/15/2021 7:00:56 AM

Old thread but unfortunately simplest way seems to be just create filter that lists all you want to include.

Not "Medical"
Fetcher[
/* All except Medical sector*/
apply to sector(Aerospace, Auto-Tires-Trucks, Basic Materials, Business Services, Computer And Technology, Conglomerates, Construction, Consumer Discretionary, Consumer Staples, Finance, Industrial Products, Oils-Energy, Retail-Wholesale, Transportation, Utilities)
and add column sector
]



snappyfrog
653 posts
msg #158043
Ignore snappyfrog
11/16/2021 9:51:28 AM

There is a business services sector and a
technology services industry, so not sure
which you want, or both.

StockFetcher Forums · General Discussion · exclude certain sectors<< 1 2 >>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 2022 - 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.