 |
|
|
|
|
|
|
|
| Seamless Integration: OptionsXpress & Options Strategy Analysis Tools |
If you have an OptionsXpress account you can use free streaming quotes and option chains for US equities, indices and futures (CBOT, CME, NYBOT, NYMEX) 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, index and futures 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.
The Implied
Volatility Calculator will use OptionsXpress equity, index and
futures 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 (for equities, indices, futures and futures options) 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 and futures markets.
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.