Stock Answer

Built in service

You can easily insert an automatically updated stock quote for a specific company in a spreadsheet.

Here are the instructions:

1. On the Tools menu, click AutoCorrect options.
   (Use the Office button and Excel Options in 2007+)
   
2. Click the Smart Tags tab and place a check beside Label data with smart tags.
   
3. Click OK.
   
4. Type in a Stock symbol (such as MSFT) in a cell.
   (The symbol must be in all caps)
   
5. Click outside of the cell.
   
6. Place your mouse cursor over the purple triangle in the lower-right corner of the cell.
   Click the arrow.
   
7. Click Insert refreshable stock price.
   
8. Select whether to insert the stock price on a new worksheet or in a specific area on your current worksheet.

You can refresh a stock quote price at any time by right clicking anywhere within your worksheet and selecting Data Range Properties. Enter a value for how often the stock quote price should be refreshed.





See all Topics