problem_set3 - Step 3: On your spreadsheet, create some new...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Economics 252 Problem Set #3 Stock Market Forecasting Exercise Step 1: Obtain time series data for a major stock price index, in spreadsheet format. One way to do this is to get onto, and click Finance/Quotes, then click Indices, then, for the stock price index you choose, click Chart. Then click Historical Quotes at the bottom of the chart. Then choose the time interval and period, I suggest you use a long enough time interval that you have at least 30 rows of data. Then, at the bottom, click Download Spreadsheet. other monthly data of your own. Step 2. On your spreadsheet, create a new column that shows the percentage change in the index (or log index) between periods (as, if you chose monthly, between months). This will be the dependent variable in your regression.
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Step 3: On your spreadsheet, create some new columns that represent forecasting variables. The simplest thing to do is to define these in terms of the variables already on the spreadsheet. Or, you can enter some other data that you got somewhere else; that would make for some possibly more interesting forecasting exercises. This will be the independent variable in your regression. Be sure, however, that the independent variable was known at the beginning of the interval of price change shown in the same row, so that it is a genuine forecasting variable. Step 4. Run a regression that forecasts the price change (or log price change). Is the t statistic significant? Step 5: Interpret your result, and tell whether you think that you have found a useful? forecasting equation....
View Full Document

This note was uploaded on 02/08/2012 for the course ECON 252 taught by Professor Robertshiller during the Spring '08 term at Yale.

Ask a homework question - tutors are online