Good morning, Bruce,

Let's consider a 30 minute chart -- looking at six 30 minute bars.  But, not the most recent 30 minute opening 30 minute bar today, but the six previous 30 minute bars from yesterday.

What I'm looking for is a value for the narrowest three hours (six 30 minute bars) from yesterday. 

In other words, what is the range shown in percent for between the high of these six 30 minute bars and the low of these six 30 minute bars?

Thus, percentage will allow me to compare various possibilities for trading, seeking to find a narrow three hour range from yesterday and a breakout during the first 30 minutes today.

I hope this is clear enough for you, Bruce, but if not let's try to clarify together.

traderlady

If you are currently in the first 30 minutes of the tradaing day on a 30 minute chart, then the narrowest 6 bar range from yesterday expressed as a percentage would be the following. Note that there should be a much shorter way to express this as a PCF soon.

Min Max PCFs

100 * ((MAXH6.1 / MINL6.1 + MAXH6.2 / MINL6.2 - ABS(MAXH6.1 / MINL6.1 - MAXH6.2 / MINL6.2) + MAXH6.3 / MINL6.3 + MAXH6.4 / MINL6.4 - ABS(MAXH6.3 / MINL6.3 - MAXH6.4 / MINL6.4) - ABS(MAXH6.1 / MINL6.1 + MAXH6.2 / MINL6.2 - ABS(MAXH6.1 / MINL6.1 - MAXH6.2 / MINL6.2) - MAXH6.3 / MINL6.3 - MAXH6.4 / MINL6.4 + ABS(MAXH6.3 / MINL6.3 - MAXH6.4 / MINL6.4)) + MAXH6.5 / MINL6.5 + MAXH6.6 / MINL6.6 - ABS(MAXH6.5 / MINL6.5 - MAXH6.6 / MINL6.6) + MAXH6.7 / MINL6.7 + MAXH6.8 / MINL6.8 - ABS(MAXH6.7 / MINL6.7 - MAXH6.8 / MINL6.8) - ABS(MAXH6.5 / MINL6.5 + MAXH6.6 / MINL6.6 - ABS(MAXH6.5 / MINL6.5 - MAXH6.6 / MINL6.6) - MAXH6.7 / MINL6.7 - MAXH6.8 / MINL6.8 + ABS(MAXH6.7 / MINL6.7 - MAXH6.8 / MINL6.8)) - ABS(MAXH6.1 / MINL6.1 + MAXH6.2 / MINL6.2 - ABS(MAXH6.1 / MINL6.1 - MAXH6.2 / MINL6.2) + MAXH6.3 / MINL6.3 + MAXH6.4 / MINL6.4 - ABS(MAXH6.3 / MINL6.3 - MAXH6.4 / MINL6.4) - ABS(MAXH6.1 / MINL6.1 + MAXH6.2 / MINL6.2 - ABS(MAXH6.1 / MINL6.1 - MAXH6.2 / MINL6.2) - MAXH6.3 / MINL6.3 - MAXH6.4 / MINL6.4 + ABS(MAXH6.3 / MINL6.3 - MAXH6.4 / MINL6.4)) - MAXH6.5 / MINL6.5 - MAXH6.6 / MINL6.6 + ABS(MAXH6.5 / MINL6.5 - MAXH6.6 / MINL6.6) - MAXH6.7 / MINL6.7 - MAXH6.8 / MINL6.8 + ABS(MAXH6.7 / MINL6.7 - MAXH6.8 / MINL6.8) + ABS(MAXH6.5 / MINL6.5 + MAXH6.6 / MINL6.6 - ABS(MAXH6.5 / MINL6.5 - MAXH6.6 / MINL6.6) - MAXH6.7 / MINL6.7 - MAXH6.8 / MINL6.8 + ABS(MAXH6.7 / MINL6.7 - MAXH6.8 / MINL6.8)))) / 8 - 1)

Thanks.  And, I'm pleased that there will be a shorter way to express this soon as you've said.

Hi Bruce,

Perhaps you could help me with a Condition PCF which should specify the following:

- The EMA20 should be above the EMA100 during the last 20 bars or longer;

- The average prices of the last 5 bars should be between these two EMAs (OK if there is an exception, but the average should be valid);

- The average daily range of the last 5 bars should be greater than 0.3 times the range between the two EMAs

Would this be a formula where it would be easy to change the two EMA periods and the range factor?

Many thanks,

Chris 

Please try the following Condition Formula.

TrueInRow(XAVGC20 > XAVGC100, 20) = 20 AND XAVGC20 > AVGC5 AND AVGC5 > XAVGC100 AND AVG(H - L, 5) > .3 * (XAVGC20 - XAVGC100

I think all of the parameters should be fairly obvious. The 20 and 50 after XAVGC are the exponential moving average periods. The two 20s near the end of the TrueInRow section are the number of bars in a row XAVGC20 needs to be above XAVGC200. The 5 after AVGC5 is the number of bars used in calculated the average price which must be between the two other moving averages. The .3 is the factor applied to the current range between the two moving averages.

Thanks very much, Bruce, for the quick result and info. Kind regards, Chris 

You're welcome.