The Financial Toolbox™ product provides functions that compute prices, sensitivities, and profits for portfolios of options or other equity derivatives. This example uses the binomial model to price an option. The binomial model assumes that the probability of each possible price over time follows a binomial distribution. That is, prices can move to only two values, one up or one down, over any short time period. Plotting these two values over time is known as building a binomial tree.
This example organizes and displays input and output data using a Microsoft® Excel® worksheet. Spreadsheet Link™ functions copy data to a MATLAB® matrix, calculate the prices, and return data to the worksheet.
This example is included in the Spreadsheet Link product. To run it:
Start Excel, Spreadsheet Link, and MATLAB sessions.
Navigate to the folder
Open the file
Execute the example as needed.
Note This example requires Financial Toolbox, Statistics and Machine Learning Toolbox™, and Optimization Toolbox™.
Click the Sheet4 tab on
open the worksheet for this example.
The worksheet contains three named ranges:
Two cells in
bindata contain formulas:
D5 the active cell. Press F2;
then press Enter to execute the Spreadsheet Link function
that copies the asset data to the MATLAB workspace.
D8 and execute the function
that computes the binomial prices.
Execute the functions in
copy the price data to the Excel worksheet.
The worksheet looks as follows.
Read the asset price tree as follows:
Period 1 shows the up and down prices.
Period 2 shows the up-up, up-down, and down-down prices.
Period 3 shows the up-up-up, up-up, down-down, and down-down-down prices.
And so on.
Ignore the zeros. The option value tree gives the associated option value for each node in the price tree. The option value is zero for prices significantly above the exercise price. Ignore the zeros that correspond to a zero in the price tree.
Try changing the data in
and then executing the Spreadsheet Link functions again.
If you increase the time to maturity (
When you finish the example, close the figure window.