1. On the MSN MoneyCentral Stock Quotes toolbar, click Insert Stock Quotes.
2. In the Symbols or range reference box, type the symbols—or the cell or range reference that contains the symbols—for which you want stock data. When you type symbols in the box, you can separate multiple entries by commas, spaces, or semicolons. For example, you can type MSFT,AOL,INTC.

   Note  If you're unsure of the symbol for which you want to retrieve stock data, click Find Symbol, which is a link to the MSN MoneyCentral Investor Find Symbol tool.

3. In the Country/Region list, select the location of the stock market from which you are retrieving quotes.

   Note  From quotes from Great Britain, Last Price, Ask Price, Bid Price, and Previous Close are returned in British pence, while Currency, Earnings Per Share, and Market Capital are returned in British pounds.

4. In the Properties list, click the properties (for instance, Ask Price for the ask price or Day's High for the day's high price) of the quote you want to retrieve. To select more than one property, press CTRL while clicking each property. If you do not select a property, the last price is returned.
5. Click Add to add the properties to the Selected list. To add all the properties at once, click Add All.

   Note  To change the order of the properties in the Selected box, click the property or properties you want to move and then click Up or Down.

6. Select or clear the Include column headers check box to indicate whether or not property labels should be included as headings in the first row of data returned to the worksheet.
7. Under Destination, click Existing worksheet or New worksheet to specify where you want to return the information.
   • If you click Existing worksheet, then, in the Starting at box, type the reference for the cell that you want to be the upper left cell in the range of values you are returning. For example, if you are returning four values and want the first value to be returned to cell B5, enter B5 in the Starting at box. Keep in mind that if the Include column headers check box is selected, the column headers are returned in the row of your starting cell.
   • If you click New worksheet, the data will be returned to cell A1.
8. Select the Apply default number formats check box to format returned values in decimal format. Clear this check box to retain current cell formatting.
9. Click OK.

Notes

• You can type the MSNStockQuote function directly in a cell, bypassing the Insert Stock Quotes dialog box. See the MSNStockQuote function reference section on this page for more information on the function and for examples.
• Stock quotes are not automatically updated, even if you retype the function in a cell. You must click Update Quotes on the MSN MoneyCentral Stock Quotes toolbar to refresh values.
• The MSN StockQuote function is not designed to work on embedded worksheets. You can save an embedded worksheet as an Excel workbook file by selecting the worksheet object and clicking Worksheet Object on the application Edit menu. Then, click Open on the submenu. Once the object is open in Microsoft Excel, save it as a Microsoft Excel Workbook file.

• On the MSN MoneyCentral Stock Quotes toolbar, click Update Quotes.

Note  The Update Quotes button is unavailable until updated values are returned to the worksheet, and for five minutes after these values are returned. Values are always delayed by at least 15-20 minutes.

Tip  To make it easy to determine the time or date of the last returned quote, include the Time of Last Sale or Date of Last Sale properties as part of the information you return for quotes.

• On the MSN MoneyCentral Stock Quotes toolbar, click Cancel Update.

1. On the MSN MoneyCentral Stock Quotes toolbar, click Help.
2. Click Check for Add-In Updates.

   A Web page will appear with information on the latest updates, and you will have the opportunity to download an update if you wish.

1. On the MSN MoneyCentral Stock Quotes toolbar, click Help.

2. Click About MSN MoneyCentral Stock Quotes.

1. Double-click the Add/Remove Programs icon in the Windows Control Panel.
2. Click Microsoft MSN MoneyCentral Stock Quotes Add-In for Excel, and click Remove.
3. Follow the instructions on the screen.

Note   Clearing the MSNStockQuote.Functions checkbox in the Add-ins dialog box (Tools menu) will not uninstall the program, and may result in errors returned by the function.

• On the MSN MoneyCentral Stock Quotes toolbar, click More Information about Stocks.

MSNStockQuote retrieves stock data from MSN MoneyCentral.

Syntax

MSNStockQuote(Symbol,Property,CountryCode)

Symbol   is a stock symbol (for example: "MSFT", "AOL", "IBM", "AAPL").

Property   is a piece of information regarding the stock, such as Ask Price or Close Price. This is an optional parameter. If omitted, the default is Last Price. You can either type the indicated property as text, or use a value from 1 to 25 to represent the property you want to return.

CountryCode is the two-letter code that represents the country in which the stock is traded (for example: "CA", "GB", "US"). This is an optional parameter. If omitted, the default value is "US". Alternatively, you can enter the country code when you specify the stock symbol (such as, US:MSFT), in which case the CountryCode property is ignored.

Note  For quotes from Great Britain, Last Price, Ask Price, Bid Price, and Previous Close are returned in British pence, while Currency, Earnings Per Share, and Market Capital are returned in British pounds.

Examples