|
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 - NEW!
|
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.
-
Enter the stock or index symbol in the dialog box. Click "Download."
-
Rename and save the file (QuoteTable.dat) to your hard drive.
-
Open Excel.
-
Click "File" - "Open".
-
Change "Files of Type" area to "All files" from the drop-down menu.
-
Double-click on your new .dat file. This activates the Excel Text Import
Wizard.
-
Select "Delimited" - then "Next"
-
De-select "Tab" and select "Comma" - then "Next"
-
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).
-
In the "Column Data Format" box, select "Text" - then "Finish"
-
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 FINANCIAL/ILX. 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
|
The trade and quote information is compiled for the convenience of site visitors. All quotes are delayed. Your use of trade and quote information is subject to the Terms and Conditions of the CBOE Website.
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 FINANCIAL/ILX. 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
|