There is no help available for the downloaded MSNStockQuote function. Can
someone tell me the codes for the "Property" and "CountryCode"; particularly
the codes for Canada and UK?
Does the exchange have to be indicated in the "Symbol" field? If so, what
is the format?

Thanks for your help,
Bob

On Thu, 7 Jul 2005 16:20:01 -0700, Bobtarrel
wrote:

There is no help available for the downloaded MSNStockQuote function. Can
someone tell me the codes for the "Property" and "CountryCode"; particularly
the codes for Canada and UK?
Does the exchange have to be indicated in the "Symbol" field? If so, what
is the format?

Thanks for your help,
Bob

If you select the Insert Stock Quotes button, that should bring up a dialog box
in which you enter those parameters. The dialog box will enter a properly
formatted function in the target cell, and this should give you the info you
require.

For example, for the UK, the symbol is "GB". For Canada, "CA"

So valid formulas might be:

=MSNStockQuote(609140,"Last Price","GB") -- 388.50
=MSNStockQuote(609140,"Company Name","GB") -- A & J Mucklow Group plc

The Property codes are listed in the above mentioned dialog box (they are
actually spelled out like "Last Price" or "52 Week High".

You should be able to access HELP for this from the Data/Stock Quotes from MSN
Money/MSN Money Stock Quotes HELP.

Here is part of that, but it's more legible on the web page:

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

Property argument Value returned
1 or "Last" or "Last Price" or "Last Sale" Price of the last trade
2 or "Time" or "Time of Last Sale" or "Last Sale Time" or "Last Time" or "Date"
or "Date of Last Sale" or "Last Sale Date" Date/time of the last trade,
returned as a serial number, in local time for the New York Stock Exchange
3 or "Size" or "Size Of Last Sale" or "Last Sale Size" or "Last Size" Size of
the last trade
4 or "Ask" or "Asking Price" or "Ask Price" Last asking price
5 or "Ask Size" or "Asking Size" Last asking size
6 or "Bid" or "Bidding Price" or "Bid Price" Last bid price
7 or "Bid Size" or "Bidding Size" Last bid size
8 or "Open" or "Opening Price" or "Open Price" Opening price
9 or "Close" or "Closing Price" or "Previous Close" or "Close Price" Last
closing price
10 or "High" or "High Price" or "Day High" or "Day's High" High price for the
day
11 or "Low" or "Low Price" or "Day Low" or "Day's Low" Low price for the day
12 or "Volume" or "Vol" Volume traded for the day
13 or "Change" or "Chg" Change for the day
14 or "Percent Change" or "% Change" or "%Change" or "% Chg" or "%Chg" Percent
change for the day
15 or "Year High" or "52 Week High" or "52 Wk High" 52 week high
16 or "Year Low" or "52 Week Low" or "52 Wk Low" 52 week low
17 or "Market Cap" or "Market Capital" or "Market Cap." Market capital
18 or "Earnings Per Share" or "EPS" Earnings per share
19 or "PE" or "P/E Ratio" or "PE Ratio" PE ratio
20 or "Shares Outstanding" or "Shares Out" or "Shares Out." or "# Shares Out"
or "# Shares Out" Number of shares outstanding
21 or "Currency" Currency in which the stock is traded
22 or "Exchange" Exchange on which the stock is traded
23 or "Country" Country in which the stock is traded
24 or "Type" Type of stock traded
25 or "Company Name" Company's name

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.

Country Code
Australia AU
Canada CA
Germany DE
France FR
Great Britain GB
Italy IT
United States US

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
Formula Description (Result)
=MSNStockQuote("MSFT") Last price of the U.S. symbol "MSFT"
=MSNStockQuote("MSFT","Open") Opening price of the U.S. symbol "MSFT"
=MSNStockQuote("MSFT",9) Close price for U.S. symbol "MSFT"


--ron

Thank you Ron,

I had been using the normal insert function dialogue which doesn't show the
parameters. With your help, I now have it working. Thanks again.

Bob

"Ron Rosenfeld" wrote:

On Thu, 7 Jul 2005 16:20:01 -0700, Bobtarrel
wrote:

There is no help available for the downloaded MSNStockQuote function. Can
someone tell me the codes for the "Property" and "CountryCode"; particularly
the codes for Canada and UK?
Does the exchange have to be indicated in the "Symbol" field? If so, what
is the format?

Thanks for your help,
Bob

If you select the Insert Stock Quotes button, that should bring up a dialog box
in which you enter those parameters. The dialog box will enter a properly
formatted function in the target cell, and this should give you the info you
require.

For example, for the UK, the symbol is "GB". For Canada, "CA"

So valid formulas might be:

=MSNStockQuote(609140,"Last Price","GB") -- 388.50
=MSNStockQuote(609140,"Company Name","GB") -- A & J Mucklow Group plc

The Property codes are listed in the above mentioned dialog box (they are
actually spelled out like "Last Price" or "52 Week High".

You should be able to access HELP for this from the Data/Stock Quotes from MSN
Money/MSN Money Stock Quotes HELP.

Here is part of that, but it's more legible on the web page:

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

Property argument Value returned
1 or "Last" or "Last Price" or "Last Sale" Price of the last trade
2 or "Time" or "Time of Last Sale" or "Last Sale Time" or "Last Time" or "Date"
or "Date of Last Sale" or "Last Sale Date" Date/time of the last trade,
returned as a serial number, in local time for the New York Stock Exchange
3 or "Size" or "Size Of Last Sale" or "Last Sale Size" or "Last Size" Size of
the last trade
4 or "Ask" or "Asking Price" or "Ask Price" Last asking price
5 or "Ask Size" or "Asking Size" Last asking size
6 or "Bid" or "Bidding Price" or "Bid Price" Last bid price
7 or "Bid Size" or "Bidding Size" Last bid size
8 or "Open" or "Opening Price" or "Open Price" Opening price
9 or "Close" or "Closing Price" or "Previous Close" or "Close Price" Last
closing price
10 or "High" or "High Price" or "Day High" or "Day's High" High price for the
day
11 or "Low" or "Low Price" or "Day Low" or "Day's Low" Low price for the day
12 or "Volume" or "Vol" Volume traded for the day
13 or "Change" or "Chg" Change for the day
14 or "Percent Change" or "% Change" or "%Change" or "% Chg" or "%Chg" Percent
change for the day
15 or "Year High" or "52 Week High" or "52 Wk High" 52 week high
16 or "Year Low" or "52 Week Low" or "52 Wk Low" 52 week low
17 or "Market Cap" or "Market Capital" or "Market Cap." Market capital
18 or "Earnings Per Share" or "EPS" Earnings per share
19 or "PE" or "P/E Ratio" or "PE Ratio" PE ratio
20 or "Shares Outstanding" or "Shares Out" or "Shares Out." or "# Shares Out"
or "# Shares Out" Number of shares outstanding
21 or "Currency" Currency in which the stock is traded
22 or "Exchange" Exchange on which the stock is traded
23 or "Country" Country in which the stock is traded
24 or "Type" Type of stock traded
25 or "Company Name" Company's name

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.

Country Code
Australia AU
Canada CA
Germany DE
France FR
Great Britain GB
Italy IT
United States US

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
Formula Description (Result)
=MSNStockQuote("MSFT") Last price of the U.S. symbol "MSFT"
=MSNStockQuote("MSFT","Open") Opening price of the U.S. symbol "MSFT"
=MSNStockQuote("MSFT",9) Close price for U.S. symbol "MSFT"


--ron