calculate change in trend & its time & price in excel it may require VBA (i dont know)

Hi Experts,

Need Help On Calculation In Excel,

Want to calculate change in trend & its time & price in excel, criteria is 38.2% change price from start point then consider as turning point (HIGH or LOW). i had described process for the same pls look in to this...

Step 1 Current Close is greater then next 4 data then consider it is down trend or visa versa,this is only to find where to start our calculation i.e it is high point or low point.find start point.(Cloumn H & I)

Step 2 Calculate Range i.e Start Point - Current Data low.Column J

Step 3 Find Max Value From Range. Column K

Step 4 Find 38.2% of range i.e Start point - (K*61.8%) so we get value at 38.2%.

Step 5 M Column indicate if there is touch 38.2% value in C column if it touch then

Step 6 find min value from min value of D column till current data point with it time

Step 7 problem is here now in attached sheet perfectly find low point but next wave's start point is now 5175.10 in current example. so steps to be followed step 2 to step 5..


But i dont know how


pls help me out


Thank You