tag:blogger.com,1999:blog-61378337847631431392016-09-07T21:27:32.644-07:00Dow Jones Moving AverageHow to calculate moving average. How to calculate exponential moving average. Example of Calculation of moving averages for Dow Jones in excelPinoreply@blogger.comBlogger3125tag:blogger.com,1999:blog-6137833784763143139.post-58610054547055499782009-04-17T04:24:00.001-07:002009-04-26T10:08:42.937-07:00Calculate Dow Jones Exponential Moving AverageMy post below contains the link to an excel spreadsheet which has the <b>calculation for simple moving average</b> for <b>dow jones</b>. Many people asked me for a similar sheet for <b>calculating exponential moving average</b> too. So here it is - the <b>excel sheet</b> with <b>formula to calculate ema</b> for dow jones or for that matter any index or stock.<div><br /></div><div><a href="http://www.ziddu.com/download/4335867/DowJonesExponentialmovingaverage.xls.html">Download the file from here. </a></div><div><br /></div><div><br /></div><div>Download and play with the data, have a look at the <b>formulas</b> and understand how they work.</div>Pinoreply@blogger.com0tag:blogger.com,1999:blog-6137833784763143139.post-30713375433572913522009-04-17T04:20:00.000-07:002009-04-17T04:24:06.334-07:00Dow Jones Moving Average CalculationIts often very confusing as to exactly how we <b>calculate moving average</b> etc. Most sites just say that this is the way, but when it actually comes to doing it, it turns out to be quite confusing, especially the <b>Exponential Moving Average. </b><b>S</b><b>imple Moving Average</b> on the other hand is not all that difficult.<div><br /></div><div>To make your life easy I have illustrated how to calculate moving average etc using real data of <b>Dow jones</b> in an <b>excel spreadsheet.</b> Download and see how these are calculated. Pretty simple to understand then.</div><div><br /></div><div><a href="http://www.ziddu.com/download/4330610/DowJonesMovingAverage.xls.html">You can download the sheet from here.</a></div>Pinoreply@blogger.com0tag:blogger.com,1999:blog-6137833784763143139.post-75754975053390383702009-04-16T04:27:00.000-07:002009-04-26T10:09:13.233-07:00Download Historical Dow Jones DataHere it is, in an <b>excel spreadsheet</b> - cleaned, neatly arranged, the <b>daily open high low close volume</b> and adjusted close since <b>1928 for Dow jones</b>. I have also formed various charts and those too are attached inside. Have a look.<div><br /></div><div><a href="http://www.ziddu.com/download/4326973/dowjonesalltimehistoricaldatawithcharts.xls.html">You can download the sheet here.</a></div>Pinoreply@blogger.com0