Retrieve historical data from financial websites

Discussion in 'Data Sets and Feeds' started by WmWaster, May 10, 2006.

  1. Retrieve historical data from financial websites

    Hi.
    How can I tell MS Excel to retrieve historical data automatically from financial websites, like Yahoo, MSN.

    I need historical data of Us and Hong Kong stocks.

    The data I would like to have is:
    - open, low, high, close [most important!]
    - 1-week open, low, high, close [preferred]
    - 52-week high & low [preferred]

    Thank you! :D
     
  2. rosy

    rosy

    i use perl to grab data off several sites and store it in a database. PM me for details
     
  3. Bob111

    Bob111

  4. rocky_te

    rocky_te

  5. Sorry, not that.

    I would like to retrieve infomration directly from the server.

    Eg: I would like to get everyday close for my portfolio. Previously I may need to manually update this data. I would like to find a way which can do this routine automatically.
     
  6. MLDownloader could be an option for you.

    http://www.trading-tools.com/mld.htm

    I haven't used it recently. As I remember, it was a little cumbersome to use. It still might be a reasonably priced choice for your needs.
     
  7. Just wonder.

    It seems all people are getting quotes from Yahoo only. Is it just Yahoo being the only source for Excel in this planet? :D
     
    #10     May 11, 2006