Results 1 to 2 of 2

Batch Import Historical Stock Data?

Threaded View

  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.

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