sboren
9 posts
msg #50867
- Ignore sboren |
4/4/2007 6:49:18 PM
Guys,
I want to filter by multiple sectors like 'sector is financial or sector is utilities'. SF only returns matches in one sector.
Any suggestions for filtering on multiple sectors?
Thanks,
Steve
|
lockwhiz
206 posts
msg #50868
- Ignore lockwhiz
modified |
4/4/2007 8:17:38 PM
Sectors can be sorted by their assigned number ... ie:
1 - Consumer Non-Cyclical
2 - Financial
3 - Basic Materials
4 - Healthcare
5 - Energy
6 - Technology
7 - Services
8 - Transportation
9 - Capital Goods
10 - Utilities
11 - Consumer Cyclical
What you need to use is a tool set that TRO created....you will need to use TRO's BOOLEAN LOGIC for StockFetcher.... this will give you the boolean OR
......search for BOOLEAN LOGIC.
..... post what you come up with !
|
lockwhiz
206 posts
msg #50869
- Ignore lockwhiz
modified |
4/4/2007 8:35:40 PM
...you got me curious ....I decided to get this to work ... So thanks to the RumpledOne work, giving us his tool set here it is:
...or to sort for three sectors Energy, Financial and Utilities:
(sectors 2, 5 and 10)
Fare Well !!
|
sboren
9 posts
msg #50920
- Ignore sboren |
4/7/2007 3:52:29 PM
Thanks guys, I'll give them a try!
|