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.
<<Excel TA added--byundt, Microsoft Excel Topic Advisor>>