Sunday, May 24, 2009

Bank Nifty Intraday Chart

Bank nifty Intraday Chart

Wednesday, May 20, 2009

Calculate Exponential Moving Average in excel

If you are confused as to how to calculate exponential moving average, here's an excel spreadsheet which shows you how to do so in very simple terms.

Thursday, April 16, 2009

How to calculate Nifty Moving Average?

Good question, lots of people have confusion in understanding how to calculate Moving averages. Here's a excel spreadsheet where I have calculated moving average of Nifty index (Indian markets). 

The spreadsheet has 10,20,50,100 and 200 day moving averages. The formula is simple - for any given day, take the last 10,20,50,100,200 observations respectively just before that day and calculate a simple average using excel function average(). That is your average. When you do the calculation of next day, you get a new average, and so now you have your moving average series. Check it out, quite simple.