Excel Option Calculator - Manual

		Contact Site Map

Manual

Manual

EXCEL OPTION CALCULATOR VERSION 10 STEP BY STEP MANUAL
If you are anything like me, the first thing you want to do after opening the Option Calculator is start playing with it immediately. But wait: Going through the manual with the Excel Option Calculator side by side will only take about 15 minutes, save you a lot of trial-and-error, and give you a head start.
Manual overview 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

This manual is for the old version 10.

Click here for information on how to use the new version 11.

© 2005 Excel Option Calculator. All rights reserved. | Disclaimer