Demo/Tutorial 
Description 
Minutes

Finance Addin for Excel 
Scope
and features 
Overview of the
scope and key features. 
6 
Using the
addin 
How the addin
can be used in your own spreadsheets. 
5 
Probability
analysis example 
An example of
how the addin can be used to to analyse stock price price
probabilities 
4 
Historic
volatility functions (See historic volatility calculator
application below) 
How to
calculate and graph historical volatility using data extracted from the
web. 
6 
Forecasting
volatility with GARCH 
Using the GARCH
model to forecast volatility by day, week, or month ahead, and to construct
volatility term structures for pricing options. 
5 
Streaming quotes 
How to
bring steaming quotes into your own spreadsheets.

3 
Historic & Implied
Volatility Calculators 
Historic
volatility calculator 
Calculculate
and graph historic volatility using data automatically extracted from the
web. Includes GARCH forecasting. 
6.5 
Implied
volatility calculator 
Download complete option chains and calculate
implied volatility and the volatility surface for all options. 
6 
Hedging
optimization 
Scan option
chain and select the optimal combination of trades to meet specific hedge
ratio targets. 
5 
Open Positions Manager 
Whirlwind
tour 
Overview of the
Open Positions Manager application, which makes extensive use of the
addin 
8 
Position
hedging 
Hedging an
entire position in an underlying. 
6 
Portfolio Optimizer & BlackLitterman Asset
Allocation

Portfolio
optimizer 
Optimizing a
portfolio of assets using CAPM/MPT principles 
10 
BlackLitterman 
Using the
BlackLitterman asset allocation model with the Portfolio Optimizer to
produce diversified portfolios. 
10 
Options Strategy Evaluation Tool
(OSET)

Options
Strategy Evaluation Tool 
Construction and analysis of options trading
strategies 
