Description

This Excel spreadsheet loads option chain data for any ticker available on finance.yahoo.com and/or finance.google.com.

URL to demonstration video: https://youtu.be/tDAnbuk5A90

Here are some features:

• Loads the full option chain for a list of tickers
  • Each ticker will have it’s own output sheet
    • Each sheet includes all expiration dates for the ticker
      • Each expiration date will Includes put and calls in a straddle view
        • All strikes are included, and sorted in ascending order
  • Note that each ticker takes a typical 3-5 minutes to load, depending on
    • Number of expiration dates
    • Number of strikes
    • Internet connection speed
• Separate functionality is also available if you wish to load on a per ticker basis
  • Live Price for any* ticker
  • Historical Prices for any* ticker
  • Option Chain for any* ticker on finance.yahoo.com (User will input one ticker at a time)
  • Option Chain for any expiration dates (It will search for all available expiration dates, and you can select one from the list)
    • Option Chain for ALL expiration dates with 1-click.
  • Option Chain for puts only, or calls only, or puts and calls in a straddle view (with strikes sorted in ascending order)
  • Option Chain for any strike (Given the ticker, expiration date, and put or call or both, it will load the option chain for all strikes)

Product Types: Puts, Calls, Straddles

Please contact us:
If you have requests to customize the spreadsheet, or request for a demonstration/walk-through via the internet.

* The sheet has been explicitly tested on 2017/05/29 to work with the following tickers:

• SPY, MSFT, GOOG, AAPL, TSLA, RDS-A, RDS-B
• We are 99.99% sure all tickers will work, but to be 100% sure, we can test a specific set of tickers for you before hand.
• If there is a ticker you wish to test before you decide to purchase, let us know, and we’ll test it before you purchase.

Works on:

• Windows PC (with an internet connection and access to finance.yahoo.com)
• Microsoft Excel 2016 (Note that older versions of Excel will not work, as they don’t have Workbook Queries)