 |
|
|
|
|
| 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:
 |
with the Hoadley Options Strategy Analysis applications |
|
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.