"Insert stock quotes"

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

barringcoughlin@gmail.com - 24 Feb 2007 19:30 GMT

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

Reply to this Message

Geoff Lilley - 25 Feb 2007 18:27 GMT

On Feb 24, 11:30 am, "barringcough...@gmail.com"
<barringcough...@gmail.com> wrote:

> 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

Reply to this Message

barringcoughlin@gmail.com - 26 Feb 2007 15:04 GMT

On Feb 25, 11:27 am, "Geoff Lilley" <ruthlesslightn...@gmail.com>
wrote:

> On Feb 24, 11:30 am, "barringcough...@gmail.com"
>
[quoted text clipped - 13 lines]
> 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

Reply to this Message

Bob Greenblatt - 26 Feb 2007 18:09 GMT

On 2/26/07 10:04 AM, in article
1172502292.877924.276850@k78g2000cwa.googlegroups.com,

> On Feb 25, 11:27 am, "Geoff Lilley" <ruthlesslightn...@gmail.com>
> wrote:
[quoted text clipped - 24 lines]
>
> 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.)

Signature

Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom

Reply to this Message

barringcoughlin@gmail.com - 28 Feb 2007 22:14 GMT

> On 2/26/07 10:04 AM, in article
> 1172502292.877924.276...@k78g2000cwa.googlegroups.com,
[quoted text clipped - 37 lines]
> Bob Greenblatt [MVP], Macintosh
> bobgreenblattATmsnDOTcom

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

Reply to this Message

Mac Forum / Applications / Excel / February 2007

"Insert stock quotes"