How to Download Stock Data (6 Steps)

Go to your favorite investment research site. Yahoo! Finance and Google Finance are top-rated sites that provide free price quotes. You may also be able to download stock data directly into a spreadsheet from a company's website.
Input the name of the company or the ticker symbol in the Quote Box for a quote. For example, the ticker symbol for General Electric is GE, and you would input GE to get the data.
Click on 'Historical' or 'Historical Prices' in the left-hand pane.
Input the date range you want to study.
Click on the time increment for sorting the data. Options include daily, weekly and monthly price charts.
Click on 'Get Prices' for a list of historical stock prices. In Yahoo! Finance, to download the data to a spreadsheet, scroll to the bottom and click on 'Download to Spreadsheet.' In Google Finance, this is located in the right-hand pane.

How to Get Stock Quotes in Excel

Open Microsoft Excel. First, select 'Start' from the main operating system menu. Next, choose 'Programs.' Then, click on 'Microsoft Office' in the programs menu. Finally, select 'Microsoft Excel' from the Microsoft Office menu.
Click on the 'Data' menu from the Microsoft Excel main menu screen. Then, choose 'Get External Data' from the data menu. A dialog box will appear with a list of established data sources. Finally, choose the data source labeled 'Investor Stock Quotes.'
Select the cell in the spreadsheet for the stock quote information input or choose the 'Create New Worksheet' option to place the stock quote in a new worksheet. After selecting either option, select 'OK' from the dialog box.
Type the stock ticker symbol into the next Microsoft Excel dialog box. If the user wants to update the stock quote in the future, choose 'Use this value/reference for future refreshes.' Also check the second check box if you would like the information to refresh on its own.
Save the Microsoft Excel file for future use. Select 'Save' from the main file menu, name the file and choose the appropriate place on the computer hard drive to save it.