Home
Syllabus
Homework
Notes 
Excel Hints 
S-PLUS Hints
Announcements
Links
Project
Review

Eric Zivot
Economics 483
Introduction to Computational Finance and Financial Econometrics

Homework Assignments

Fall 2004

• New homework assignments are posted every Wednesday after class. Assignments are due at the beginning of class one week after they are assigned. All Excel spreadsheet and S-PLUS work must be printed. I will not accept homework in electronic format and I will not accept assignments by email (grading becomes too difficult). For printing out your spreadsheets, use Print Preview (File/Print Preview) to determine how the spreadsheet will look when printed. You may find the Print-to-fit feature (File/Print Preview/Setup) helpful. For S-PLUS work, I suggest that you copy and paste statistical output and graphs from S-PLUS into a word processor (e.g MS Word).

• The assignments and solutions are in Adobe Acrobat files (.pdf format). You will need the Adobe Acrobat viewer to view and print the files. Most browsers on campus have the Acobat plug-in installed. If you don't have the Acrobat plug-in you can get it free at Adobe's web site.

Last updated: December 12, 2004

Assignment

Due Date

Programs/Data

Solutions

• Exercises 14 and 15 from my chapter 1 lecture notes (returnsCalculations.pdf)

• S-PLUS introduction (see syllabus page for reading)

Monday 10/11/04 at the beginning of class

download data from finance.yahoo.com. See project page for instructions.

solutions

• 483lab2_fall04.pdf

Monday 10/18/04 at the beginning of class

None needed.

solutions

• 483lab3_fall04.pdf

Wednesday 10/26/04 at the beginning of class

• econ483lab3returns.xls
• lab3.ssc
• descriptiveStatistics.ssc

solutions

• 483lab4_fall04.pdf

Wednesday 11/3/04 at the beginning of class

• econ483lab4returns.xls
• lab4.ssc
• cerModelExamples.ssc

solutions

• 483lab5_fall04.pdf

Wednesday 11/10/04 at the beginning of class

• econ483lab5returns.xls
• 483lab5.ssc
• bootStrap.ssc
• IntroPortfolioTheory.xls

solutions (splus)

solutions (Excel)

• 483lab6_fall04.pdf

Wednesday 11/17/04 at the beginning of class

• IntroPortfolioTheory.xls
• solverex.pdf

solutions

• 483lab7_fall04.pdf

Wednesday 11/24/04 at the beginning of class

• econ483lab6returns.xls
• 483lab7.ssc
• 3firmExample.xls

solutions

• 483lab8_fall04.pdf

Wednesday 12/8/04 at the beginning of class

• 483lab7returns.xls
• 483lab8.ssc

solutions

lab8solutions.ssc

To get data from Yahoo! do the following for each series to be downloaded:

1. Point your browser to the Yahoo! finance site.

2. In the Get Quotes box type the symbol of the stock for which you want data. For example, the symbol for Microsoft is MSFT. If you do not know the ticker symbol use the symbol lookup link at the right of the box.

3. The recent quote for your stock as well as a wealth of other information will be presented on a new page. To get historical prices, click the historical prices link on the upper left panel of the page.

4. A new page will open and you will be able to specify the date ranges for the data to be downloaded and the frequency of the data (daily, weekly or monthly).

5. After setting the date and frequency information, click the get prices button.  This brings up a table with your specified data.

6. At the bottom of the displayed table click on Download to Spreadsheet. This will bring up a Save As dialogue box. Specify a name for the file and save to disk. Each file will contain 6 columns (as in the table below). For monthly data, the column labeled Open gives the opening price at the beginning of the month, the column labeled High gives the highest price during the month, the column labeled Low gives the lowest price during the month, the column labeled Close gives the closing price during the month and the column labeled Volume gives the total monthly volume. The open and the close data have been adjusted for dividends and stock splits. Use the (adjusted) close data for your analysis. 

After downloading your data file, you need to reverse the time ordering of the data in the file. To reverse the time ordering of the data do the following.

Open the .csv file containing your data in Excel. You should see data arranged like the following

Notice that the most recent data is at the top of the spreadsheet. To reverse the date ordering of the data, highlight all of the data (including the column headers). Then select Data/Sort which brings up the Sort dialogue box. In the Sort by box choose Date, click the Ascending option and the OK box. Your data will be sorted from the earliest date to the latest date.