Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User Joined: 10/7/2004 Posts: 1,178
|
On a Daily Candlestick Chart, I've plotted two Custom % True PCFs. They are MaxC21 in green dots and MinC21 in red dots. When the green and red dots approach one another in close proximity, nearly equalling, one another (or equalling one another), I'd like a Custom formula that reflects this.
MaxC21 are nearly equal (or equal) to MinC21 by X (X = a flexible percentage)
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
The following would check for the high being within 1% of the low.
1.01 * MINC21 >= MAXC21
While the following would check for being within 0.5%.
1.005 * MINC21 >= MAXC21
You can adjust the 1.01 or 1.005 to adjust the percentages. The part after the decimal marker (.) is the percentage.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 10/7/2004 Posts: 1,178
|
I've tried
1.005 * MINC21 >= MAXC21
and also
1.005 * MINC21 <= MAXC21
all the way up to 1.75
and get no hits even when the green and red visually appear nearly equal on the charts.
Other suggestions?
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
I currently get 126 symbols returned from the US Common Stocks WatchList in a daily time frame for the 1% version and 62 symbols returned for the 0.5% version. Having the 21 period closing highs and lows being this close together is going to pretty rare for an actively trading stock (it would be more common on intraday time frames).
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 10/7/2004 Posts: 1,178
|
I am not getting the kind of results I had expected, even using a one minute PCF.
Is it possible to provide a percentage formula as I requested above?
MaxC21 are nearly equal (or equal) to MinC21 by X (X = a flexible percentage)
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
I think the kind of results you had expected are unsupported by the actual price action of actively trading stocks. Twenty-one bars is a long time for closing prices to remain within 1% of each other when a stock is actually trading.
Try plotting a formula for how far the highest close is above the lowest close as a percentage on the chart as a Custom PCF Indicator to see what I mean.
100 * (MAXC21 / MINC21 - 1)
Or use the slightly longer but more obvious version given below if that formula doesn't seem to make sense to you.
100 * (MAXC21 - MINC21) / MINC21
You can just add a <= 1 to the end of this to check for the value being less than 1%.
100 * (MAXC21 / MINC21 - 1) <= 1
But this is longer and more computationally intensive the the original formula without really being any easier to adjust.
1.01 * MINC21 >= MAXC21
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Guest-1 |