Quotes & Data

Enter a Stock or Index symbol here to download a list of all options and LEAPS for the underlying in comma delimited text format:

Get free real-time spread order pricing with COBWebSM - CBOE's Complex Order Book



Ready to Trade?


Suggestions for Importing this data to Microsoft Excel

Some versions of Excel offer a built-in default formatting mechanism which can corrupt the raw data. These versions may express fractions as dates. Once downloaded, the conversion is not reversible.

We have devised a solution for preserving the price data. It saves the imported quotes as text, not numbers. The principal drawback is possible limitations to manipulating the data further within the spreadsheet program.

  1. Enter the stock or index symbol in the dialog box. Click "Download."
  2. Rename and save the file (QuoteTable.dat) to your hard drive.
  3. Open Excel.
  4. Click "File" - "Open".
  5. Change "Files of Type" area to "All files" from the drop-down menu.
  6. Double-click on your new .dat file. This activates the Excel Text Import Wizard.
  7. Select "Delimited" - then "Next"
  8. De-select "Tab" and select "Comma" - then "Next"
  9. Under "Data Preview", select all columns by pressing and holding the the shift key, and clicking each column header. (Please be sure to select all columns).
  10. In the "Column Data Format" box, select "Text" - then "Finish"
  11. You may now wish to readjust the appearance for easier reading. If desired, click the box at the intersection of the row and column headers to highlight the whole sheet, and select "Format" - "Column" - "AutoFit Selection" to adjust column sizes. Also, click the right-align button on the toolbar. (You may also wish to copy and move the date and time display into another area, or use it as a file title, to make the table narrower.)


 

PLEASE NOTE: IT IS STRICTLY PROHIBITED TO DOWNLOAD DELAYED QUOTE TABLE DATA FROM THIS WEB SITE BY USING AUTO-EXTRACTION PROGRAMS/QUERIES AND/OR SOFTWARE. CBOE WILL BLOCK IP ADDRESSES OF ALL PARTIES WHO ATTEMPT TO DO SO. THIS DATA IS PROPERTY OF THOMSON REUTERS. DOWNLOADING THIS DATA IN ANY OTHER WAY THAN BY MANUAL TICKER SYMBOL ENTRY IS STRICTLY PROHIBITED. You may wish to visit CBOE's Related Sites section where you can review lists of quote vendors who may be able to provide this type of information in the desired format: http://www.cboe.com/Resources/RelatedLinks.aspx



Options involve risk and are not suitable for all investors. Prior to buying or selling an option, a person must receive a copy of Characteristics and Risks of Standardized Options (ODD). Copies of the ODD are available from your broker, by calling 1-888-OPTIONS, or from The Options Clearing Corporation, One North Wacker Drive, Suite 500, Chicago, Illinois 60606. The information on this website is provided solely for general education and information purposes and therefore should not be considered complete, precise, or current. Many of the matters discussed are subject to detailed rules, regulations, and statutory provisions which should be referred to for additional detail and are subject to changes that may not be reflected in the website information. No statement within the website should be construed as a recommendation to buy or sell a security or to provide investment advice. The inclusion of non-CBOE advertisements on the website should not be construed as an endorsement or an indication of the value of any product, service, or website. The Terms and Conditions govern use of this website and use of this website will be deemed acceptance of those Terms and Conditions.