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