Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

MaxC21 nearly equal to MinC21 Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
traderlady
Posted : Tuesday, August 7, 2018 1:10:18 PM
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)

 

 

Bruce_L
Posted : Tuesday, August 7, 2018 1:16:26 PM


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
traderlady
Posted : Tuesday, August 7, 2018 1:34:33 PM
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?

Bruce_L
Posted : Tuesday, August 7, 2018 1:50:06 PM


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
traderlady
Posted : Tuesday, August 7, 2018 9:31:21 PM
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)

Bruce_L
Posted : Wednesday, August 8, 2018 8:42:47 AM


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
Users browsing this topic
Guest-1

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.