Quote Table Download

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

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.)