"Insert stock quotes"

[barringcoughlin]

In my windows version of Excel there is an item titled "insert stock
quotes," which allows me to get various stock data items and return
them to the spreadsheet. I can't find this on the windows for Mac. Can
anyone advise me how to replicate this?

thanks

 

[Geoff Lilley]

In my windows version of Excel there is an item titled "insert stock
quotes," which allows me to get various stock data items and return
them to the spreadsheet. I can't find this on the windows for Mac. Can
anyone advise me how to replicate this?

thanks

Go to your "Data" menu, go to "Get External Data," and choose "Run
Saved Query." The query you want is "MSN MoneyCentral Stock Quotes."

HTH.

Cheers
Geoff

 

[barringcoughlin]

Go to your "Data" menu, go to "Get External Data," and choose "Run
Saved Query." The query you want is "MSN MoneyCentral Stock Quotes."

HTH.

Cheers
Geoff

Thanks, Geoff. The problem is that in the Mac version it doesn''t
return a single price which can be put in one cell on a spreadsheet,
unlike in the Windows version. I am trying to fill a spreadsheet with
a column of share prices for different tickers. There may be a
cumbersome workaround which I can ultimately get to, but the earlier,
simple solution escapes me.

Barring

 

[Bob Greenblatt]

Thanks, Geoff. The problem is that in the Mac version it doesn''t
return a single price which can be put in one cell on a spreadsheet,
unlike in the Windows version. I am trying to fill a spreadsheet with
a column of share prices for different tickers. There may be a
cumbersome workaround which I can ultimately get to, but the earlier,
simple solution escapes me.

Barring

The way to do this is to pass a string of ticker symbols to the query. Let
it return the results to a single sheet that can be hidden. Then use a
lookup formula in the cells on the main sheet to extract the price from the
query result. (I do this all the time and it works fine.)

 

[barringcoughlin]

The way to do this is to pass a string of ticker symbols to the query. Let
it return the results to a single sheet that can be hidden. Then use a
lookup formula in the cells on the main sheet to extract the price from the
query result. (I do this all the time and it works fine.)

Bob - that was the only solution I could think of as well, and I may
have to do that workaround. It was so much easier in the earlier
version! I had hoped that I was just missing something obvious in the
Mac version.

Barring