Stock prices in Excel?

[graybell]

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

Hi Folks,

Can I set up excel so that it downloads and displays the current stock price for a certain stock every time I open the document or refresh?

I want to use my own workbook, and I'm looking for a free solution, although I might consider an inexpensive add-on.

Thanks!!

 

[John McGhie]

Yes, Excel will do that. Pop over to the Excel forum and they will explain
how:
https://www.microsoft.com/mac/help.mspx?product=Excel&app=1

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

Hi Folks,

Can I set up excel so that it downloads and displays the current stock price
for a certain stock every time I open the document or refresh?

I want to use my own workbook, and I'm looking for a free solution, although I
might consider an inexpensive add-on.

Thanks!!

--
Don't wait for your answer, click here: http://www.word.mvps.org/

Please reply in the group. Please do NOT email me unless I ask you to.

John McGhie, Consultant Technical Writer
McGhie Information Engineering Pty Ltd
http://jgmcghie.fastmail.com.au/
Sydney, Australia. S33°53'34.20 E151°14'54.50
+61 4 1209 1410, mailto:[email protected]

 

[Bob Greenblatt]

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

Hi Folks,

Can I set up excel so that it downloads and displays the current stock price
for a certain stock every time I open the document or refresh?

I want to use my own workbook, and I'm looking for a free solution, although I
might consider an inexpensive add-on.

Thanks!!

Yes, look in Excel help for Web query. There is a god example, and some
sample queries. As John suggested, if you have further specific problems,
post them in the Excel forum.