Registered User Joined: 6/22/2012 Posts: 13
|
Thanks for engulfing body formula
I would now like to identify stocks that are moving or have moved 15% or more in dollar value either from a high or low over the last x number of days or weeks
15% is just a starting figure as will try 20% etc plus try different time frames
The scan I tried ( price percentage change 30 day ) only seemed to identify stocks on the upside
Thanks Jeff
|

 Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Price Percent Change 30-day is directional. It returns negative values when price is down and positive values when price is up. You could create an Absolute Price Percent Change which would return positive values both when price is up and when price is down:
100 * ABS(C / C30 - 1)
A Condition Formula for a price to have ranged at least 15% over the most recent 20-bars (about 4-weeks on a Daily Chart) could be written as:
MAXH20 >= 1.15 * MINL20
A Condition Formula for price to currently be at least 15% below its high over the most recent 20-bars could be written as:
C <= .85 * MAXH20
A Condition Formula for price to currently be at least 15% above its low over the most recent 20-bars could be written as:
C >= 1.15 * MINL20
A Condition Formula for price to currently be either at least 15% below its high or at least 15% above it low over the most recent 20-bars could be written as:
C <= .85 * MAXH20 OR C >= 1.15 * MINL20
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce Personal Criteria Formulas TC2000 Support Articles
|