Financial Toolbox

Preface

Introducing the Financial Toolbox

Using This Guide

Expected Background

Organization of the Document

Examples

Related Products

Prerequisites

Compatibility

Configuration Information

Additional Resources

Financial Demonstration Programs

Finding Additional Information

Typographical Conventions

Overview

Using Matrix Functions for Finance

Key Definitions

Referencing Matrix Elements

Transposing Matrices

Matrix Algebra Refresher

Adding and Subtracting Matrices

Multiplying Matrices

Dividing Matrices

Solving Simultaneous Linear Equations

Operating Element-by-Element

Function Input/Output Arguments

Input Arguments

Function Output Arguments

Interest Rate Arguments

Tutorial

Handling and Converting Dates

Date Formats

Date Conversions

Current Date and Time

Determining Dates

Formatting Currency

Charting Financial Data

High-Low-Close Chart Example

Bollinger Chart Example

Analyzing and Computing Cash Flows

Interest Rates/Rates of Return

Present or Future Values

Depreciation

Annuities

Pricing and Computing Yields for
Fixed-Income Securities

Terminology

SIA Framework

SIA Default Parameter Values

SIA Coupon Date Calculations

SIA Semi-Annual Yield Conventions

Pricing Functions

Yield Functions

Fixed-Income Sensitivities

Term Structure of Interest Rates

Pricing and Analyzing Equity Derivatives

Sensitivity Measures

Analysis Models

Analyzing Portfolios

Portfolio Optimization Functions

Portfolio Construction Examples

Linear Constraint Equations

Specifying Additional Constraints

Solving Sample Problems

Common Problems in Finance

Sensitivity of Bond Prices to Changes in Interest Rates

Constructing a Bond Portfolio to Hedge Against
Duration and Convexity

Sensitivity of Bond Prices to Parallel Shifts in the Yield Curve

Constructing Greek-Neutral Portfolios of
European Stock Options

Term Structure Analysis and Interest Rate Swap Pricing

Producing Graphics with the Toolbox

Plotting an Efficient Frontier

Plotting Sensitivities of an Option

Plotting Sensitivities of a Portfolio of Options

Function Reference

Functions - By Category

Handling and Converting Dates

Formatting Currency

Charting Financial Data

Analyzing and Computing Cash Flows

Fixed-Income Securities

Analyzing Portfolios

Pricing and Analyzing Derivatives

GARCH Processes

Obsolete Bond Price and Yield Functions

Obsolete BDT Functions

Functions - Alphabetical List

Glossary

Bibliography

Bond Pricing and Yields

Term Structure of Interest Rates

Derivatives Pricing and Yields

Portfolio Analysis

Other References


 Preface