Get daily price data over the past five years for three different stocks. Data can be obtained from the Internet by using the given keywords: stock price data, return data, company data and stock returns.
Make trend-moving averages with the following values for m: 10, 100 and 200. Graph the data with Microsoft Excel. Make centered-moving averages with the given values for m: 10, 100, and 200. Graph the data with Microsoft Excel. How do the moving averages for the same values of m compare between a trend-moving average and a centered-moving average? Describe how these moving averages can help a stock analyst in finding out the stocks' price direction.
Submit your answers in a two- to three-page Microsoft Word document and a Microsoft Excel sheet.