Up

 

 

 

 

Seamless Integration: OptionsXpress & Options Strategy Analysis Tools

If you have an OptionsXpress  account you can use free streaming quotes and option chains for US equity 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 equity Options Chain snapshots from OptionsXpress for the US market for advanced analysis of options strategies, including strategy comparisons, probability of profit analysis, ROI, position hedging, early exercise analysis and much more.  Note: Option chains are available for equities and indices only; Futures option chains are not available.

The Implied Volatility Calculator will use OptionsXpress equity 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 the US equity market.

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.