I'm looking to build a spreadsheet containing a lot of historical stock data. And I mean A LOT. Specifically, I'm hoping to get each ticker in its own sheet, then have each row correspond to one day in that stock's history. For each day, ideally, I'd like to have some data, possibly an opening price, closing price, high, low, and volume. I'm also looking for more advanced stuff, like earnings per share, spending on R/D, if possible. Basically, more data is better, and I'm looking to gather data on at least 1,000 different stocks. How would I go about doing this?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Stock Data
- Thread starter mrashyman
- Start date
Smitty
Legend
- Joined
- May 15, 2003
- Messages
- 29,536
I don't think you'd want to put your data in separate sheets, because then you can't do comparative analysis. It's better to keep it in a transactional format with one listing per ticker per day. Then you can use PivotTables to analyze it.
Take a look at Chris Newman's Pull stock information into Excel blog post for some pointers about how to use the WEBSERVICE function. There's also this one on using Power Query to do it.
But before you try to recreate the wheel, I'd also note that there are multiple existing platforms to do this.
Take a look at Chris Newman's Pull stock information into Excel blog post for some pointers about how to use the WEBSERVICE function. There's also this one on using Power Query to do it.
But before you try to recreate the wheel, I'd also note that there are multiple existing platforms to do this.
Last edited:
Upvote
0
