OptDrvr - Options Calculator v11.2

OptDrvr is an Excel addin which provides the user with option pricing models to evaluate stock options (equity options), index options and options on futures. The calculator can also be used to price warrants.

The addin handles American and European style call and put options with or without dividends, determining option fair values, implied volatilities and risk sensitivities. Risk sensitivities (also known as hedge parameters or "Greeks") include deltas, gammas, vegas, thetas and rhos.

The Black & Scholes adjusted model can be used to price options using the Black Scholes model but adjusting for dividends.

All models are accessed by the driver function OptDriver, allowing the user to easily switch between the different option types and models. Thus users can effectively compare options, making OptDrvr an invaluable training aid for novices, whilst being a powerful what-if options analyzer & trading tool for the more experienced options trader.

Spreadsheet template provided which highlights all the features of OptDrvr together with what-if analysis and charting. Users can customise the template or write their own spreadsheets to price options and manage portfolios. Users can also take advantage of all Excel features such as fetching option details & position information from a database or price data from a real-time feed via DDE before using OptDrvr for risk management analysis.

OptDrvr is developed for optimal performance, ease of use and to behave just like any other Microsoft Excel function such that similar to Microsoft Excel functions, OptDrvr can be called from Excel VBA macros, or by using the paste function wizard found by selecting "Insert => Function..." from the Excel menu, or by entering the function directly into the cells.

Option models include:
* Black-Scholes
* Black and Scholes adjusted
* Binomial

Software Developer

Download (54.11 KB)