| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
 Gold Customer
Joined: 12/5/2004
Posts: 12
|
Dear Sir,
I will be most grateful if you could help me to create a new scan that looks for stocks that have made a new high in the alst 20 days.
I will also like to combine that with a scan that looks for stocks that are trading in a narrow range, for example stocks were the difference between the high and the low over the last 10 trading days is less than 10%.
Looking forward to hearing from you.
Ivo Gwanmesia
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
QUOTE (gwanmesia) I will be most grateful if you could help me to create a new scan that looks for stocks that have made a new high in the alst 20 days.
You want to check for New Highs over the last 20 Days, but over what Period must the New High occur? If it is a 1-Year New High (252-Trading Days), you might want to try using the following Personal Criteria Formula as an EasyScan Condition:
H > MAXH251.1 OR H1 > MAXH251.2 OR H2 > MAXH251.3 OR H3 > MAXH251.4 OR H4 > MAXH251.5 OR H5 > MAXH251.6 OR H6 > MAXH251.7 OR H7 > MAXH251.8 OR H8 > MAXH251.9 OR H9 > MAXH251.10 OR H10 > MAXH251.11 OR H11 > MAXH251.12 OR H12 > MAXH251.13 OR H13 > MAXH251.14 OR H14 > MAXH251.15 OR H15 > MAXH251.16 OR H16 > MAXH251.17 OR H17 > MAXH251.18 OR H18 > MAXH251.19 OR H19 > MAXH251.20
QUOTE (gwanmesia) I will also like to combine that with a scan that looks for stocks that are trading in a narrow range, for example stocks were the difference between the high and the low over the last 10 trading days is less than 10%.
MAXH10 / MINL10 <= 1.1
You may wish to review the following:
How to create a Personal Criteria Forumula (PCF)
Using EasyScan to find stocks that meet your own criteria
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Gold Customer
Joined: 12/5/2004
Posts: 12
|
Thank you so much. It is a great scan.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |