Excel Link

Getting Started

Preface

Setting Your Expectations

Typographical Conventions

Related Products

Related Documentation

Getting Started

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 Automatically

Starting Excel Link Manually

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

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

Reference

Function Reference

Functions by Category

Alphabetical List of Functions

matlabinit

MLAppendMatrix

MLAutoStart

MLClose

MLDeleteMatrix

MLEvalString

MLGetMatrix

MLGetVar

MLOpen

MLPutMatrix

MLPutVar

Error Messages and Troubleshooting

Excel Cell Error Messages

Excel Error Message Boxes

Audible Error Signals

Data Errors

Installed Files

Files and Directories


 Getting Started