EXCEL OPTION CALCULATOR VERSION 10
STEP BY STEP MANUAL

• Step 1: Introduction - Zooming, navigation, color coding

Macro security
Zooming the sheets
Navigation
Cell comments
Color coding and cell protection


• Step 2: Position entry and settings

Adding trade legs
Position entry
Dividend settings
Risk free rate settings


• Step 3: Price retrieval and implied volatility

Manual price entry
Automatic price retrieval
Entering the trade debit/credit
Using your own data source


• Step 4: Risk Graphs

Risk graph settings
Graph types
Saving and comparing risk graphs


• Step 5: Greeks Graphs

Greeks in % or shares
Graphing the greeks
Greeks vs. price
Greeks vs. time


• Step 6: Analysis tools

What-if calculator
Position IV calculator
Breakeven calculator


• Step 7: Statistical volatility tool

Retrieving underlying price data
Reading the SV table
Statistical volatility charts


• Step 8: Probability calculator

Probability calculator settings
Probability calculator results
Standard deviation calculator