|
johnnicholson
Posts: 2
Joined: 8/24/2015
Location: Arizona
 User Profile |
I would like to create a scan that shows stocks that in the past 20 days, 75% (15 days), were up bar days (close > open).
Could anyone help to show me how this is accomplished?
- John
|
|
Jim Dean
Posts: 3433
Joined: 3/13/2006
Location: L'ville, GA
User Profile |
Sure. This uses a nifty "trick" ... you sum up the tests for each day and compare them to the minimum total requirement. Each test that is true becomes a -1, while false is 0 ....
15 < -Sum( (C > O), 20)
Minus sign and paren's are important.
|
|
hafnium
Posts: 44
Joined: 6/3/2006
Location: Vienna, VA 22182
User Profile |
Jim
Shouldn't this be either of the below statements
15 <= -Sum( (C > O), 20)
14 < -Sum( (C > O), 20)
|
|
Jim Dean
Posts: 3433
Joined: 3/13/2006
Location: L'ville, GA
User Profile |
Yup ... good catch.
What a difference a day makes :~)
|
|
johnnicholson
Posts: 2
Joined: 8/24/2015
Location: Arizona
User Profile |
Thanks! Works like a charm.
- John
|