# Documentation

### This is machine translation

Translated by
Mouse over text to see original. Click the button below to return to the English verison of the page.

# MATLAB Commands in Microsoft Excel

Execute MATLAB® commands for Microsoft® Excel® data and show results in spreadsheets

## Functions

 `matlabfcn` Evaluate MATLAB command given Microsoft Excel data `matlabsub` Evaluate MATLAB command given Microsoft Excel data and designate output location `MLEvalString` Evaluate command in MATLAB `MLShowMatlabErrors` Return standard Spreadsheet Link errors or full MATLAB errors using MLEvalString

## Topics

Work with MATLAB Functions in Microsoft Excel

Discover the ways to use Spreadsheet Link™ functions in the Microsoft Excel ribbon, worksheet, or macro.

Work with the MATLAB Function Wizard

The MATLAB Function Wizard for the Spreadsheet Link software lets you browse MATLAB folders and run functions from the Excel interface.

Run a MATLAB Function with Multiple Output Arguments

This example shows how to execute a MATLAB function that returns multiple output arguments in Microsoft Excel using a Microsoft Visual Basic® macro.

Model Data Using Regression and Curve Fitting

Builds a mathematical model of a data set and uses a Microsoft Excel worksheet to organize and display the data

Interpolate Data

Uses a Microsoft Excel worksheet to organize and display input data and the interpolated output data

Price Stock Options Using the Binomial Model

Uses the Spreadsheet Link and Financial Toolbox™ software, to price options with the binomial model

Compute Efficient Frontier of Financial Portfolios

Uses the Spreadsheet Link and Financial Toolbox software to analyze three portfolios, using rates of return for six time periods

Map Time and Bond Cash Flows

Uses the Spreadsheet Link and Financial Toolbox software to compute a set of cash flow amounts and dates, given a portfolio of five bonds

Microsoft Excel and MATLAB Interaction

How the Spreadsheet Link, MATLAB, and Microsoft Excel software all work together