Excel Link

Preface

Setting Your Expectations

Typographical Conventions

Related Products

Related Documentation

Information for International Users

Overview

What Is Excel Link?

Understanding the Environment

Installing and Operating Excel Link

System Requirements

Installing Excel Link

Configuring Excel to Work with Excel Link

Starting Excel Link

Automatic Start

Manual Start

Connecting to an Existing MATLAB Session

Stopping Excel Link

What the Functions Do

Link Management Functions

Data Management Functions

Tips and Reminders

Syntax

Worksheets

Macros

Data Types

Dates

Saved Worksheets

Using Excel Link

Example 1: Regression and Curve Fitting

Worksheet Version

Macro Version

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

Function Reference

Functions - By Category

Link Management Functions

Data Management Functions

Functions - Alphabetical List

Error Messages and Troubleshooting

Excel Cell Error Messages

Excel Error Message Boxes

Audible Error Signals

Data Errors

Installed Files

Files and Directories


 Preface