Get a stock quote
Show All
Hide All
Make sure smart tags (smart tags: Data recognized and labeled as a
particular type. For example, a person's name or the name of a recent
Microsoft Outlook e-mail message recipient is a type of data that can be
recognized and labeled with a smart tag.) are turned on.
How?
Click AutoCorrect options on the Tools menu.
Click the Smart Tags tab, and select the Label data with smart tags check
box.
Type a recognized U.S. financial symbol (for example, MSFT) in a cell. Type
the symbol in capital letters.
Click outside of the cell.
Move your mouse cursor over the purple triangle in the lower-right of the
cell, and then click the arrow next to Smart Tag Actions to see a list of
options.
Click Insert refreshable stock price.
In the Insert Stock Price dialog box, choose whether to insert the stock
price on a new worksheet or in a specific area of your current worksheet.
The data that is returned may fill a large portion of your worksheet.
Note You can also use an add-in to insert a function that retrieves stock
quotes and stock data. For more information, see the Microsoft Office Web site
I have several symbols on my sheet and can refresh data to update quotes.
I then copy the quotes to other sheets to chart data because once I was
keeping the data on that sheet and all of a sudden the sheet grew (from MSNs
site) and messed up my data.