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
Bookmarks