Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

MSN Financial Symbols smart tag does not recognize some ticker symbols


View products that this article applies to.

Symptoms

If you enable the MSN MoneyCentral Financial Symbols smart tag in Microsoft Excel, and then type a stock ticker symbol, the smart tag does not recognize the symbol.

↑ Back to the top


Cause

This behavior may occur when any of the following conditions is true:
  • The stock symbol that you typed was not in uppercase (all CAPITAL letters).
  • The stock symbol that you typed is not the only text in the cell.
  • The stock symbol that you typed is only one or two characters long.
  • The stock symbol that you typed was recently added to the stock exchange.

↑ Back to the top


More information

The MSN MoneyCentral Financial Symbols smart tag only recognizes stock symbols that are typed in all capital letters. For example, MSFT is recognized, but Msft is not.

Smart tags in Excel evaluate the entire contents of the cell as a single text string. This means that if you want a stock symbol to be recognized, it must be the only text entered in the cell. For example, if you type Today's quote for MSFT in a cell, the stock symbol is not recognized.

If the stock symbol that you need to recognize is fewer than two characters, you must type the prefix US: in order for the smart tag to recognize it. For example, the smart tag recognizes US:F as the Ford Motor Company stock symbol.

The stock symbols that are recognized are stored in a .dat file on the local hard disk. Excel automatically checks the Web for updates to this file each time you invoke one of the actions on the smart tag menu for MSN MoneyCentral Financial Symbols. Microsoft is no longer updating this file regularly. Therefore, newer stock symbols may not be recognized.

↑ Back to the top


Keywords: KB289816, kbprb

↑ Back to the top

Article Info
Article ID : 289816
Revision : 4
Created on : 9/6/2007
Published on : 9/6/2007
Exists online : False
Views : 436