+ Reply to Thread
Results 1 to 2 of 2

Batch Import Historical Stock Data?

  1. #1
    Registered User
    Join Date
    03-06-2012
    Location
    Carolina
    MS-Off Ver
    Excel 2010 Home
    Posts
    3

    Question Batch Import Historical Stock Data?

    Hello all, first time here. I am trying to import data for various stocks so that I can compare their daily percentage of change relative to the day prior. It would ultimately look something like this:

    MSFT AAPL GOOG CSCO
    March 6 .9% 4%
    March 5 -.05% .03% etc
    March 2 -.54% 1.2% etc
    March 1 1.45% -2.22%

    The problem is, the method I have for doing it now is painfully slow, involving downloading a .csv file for each stock from Yahoo Finance. I will eventually have to do this for 1000's of different stocks so I am looking for a way to make it easier on myself. Ideally, I'd like to set the date range, enter the stock symbols and have it create the table automatically. Can someone point me in the right direction? Greatly appreciated, thanks.

    -Edward

    Edit: Cleaned up a bit
    Last edited by eddiekruger; 03-06-2012 at 06:55 PM.

  2. #2
    Registered User
    Join Date
    03-05-2012
    Location
    Paris, France
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: Batch Import Historical Stock Data?

    Hello Edward,

    We use at work an add-ins of the FinTools.
    One of them is an Historical Data Wizard of Stock from Yahoo Finance.
    It looks like what you need and maybe you can download a demo add-in from there Site (www.fintools.com).

    boxen

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1