Watch Lists, Historical Data and Excel®

Discussion in 'Data Sets and Feeds' started by madawaska, Jul 8, 2010.

  1. madawaska

    madawaska

    I'm sure something like this is out there....but don't know where to look...so thought I'd ask here.

    I'd like to build a Watch List of say......500 tradeables.

    If that's too large of a list to accomodate....I can break it down into smaller groupings.

    For that list, I'd like to identify a particular historical trading date and have the closing price for each of these tradeables to be entered.

    I'd then need this closing price data to be extractable to Excel® format.

    Anyone know of how to work with one of the major data feed providers, (Yahoo, stockcharts, etc.), to accomplish this task?

    Thanks for your consideration.

    -Mike
     
  2. rwk

    rwk

  3. Bob111

    Bob111

    or build portfolio(200 or so tickers max for each portfolio) on my yahoo page and use excel web query feature.