how to Get historical price from this 2 websites to excel

[cronaldo]

Hi, I really appreciate the excel spreadsheet "stockquotegrabber" for retrieving the stock data from yahoo. However, for the stocks I monitored which is in Hong Kong, such as 0005.HK, the stock data is always a few days behind today, so I would need to get it from other website.

1. http://q.stock.sohu.com/hk/00992/lshq.shtml
2. http://www.quamnet.com/quote.action?quoteSectionCode=pastprices&stockCode=992

The above websites could provide up to date data, can you kindly help me on getting the historical stock quote from the above website? Thanks

 

[rconverse]

Have you tried to copy and paste? You can try using the Excel query tool?

 

[cronaldo]

I am doing automation to get tons of stock data and then do my analysis. For query tool not work for one of the web. I heard that there is some other methods such as xmlhttp.