Welcome to Historical Data, from here you can subscribe on-line for historical data products provided by HKEx. It would be great if you develop similar xlsm for downloading multiple stocks’ historical data to monitor performance of my portfolio. Mostly, to monitor growth of a stock relative to other one, I need not see all the fields that the downloaded data shows. So, if a single worksheet can be generated where each column shows stock closed or open price of a company, and each row shows one date, that would be just great.
And for Amibroker, you should change the Date Format from MM/DD/YYYY to DD/MM/YYYY. After specifying your data parameters, you can now click the Give it to me!” It can take a long time, depending on the date range you specified. Go to the destination folder of your downloaded stock quotes, and select all the stock quotes files, and click Open. Amibroker would then import all the historical price data you have downloaded with PSEGet, to your Amibroker.
Note that you have to manually adjust stocks whenever there is a Stock Dividend, Stock Rights, Stock Split or Reverse Stock Split, etc. Now that you have an updated chart of the Philippine Stock Market, you can now learn or practice technical analysis! To get other companies, you will need to replace AAPL with the stock ticker you want. After you save the changes, you can now enter the following in the URL box to get the historical apple inc prices.
For example, I wrote a script to download a list of stocks and calculate moving averages. Historical share prices for Royal Dutch Shell shares traded on the London Stock Exchange, Euronext Amsterdam and the New York Stock Exchange (in ADS form) and historical share prices for the pre-unification shares of Royal Dutch Petroleum Company and The Shell Transport and Trading Company plc.
Global Financial Data provides daily stock prices further back than any other company. If you want to see the data for the Computing Tabulating Recording Co. before it changed its name to IBM in 1924, Adams Express when it was a telegraph company back in 1866, or Wal-Mart when it first listed over the counter, GFD has compiled the historical data for these companies and thousands of others. Data for the NYSE goes back to 1815 on a monthly basis, while data for the AMEX, NASDAQ and OTC stock extends daily back to 1972. The historical stock information provided is for informational purposes only and is not intended for trading purposes.