Obtain daily price data over the past five years for three different stocks. Dat

Question

Obtain daily price data over the past five years for three different stocks. Data can be obtained from the Internet by using the following keywords: stock price data, return data, company data, and stock returns.

Create trend-moving averages with the following values for m: 10, 100, and 200. Graph the data with Microsoft Excel.

Create centered-moving averages with the following 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?

Explain how these moving averages can assist a stock analyst in determining the stocks%u2019 price direction.

Explanation / Answer

Hey I had similar question last year. All you will have to do is to get the numbers of this year and delete numbers from 2006.
Here is the link for excel.

https://www.dropbox.com/s/47k70g9wd3vl7x4/5%20year.xls

Download it within a week, because I will take delete the file from dropbox after a week.
The data is obtained from http://biz.yahoo.com/research/earncal/today.html using historical data link for three companies. For example for the last company the daily prices are given for company UTi Worldwide Inc. (UTIW) http://finance.yahoo.com/q/hp?s=UTIW&a=08&b=2&c=2006&d=08&e=2&f=2011&g=d

Related Questions

Navigate

• Browse (All)
• Browse O
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.