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.
Things You'll Need
- Internet Explorer or Firefox browser
- Microsoft Excel
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.
Tips & Warnings
- 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.
How to Get Stock Quotes in Excel
Most people use Microsoft Excel for calculation and data storage. There are other functions in Excel that are very useful but not...
How to Do a Market Segment Analysis
A market segment analysis is one of the fundamental tools for a sales and marketing professional. Very few products can be all...
How to Use Excel for Stock Trading Research
Microsoft Excel can be used to analyze and research stocks by using formulas to determine the future stock price. There are many...
How to Download Yahoo Finance History to Excel
Yahoo Finance is a great source for historical stock prices. The site is simple to navigate. The data is relatively simple to...
How to Make a Real Time Excel Spreadsheet
Microsoft Office Excel is a spreadsheet application that organizes data into columns and rows. It is most often used by individuals to...
Excel Plugins for Google Finance
Alongside its textual and image search engines, cloud-sharing Google Docs, news feeds and other services, the massive tech company offers Google Finance,...
How to Monitor Stock Prices in Microsoft Excel
In order to monitor stock prices in Excel, a spreadsheet needs to be created that outlines the names of companies and significant...