Excel Link

Using Excel Link

This section illustrates the use of Excel Link and MATLAB to solve five financial problems:

• Example 1: Regression and Curve Fitting
• Example 2: Interpolating Data
• Example 3: Pricing a Stock Option with the Binomial Model
• Example 4: Calculating and Plotting the Efficient Frontier of Financial Portfolios
• Example 5: Bond Cash Flow and Time Mapping

Tips and Reminders

Using Excel Link