Economics 424:  Computational Finance and Financial Econometrics

Home
Syllabus
Homework
Notes
Excel Hints 
R-Hints
Announcements
Links
Project
Review

Moodle

Excel Hints

Summer 2013

This page contains hints for various computations using Microsoft Excel.

Return Calculations

Review of Random Variables

Descriptive Statistics

Constant Expected Return Model

Introduction to Portfolio Theory

Portfolio Theory with Matrix Algebra

Single Index Model

Excel Links

  • Colin Cameron at UC Davis has a great set of Excel worksheets for data analysis of economic data.