Real-time Quotes and Option Chains from eSignal
eSignal is one of the leading suppliers of real-time market data for US and international markets. Hoadley Trading & Investment Tools is a certified eSignal partner.
With the Hoadley Finance Add-in for Excel
and a subscription to eSignal and you can include US and international market
real-time streaming quotes (dynamically updating without the need to refresh),
snapshot quotes, and option chains (US, UK, Canadian, Australian, and Indian equities and
indices, and futures options) in your
spreadsheets and spreadsheet applications.
The Options Strategy Evaluation Tool will retrieve live Options Chain snapshots from eSignal (US, UK, Canadian, Australian, Brazilian, and Indian (NSE) equities and indices, and futures options) for advanced analysis of options strategies, including strategy comparisons, probability of profit analysis, ROI, automatic position hedging, early exercise analysis and much more.
The Implied Volatility Calculator will use eSignal
live option chains for monthly volatility smile/skew analysis, implied volatility
surface analysis including 3D volatility surface graphing, valuation analysis and
The Hoadley Finance Add-in for Excel contains a function and function wizard to connect your own spreadsheets directly to the eSignal streamer.
Unlike most common quote solutions, the Hoadley Finance Add-in for Excel does not use Microsoft's obsolete DDE technology for bringing quotes into spreadsheets. Instead it uses the newer RTD (Real-Time Data) technology developed by Microsoft to replace DDE.
RTD is much more robust and flexible than DDE. For instance, with DDE you need to "hard-code" symbols and field names in your spreadsheet formulas. The Hoadley Finance Add-in 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 Add-in for Excel guides you through the simple process of inserting streaming quotes into your own spreadsheet cells. No programming is required and the add-in includes sample worksheets containing examples using eSignal data.
The add-in also includes a component for bringing live option chain
snapshots into your own spreadsheets for analysis.
Among data vendors eSignal is the clear leader in terms of types of instruments available, and international coverage. The types of data include:
By subscribing to eSignal
you will be able to use the full range of eSignal's services (see
details) as well as using the data feed in the Hoadley Finance add-in and
For details, see Finance Add-in for Excel
If you haven't already done so you will need to purchase the Hoadley Finance Add-in for Excel.
Then Subscribe to eSignal and download and install the eSignal software on your PC.
Note that the browser-based eSignal services (eg LiveCharts) cannot be used with the Hoadley Finance Add-in for Excel (or any other third party packages).
Contact eSignal for more information on eSignal services, including promotions that may not be available on their web site, and for help with the eSignal sign-up process.