johlson 3 posts msg #86436 - Ignore johlson |
1/17/2010 9:59:45 AM
What is the syntax to exclude from a filter's results those stocks which have had 3 consecutive daily lows? For example, based on 1/15/2010 data, I want to exclude BARE from the filter result, but include F (Ford). I have tried several formulations, e.g., "count(low is above low 1 day ago, 3) is above 0", but without success. Any help would be greatly appreciated.
|
chetron 2,817 posts msg #86443 - Ignore chetron |
1/17/2010 12:33:31 PM
NOT ALLOWED, EVERY DAY THERE IS A LOW, THUS NEVER NOT consecutive.
HTH
|
johlson 3 posts msg #86445 - Ignore johlson |
1/17/2010 2:03:21 PM
I guess I did a poor job of framing my question. What I am looking for is to distinguish between the case where each succeeding day's low is lower than the last and the case where either or both of the second and third day's lows is higher than the previous day's low. I want to exclude any stock meeting the first case condition from the filter result and include those that meet the second. Can anybody help?
|
chetron 2,817 posts msg #86447 - Ignore chetron |
1/17/2010 2:23:59 PM
maybe....
|