Gold Customer
Joined: 3/24/2005 Posts: 18
|
How would I writer a scan to determine which stocks had closed higher in eleven of the past thirteen trading days?
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
If you mean the Close is higher than the previous Close:
ABS(C > C1) - (C1 > C2) - (C2 > C3) - (C3 > C4) - (C4 > C5) - (C5 > C6) - (C6 > C7) - (C7 > C8) - (C8 > C9) - (C9 > C10) - (C10 > C11) - (C11 > C12) - (C12 > C13) >= 11
If you mean the Close is higher than the Open:
ABS(C > O) - (C1 > O1) - (C2 > O2) - (C3 > O3) - (C4 > O4) - (C5 > O5) - (C6 > O6) - (C7 > O7) - (C8 > O8) - (C9 > O9) - (C10 > O10) - (C11 > O11) - (C12 > O12) >= 11
You may wish to review the following:
PCF Formula Descriptions
How to create a Personal Criteria Forumula (PCF)
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
Gold Customer
Joined: 3/24/2005 Posts: 18
|
Thanks,
You guys always deliver!
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You're welcome.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|