web query

[Guest]

How can I import some stock market price data into excel and update
automatically every 15mins?

I read the help from MS excel but it seems their example only work nothing
else but MSFT. I'd prefer to import the data from YAHOO instead of
microsoftmoney.

Any one to help?

Thanks in advance.

Charlie

 

[Don Guillett]

Contact me privately and I'll send you a file using an external query to
Yahoo.

 

[Guest]

Thank you, Don.

My email address is lambchopman at hotmail dot com


I am particularly interested in monitoring the stocks like
2628.hk
0000001.ss
601628.ss
^DJI (dow jones
^HSI (hang seng index)


Don, is it possible to extract one or two particular data from a website. I
am also interested in adding the exchange rates between

Australian Dollar (AUD) and Hong Kong Dollar(HKD)

http://finance.yahoo.com/currency-converter/#from=AUD;to=HKD;amt=1

I have the above link about have no idea of how to extract the exchange rate
to the spreadsheet.

The version I am using is Office 2007 with Vista Home Basic.



Thanks again, Don.

Charlie

==============================================

 

[Don Guillett]

Send me your file, url, and efforts to date. I'll look in the morning
(e-mail address removed)