Friday, August 07, 2015

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

No comments: