Came across this site when trying to obtain prices from Yahoo on an automatic basis
http://finance.groups.yahoo.com/group/smf_addin/

This link from site gives more info on how it works
http://finance.groups.yahoo.com/group/smf_addin/message/124

It has the ability to get much more than what I use it for which is just to get prices.

Basically once an excel sheet is set up with share codes (Yahoo add ".ax" (BHP.ax) to code) for all the companies I want latest prices for, all I need to is refresh the sheet and this is done automatically.

agk.ax 13.37
bkl.ax 16.85
shv.ax 4.95
nab.ax 23.7
cba.ax 41.66

This is an example of details refreshed a short while ago and is in columns A and B.