Purchase Solution

Moving Average Forecasting Models

Not what you're looking for?

Ask Custom Question

Obtain the 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 form: 10, 100, and 200. Graph the data with Excel.
•Create centered-moving averages with the following values form: 10, 100, and 200. Graph the data with 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' price direction. Provide a detailed explanation with justifications.
(Word Document and Excel sheet).

Purchase this Solution

Solution Summary

The solution discusses moving average forecasting models.

Solution Preview

Please read the directions carefully vis-à-vis the attached Excel file.

To help you with the three different stocks, I did one for you and detailed how below. I used Microsoft Corporation.

Obtain daily price data over the past five years

1. Go to http://finance.yahoo.com
2. Input 'Microsoft' or MSFT in the 'Enter Symbol' Look Up area. Click Enter
3. Got to 'Historical Prices'
4. Change start date to August 12, 2008
5. Click 'Get Prices'
6. Scroll down until you see 'Download to Spreadsheet' option. Click this
7. Copy all data of the downloaded spreadsheet to the DATA worksheet of the Excel file
Go to ...

Purchase this Solution


Free BrainMass Quizzes
Production and cost theory

Understanding production and cost phenomena will permit firms to make wise decisions concerning output volume.

Organizational Leadership Quiz

This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.

Organizational Behavior (OB)

The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.

Marketing Management Philosophies Quiz

A test on how well a student understands the basic assumptions of marketers on buyers that will form a basis of their marketing strategies.

Six Sigma for Process Improvement

A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.