www.hoadley.net/options

 

 

 

 

Up

 

 

 

 

Seamless Integration: OptionsXpress & Options Strategy Analysis Tools

If you have an OptionsXpress  account you can use free streaming equity quotes (US markets) and option chains (equities for US and Australian markets) from OptionsXpress:

bullet

with the Hoadley Options Strategy Analysis applications

bullet

in your own Excel spreadsheets.
 

Applications are integrated with the OptionsXpress data feed

The Options Strategy Evaluation Tool  will retrieve live Options Chains from OptionsXpress for US and Australian markets for advanced analysis of options strategies, including strategy comparisons, probability of profit analysis, ROI, position hedging, early exercise analysis and much more.

The Implied Volatility Calculator will use OptionsXpress option chains for monthly volatility smile/skew analysis, implied volatility surface analysis including 3D volatility surface graphing, valuation analysis and hedging optimization.
 

Use streaming quotes and option chains into your own spreadsheets

The Hoadley Finance Add-in for Excel contains a function to connect your own spreadsheets directly to the OptionsXpress streamer (US markets). 

The quotes are fully streaming -- no refresh required -- and the quote functions  can be used in your spreadsheets in exactly the same way as you would use any of the normal Excel functions (SUM, AVERAGE, NPV...).

The add-in also includes a component for bringing live option chains into your own spreadsheets for analysis for both US and Australian markets. To receive option chains on Australian stocks, OptionsXpress accounts must be enabled for Australian market trading.

This combination of the Finance Add-in for Excel plus live data from OptionsXpress provides a powerful analysis platform for traders.  You can use the power of Excel with the Hoadley Finance Add-in to look behind market data to gain a much deeper understanding of option pricing, volatility, probabilities, and hedging.
 

Software Environment 

Microsoft Excel version 2002 (office XP) or above running under Microsoft Windows.  Earlier versions of Excel cannot be used as the real-time data technology (RTD)  required for a robust streaming service was first released in Excel 2002.
 

More Information 

Options Strategy Analysis Tools - overview of tools.

Options Strategy Analysis Tools - home page.

Sign up with OptionsXpress US  or OptionsXpress Australia.

 

Copyright © 2008 Peter Hoadley | Terms of Use