Link cell to current stock price?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

graybell@officeformac.com - 30 Mar 2008 17:06 GMT

Version: 2004
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel

Hi folks, how can I link a cell to the current stock price from the web?

I tried going to DATA, GET EXTERNAL DATA, RUN SAVED QUERY, MSN MONEY STOCK QUOTES, but it inserts a whole page of data. I want just the last price.

Thanks,
~Peter

Reply to this Message

BG - 30 Mar 2008 18:00 GMT

I've always done this by having a full page of data ... and then link the desired target cell to the "Stock price' in the full page of data ... I know there was a more elegant way on the PC ... but as I understand they couldn't easily port that feature (used ActiveX i think)

Reply to this Message

Bob Greenblatt - 31 Mar 2008 13:29 GMT

On 3/30/08 12:06 PM, in article ee96aec.-1@webcrossing.caR9absDaxw,

> Version: 2004
> Operating System: Mac OS X 10.5 (Leopard)
[quoted text clipped - 7 lines]
> Thanks,
> ~Peter

You may need to redesign your sheet slightly. Keep the large sheet with all
the data hidden. Make a new sheet with the data you want linked to the
hidden sheet.

Signature

Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom

Reply to this Message

Mac Forum / Applications / Excel / March 2008

Link cell to current stock price?