Registered User
Joined: 10/2/2008
Posts: 16
|
Hi,
Is there a formula or formulas that I can use to scan for stocks with closing prices that have been above the 150 day moving average (simple) for more than 10 days but less than 20 days?
Au197
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Please try the following Condition Formula:
C > AVGC150 AND C1 > AVGC150.1 AND C2 > AVGC150.2 AND C3 > AVGC150.3 AND C4 > AVGC150.4 AND C5 > AVGC150.5 AND C6 > AVGC150.6 AND C7 > AVGC150.7 AND C8 > AVGC150.8 AND C9 > AVGC150.9 AND C10 > AVGC150.10 AND (C11 <= AVGC150.11 OR C12 <= AVGC150.12 OR C13 <= AVGC150.13 OR C14 <= AVGC150.14 OR C15 <= AVGC150.15 OR C16 <= AVGC150.16 OR C17 <= AVGC150.17 OR C18 <= AVGC150.18 OR C19 <= AVGC150.19)
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|