How to Monitor Stock Prices in Microsoft Excel

By eHow Personal Finance Editor

Monitor Stock Prices in Microsoft Excel Monitor Stock Prices in Microsoft Excel

Rate: (17 Ratings)

Whether you have a large stock portfolio or own a few shares of stock, monitoring the performance of your investments can be done with Microsoft Excel, a product in the Microsoft Office software suite. After setting up your stock information in Microsoft Excel, you can update your stock prices with the click of a mouse button.

Instructions

Difficulty: Moderate

Things You’ll Need:

Step1
Open a blank Microsoft Excel spreadsheet.
Step2
Click on a cell where you want to show a stock price.
Step3
Click on “Data” in the top menu bar.
Step4
Scroll down to “Import External Data,” then over to “New Web Query.”
Step5
In the window that pops up, type the URL http://finance.yahoo.com in the address.
Step6
Enter the stock symbol you wish to track. Be sure to double check that you entered the correct stock symbol by checking the company name that shows.
Step7
Scroll down to “Last trade:” and click on the arrow to the left. The arrow will change to a check mark. The data highlighted will be shown on your spreadsheet.
Step8
Choose the data you wish to be in your spreadsheet, then click on the “Import” button at the bottom of the window. You may choose to add any data with an arrow next to it into your spreadsheet by clicking on the arrow to the left of the data.
Step9
Verify the cell where you want the data to appear when prompted. You can click on any cell in the spreadsheet if you wish to change the location. Click on “OK” after choosing the cell.
Step10
Save the spreadsheet. You can update the stock price(s) any time by clicking on “Data” in the top menu bar. Then scroll down to “Refresh Data” and click on it.
Step11
Know that you can also update the stock prices in the “External Data” toolbar. Just click on the red exclamation point in that toolbar.

Tips & Warnings

  • If you have multiple stock holdings, be sure to label your spreadsheet properly to differentiate your stock prices.
  • Use formulas to show your total stock value by multiplying the stock price by the number of shares you own. The formulas will update your total stock value when the stock price is updated

Comments

| View All Comments
Flag This Comment

on 7/1/2008 Thanks so much! This is very informative and helpful.

View All

Post a Comment

POST A COMMENT

Request a New How-To Article

Looking for more How To information? Chances are there’s an eHow member who knows how to do what you’re looking to do. Submit an article request now!

eHow Article:  How to Monitor Stock Prices in Microsoft Excel

eHow Personal Finance Editor

Related Ads

Personal Finance

mpcussen
Meet Mark Cussen eHow’s Personal Finance Expert.