I am developing my own stock anlaysis automation using Excel, but mainly come across problem with data completeness and integrity problem.
I used to download the data from yahoo finance and update it by myself day to day using automation. I have found many great resources here to get data from Yahoo!Finance. However, the stock's historical price in yahoo is not up-to-date, for hong kong stocks, and sometimes for some newly listed stocks, there isn't any historical price to get.
http://hk.finance.yahoo.com/q/hp?s=2345.HK
Question : Is it possible to get the data from these 2 websites (since it is up-to-date) to excel worksheet or an excel file? Many Thanks.
http://www.quamnet.com/quote.action?quoteSectionCode=pastprices&stockCode=2345
http://q.stock.sohu.com/hk/02345/lshq.shtml
I used to download the data from yahoo finance and update it by myself day to day using automation. I have found many great resources here to get data from Yahoo!Finance. However, the stock's historical price in yahoo is not up-to-date, for hong kong stocks, and sometimes for some newly listed stocks, there isn't any historical price to get.
http://hk.finance.yahoo.com/q/hp?s=2345.HK
Question : Is it possible to get the data from these 2 websites (since it is up-to-date) to excel worksheet or an excel file? Many Thanks.
http://www.quamnet.com/quote.action?quoteSectionCode=pastprices&stockCode=2345
http://q.stock.sohu.com/hk/02345/lshq.shtml
