StockFetcher Forums · General Discussion · only filter on particular index?<< >>Post Follow-up
wdewerff
7 posts
msg #86596
Ignore wdewerff
1/19/2010 7:48:51 PM

How do you just filter on say the nasdaq 100?

wdewerff
7 posts
msg #86608
Ignore wdewerff
1/19/2010 9:58:38 PM

Ok, found Market is Nasdaq 100. How would you filter say the nasdaq 100 and the dow 30?

Radiomuse
288 posts
msg #86657
Ignore Radiomuse
1/20/2010 1:11:16 PM

like this...

Fetcher[set{two_indices,count(index is nasdaq 100,1) + count(index is dow 30,1)}

two_indices > 0

add column market

sort column 5 descending
]



*thanks to Four (and to Heyen)

wdewerff
7 posts
msg #86687
Ignore wdewerff
1/20/2010 7:53:36 PM

Thanks, can you tell me what that code does?

four
4,001 posts
msg #86702
Ignore four
modified
1/20/2010 10:54:53 PM

Each line has a comment. The comment is between /* */
--------------------------------
set{two_indices,count(index is nasdaq 100,1) + count(index is dow 30,1)}

/*
user-defined variable = two_indices
When a stock belongs to nasdaq return 1
When a stock belongs to dow return 1

Example:
stock XYZ is in nasdaq but not dow = 1 + 0 = 1 (1 is greater than 0)
stock ABC is in dow but not nasdaq = 0 + 1 = 1 (1 is greater than 0)
stock NNN is in amex. 0 = 0 (0 is not greater than 0)
*/

two_indices > 0

/*do not show a stock that is not in nasdaq. Do not show a stock that is not in dow*/


/*
Thus, XYZ and ABC will display on screen
NNN will not display
*/

add column market
/*show column on screen*/

sort column 5 descending
/*sort descending on column 5 = market*/

StockFetcher Forums · General Discussion · only filter on particular index?<< >>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