How to Get Stock Market Data Into Excel
By Keith Perry
Microsoft Excel is multifaceted, versatile software that can be used for many functions. The built-in features of Excel make it a very good tool to manipulate and analyze data. Stock market data is probably some of the most manipulated and analyzed data on the planet. For the small investor, using Excel to sort, inspect, graph and analyze stock information is a natural fit.
Open Internet Explorer or Firefox and navigate to the Yahoo! Finance website. The finance site can be found by first going to the Yahoo! main page and selecting the finance category.
Enter the stock quote information desired in the text entry box next to the "Get Quotes" button. Enter "F" to receive information on Ford Motor Company. Multiple stocks can be received by using a blank space to separate them. Entering "F GE WMT" would return Ford , General Electric and Wal-Mart. Press the "Get Quotes" button to recieve the stock information.
After the page with your selected quotes has loaded, click on the link "Download to Spreadsheet."
Click on "Open" when the prompt box is displayed on your screen. This will open Excel with the stock data in the spreadsheet.
Select "File" then "Save As" to save the data to an Excel spreadsheet on your computer. Use the "Save As" function, as the data opened in the spreadsheet will be in read-only mode. The .csv file type that the information comes in is short for comma separated values, which uses a comma to delineate the individual values in the file.
- After you have entered in many stock quotes and clicked "Get Quotes", bookmark the page. This will keep you from having enter the stocks in for subsequent requests.
- If Excel is not available, you can use the spreadsheet program found in the OpenOffice suite called Calc, which is a free, open source spreadsheet similar to Excel.
Keith Perry has been an employee and contractor for several large companies in various information-technology jobs. He holds an executive Master of Business Administration from Jacksonville University with an undergraduate degree in computer science from University of North Florida. He began writing for Lotus Notes Advisor and Mobile Advisor publications in 1998.