26dma is simple moving average of 26 days closing prices ie avergae of 26 column E values upto last day. similarly for 12 dma, for actual working pls refer excel help or any friend knowing excel basics.
actually instead of simple moving average exponential moving average should be used but slightly difficult in excel, macd value not necessary to calculate in excel as this is readily available on vfm charts and many sites.
8 comments:
sir,
is macd avalivable on K-indicator?if yes please be kind enough to give me its location.
thanks&warm regards.
a merry christmas to u &all on kpl foroum
hi thanks, actually its not in that excel sheet but can be added by simple formula in two adjacent cells,
macd=(26dma-12dma) of closing prices
signal=9dma of macd
whenever macd crosses above signal its a buy and vice versa
hope that helps.
sorry to bother u again,but can u help me get 26dma&12dma.i dont know where to look for it.(new 2 t.a)also,can i interact with you on e-mail?
26dma is simple moving average of 26 days closing prices ie avergae of 26 column E values upto last day. similarly for 12 dma, for actual working pls refer excel help or any friend knowing excel basics.
thank you once again.
sir would this be correct?
15940-(upto24.12.07)/26=5834.85
5941.57(upto24.12.07)/12=5941.57
5843.85-5941.57=(-)97.72
which means 9dma=(-)97.72.
thanks
actually instead of simple moving average exponential moving average should be used but slightly difficult in excel, macd value not necessary to calculate in excel as this is readily available on vfm charts and many sites.
thanks once again
Post a Comment