Hi Experts,

I just need to know is there any better way to accomplish Zig -Zag points. as in attached I have macro which populate points by based on formula in H2 & I2.

my logic behind this is - if price retraced or expand 38.20% from one point to other point range. then register new point.

want to create formula which include 3 criteria.

1 if price move either side 38.20% from one point to other point range then register new point.

2.there is minimum 4 data point distance between two points.

3.there is minimum 3% price change from one point to other point.

or total new logic which is I am not aware off.

Basically I want ZigZag point from data set of Open High Low Close.

Thanks

<<Excel TA added--byundt, Microsoft Excel Topic Advisor>>

Math-G-V04.xlsm