

Realtime Quotes and Option Chains from Charles Schwab
Note: obtaining quotations and option chains through Charles Schwab is currently only available to customers who migrated from OptionsXpress during October 2017. If you have an Charles Schwab account which was established as a result of the OptionsXpress migration in October 2017 then you can use free streaming quotes and option chains for US equities, indices and futures (CBOT, CME, NYBOT, NYMEX) from Schwab:
The Options Strategy Evaluation Tool will retrieve live equity, index and futures options chain snapshots from Schwab 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 Schwab 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.
The Hoadley Finance Addin for Excel contains a function to connect your own spreadsheets directly to the Schwab 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...). Unlike most common streaming quote solutions, the Hoadley Finance Addin for Excel does not use Microsoft's obsolete DDE technology for bringing quotes into spreadsheets. Instead it uses the newer RTD (RealTime Data) technology developed by Microsoft to replace DDE. RTD is much more robust and flexible than DDE. For instance, with DDE you need to "hardcode" symbols and field names in your spreadsheet formulas. The Hoadley Finance Addin for Excel on the other hand does not require the "hard coding" of symbols and field names in formulas. It therefore provides much more power, flexibility and ease of use compared with conventional DDE solutions. A function Wizard in the Finance Addin for Excel guides you through the simple process of inserting streaming quotes into your own spreadsheet cells. No programming is required and the addin includes sample worksheets containing examples using Schwab data. The addin also includes a component for bringing live option chain snapshots into your own spreadsheets for analysis for the US equity and futures markets. This combination of the
Finance Addin for Excel plus live data from Schwab provides a powerful
analysis platform for traders. You can use the power of Excel with the Hoadley Finance Addin to look behind market data to gain a much deeper
understanding of option pricing, volatility, probabilities, and hedging.
Microsoft Excel version 2007 or above (32bit and 64bit editions) running under Microsoft Windows. For details, see Finance Addin for Excel
system requirements.
Options Strategy Analysis Tools  overview of tools. Options Strategy Analysis Tools  home page. 