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