Hi 

I am trying to set up a formule where it give me a X days % change between the highest and the lowest price point. I use MAXH 5.1. for 1 offset and the higest price of 5 previous days.

X days higest price - X days lowest price / current price * 100= X %

But I can not the the com for lowest price in the privous 5 days. I am looking for the lowest price, not the lowest price on a down day. I am wondering which what the formule shall be like. 

Furthure more I would also like to compare this X days % with the pass X days Avg moving % as a refrance to find stock that have consolidation price for a X days. WHich can also included a dip low or fake break. 

Like P.M for the pass 20 days. 

(AVGH-AVGL)/C*100<X%<15%.

Something like that. But i need to find the lowest price, not the lowest closing days price. 

I havent really work out the entire set up yet, but at this stage i am stuck in a few line of com. It will be nice if you can also breafly expalin the basic meaning, so I will be able to learn and understand more on the structure and it's set up. 

Thanks 

So something like the following for the base value?

100 * (MAXH5.1 - MINL5.1) / C

Or maybe this instead?

100 * (MAXH5.1 / MINL5.1 - 1)

The first is the difference between the high and low of the previous five bars as a percentage of the current price.

The second is the percentage that the high of the previous five bars is above the low of the previous five bars.

And something like the following for the following?

AVG(100 * (MAXH5.1 - MINL5.1) / C, 20)

Or possibly the following for the 20 period moving average?

AVG(100 * (MAXH5.1 / MINL5.1 - 1), 20)

These formulas just put an AVG() function around one of the previous two formulas.