Gujrati Funda of Trading with Excel

[srichakra]

Cactus,

I was just trying to understand how it works. I guess there is more to it than what the file has. I was trying to see, how this gives inputs for s trade entry for the next day. If it is meant for BTSt, i was totally off teh mark in understanding it

Thanks for your reply.

 

[vyasa]

anybody needs an afl for this?
_SECTION_BEGIN("msf");
mymsf[ 0 ] = C[ 0 ];
for( i = 1; i < BarCount; i++ )
{

mymsf[ i ]=mymsf[ i-1 ]+(C-mymsf[i-1])*.33;
}
Plot(mymsf,"mymsf",colorRed,styleLine);
msfBuy=mymsf>Ref(mymsf,-1);
msfSell=mymsf<Ref(mymsf,-1);
Plot(Close, "Price",colorBlack, styleCandle);
_SECTION_END();
Buy=msfBuy ;
Sell=msfSell ;
PlotShapes( Buy* shapeUpArrow , colorGreen, 0);
PlotShapes( Sell* shapeDownArrow , colorRed, 0);



Filter=1 ;
NumColumns = 0;
AddColumn(Close,"CMP", 1.2);
AddColumn((Close-Ref(C,-1))*100/Ref(C,-1),"change", 1.2);
AddColumn(Ref(Close,-1),"PR.Close", 1.2);
AddColumn( IIf( Buy, 66, 83 ), "Signal" , formatChar,2,4 );
AddColumn(O,"open", 1.2);
AddColumn(H,"HIGH", 1.2);
AddColumn(L,"low", 1.2);
AddColumn(C,"close", 1.2);
suggestions welcome
vyasa

 

[sandeepcmots]

wht is this ?

 

[vyasa]

i just attempted to translate the excel sheet into afl. if u dont understand the afl please look back the excel sheet and i dont calim it is teh perfect one. its the persons jib who posted the excel sheet. let him please comment

 

[Placebo]

why is the msf a factor of 0.33 ? Any Specific Reason behind it ?

 

[pagalguy]

ha ha....MSF is nothing but a 5 day exponential Moving average of closing price.
with alpha = 2/(1+5) = 0.33

 

[4076699]

can we use it for next intraday trade? tell me if any body tried it.