Importing AUS stock prices

Good morning oldpos

Originally Posted by oldpos

I am attempting to import stock data prices (open,low,high,close etc) for several stocks in my excel watchlist. (see attachment) I know a little about data query but when used it appears to load data of US stocks via MSMoneyCentral instead of YahooFinance in AUS. I'm using XL2002.

Being a birrova northern hemishpere kinda guy, so wouldn't have the first idea of where to find AUS stock values. If you can point me in the direction of a site that lists the same I could probably help out.

HTH

DominicB

oldpos


Ages ago I build a macro to use Webquery to download prices from
http://www.tradingroom.com.au

This code downloads BHP prices
WhenI was using the entire macro I had a list of stocks on 1 sheet with a summary of the previous days trade & the entire past 12 months prices downloaded into its own sheet for each stock

Please Login or Register  to view this content.

This version gives frices from Yahoo that arein Aus $

Please Login or Register  to view this content.

Have a look at this workbook

I modified your workbook to download prices using web query in a macro from Yahoo

If Yahoo is running slow it can cause a debug error dialog box to pop up.
If you select debug then press F5 the macro will continue

This is one reason I prefer to use http://www.tradingroom.com.au but you can not get todays data until tomorrow