McGinley Dynamic

Dear Friends

Anyone please convert the Formula into Excel Sheet

McGinley Dynamic

Developed by John McGinley in 1990 and published in the Market Technicians Association’s Journal Of Technical Analysis 1997, the McGinley Dynamicattempts to overcome the problems of more traditional simple and exponential moving averages by automatically adjusting itself relative to speed of the market. This allows the McGinley Dynamic to follow prices move closely in fast and slow moving markets while better avoiding price separation and whipsaws. The McGinley Dynamic is calculated by the formula:

Dynamic = D1 + (Price - D1) / (N * (Price/D1)^4)

Where:
D1 = previous value of Dynamic
N = smoothing factor (periods)

i need N has value of 10

//McGinley Dynamic
// By Karthik Marar - www.karthikmarar.blogspot.com
// Public release for personal use only.
//Please do not commercialize this indicator in its original or modified form
_SECTION_BEGIN("McGinley Dynamic - V.1.0");
SetBarsRequired( sbrAll );
N = Param("McGinley Dynamic N ",10,1,30,1);
Output[0] = C[0];

for( i = 1; i < BarCount; i++ )
{
output[ i ] = output[ i - 1 ] + (C-Output[i-1])/( N*(C / Output[i-1])^4) ;
}

Plot(C,"Price",IIf(C>output,colorLime,colorRed),styleBar|styleThick);
Plot(Output,"McGinley Dynamic",colorYellow,1|styleThick);
Plot(MA(C,20),"SMA",colorRed,1);
_SECTION_END();
_SECTION_BEGIN("Title");
if( Status("action") == actionIndicator )
(
Title = EncodeColor(colorWhite)+ "McGinley Dynamic - V.1.0 " + " - " + Name() + " - " + EncodeColor(colorRed)+ Interval(2) + EncodeColor(colorWhite) +
" - " + Date() +" - "+"\n" + EncodeColor(colorYellow) + WriteIf(C>Output, EncodeColor(colorLime) + "Stock Moving Up" ,
EncodeColor(colorRed) + "Stock Moving down"));


All credit goes to the author.

this is not excel but hope u can do it frm understanding the logic of the above code...

ya already i got the afl but need in excel format