Get a stock quote in Excel 2007

Note: This article has done its job, and will be retiring soon. To prevent "Page not found" woes, we're removing links we know about. If you've created links to this page, please remove them, and together we'll keep the web connected.

  1. Make sure that smart tags are turned on.

    How to turn on smart tags

    1. Click the Microsoft Office Button Office button image , and then click Excel Options.

    2. Click Proofing, and then click AutoCorrect Options.

      The AutoCorrect dialog box appears.

    3. Click the Smart Tags tab, and then select the Label data with smart tags check box.

      Issue:    I don’t see any smart tags in the Recognizers list

      If you don’t see a list of smart tags in the Recognizers list (on the Smart Tags tab in the AutoCorrect dialog box), the Smart Tags add-in must be installed. To install the add-in, do the following:

      1. On your computer's system disk, locate the following folder:

        \Program Files\Common Files\Microsoft Shared\Smart Tag

      2. Run the program SmartTagInstall.exe.

    4. Click OK twice.

  2. Type a recognized U.S. financial symbol (for example, MSFT) in a cell. Be sure to type the symbol in uppercase letters.

  3. Click outside the cell.

  4. Move your mouse pointer over the purple triangle in the lower-right corner of the cell, and then click the arrow next to the Smart Tag Actions Smart Tag Actions button to see a list of options.

  5. Click Insert refreshable stock price.

  6. 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.

    Note: The data that is returned might fill a large portion of your worksheet.

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.