Guys,
Does anyone have an excel file with the S&P 500 constituents as of year end for the past 20 years? I don't have access to Compustat, WRDS or bloomberg and would really appreciate someone posting this.
Thanks in advance!
Trending Content
| +72 | Q&A - Buyside Equity Research Analyst/PM | 27 | 1w | |
| +31 | How the heck do you learn all of this stuff? | 5 | 4d | |
| +28 | Getting Frustrated | 10 | 3w | |
| +27 | My experience on the sell side | 20 | 1w | |
| +22 | What’s my next move? | 6 | 2w | |
| +18 | Biotech ER vs IB | 16 | 3w | |
| +14 | Am i fairly compensated? | 7 | 6h | |
| +14 | Data Science to PM | 8 | 1d | |
| +14 | Heard they don’t model at Oppenheimer | 10 | 1w | |
| +13 | ER time line and ways to break in help | 17 | 3w |
Career Resources
I know that this post is really old, but I'm still hoping that you can share with me whether you arrived at the information you needed and, if so, how?
S&P 500 Components Price Historical Data (Originally Posted: 12/07/2014)
Hi all,
I am looking for a database that would allow me to download the historical stock price (for at least 10 years) of each of the 502 components of the SP 500. I don't mind if I have to pay for it as I would like to avoid loosing some days in appending 502 stock data one by one...
Thanks a lot !
Had a similar need for a project I was doing a while ago, if you know VBA that is a huge help, can't post links yet on WSO because I'm 'too new' but if you Google "Multiple Stock Quote Downloader for Excel" it was posted by "Samir Khan". Worked back when I used it..
Where can I get 60 months S&P 500 companies data? (Originally Posted: 08/17/2012)
Hi
I taking financial modelling course and I'm trying to construct an efficient portfolio using financial modelling and I need 60 months data for S&P 500 companies .. Anyone knows where can I get them?
what kind of data? for stock prices and stuff yahoo finance is a good source, but if you are looking for accurate financial statement data you should read the companies' 10-k
Factset, Bloomberg, datastream, etc.
nasdaq and morningstar can give you excel files for free if you dont have bloomberg or any of those softwares. its pretty good. morningstar will even give you financial statements in excel ready to go.
[My first post]: Looking for ER Data (Originally Posted: 03/20/2015)
Hello Everyone,
I am in the early stages of writing my dissertation, or thesis for those of you in the US, and I need to collect data about companies which have joined and left the S&P 500 over a 10-15 year period. I did find one study, but it was really short and unreliable, in my opinion. So, would anyone here happen to know where I can find such information? I'll upvote, or whatever it is that we can do here to promote your answers :)
Thank you
Bump. I would really appreciate some help :)
Oh, and I should mention that I have access to a Bloomberg Terminal, in-case that helps.
Anyone? I'd really appreciate the help.
In itaque veniam tempore exercitationem distinctio. Quas ut et suscipit autem. Facere quis voluptatem voluptates omnis quia iusto. Exercitationem porro voluptas dignissimos odit commodi architecto. Doloribus voluptates eligendi inventore magnam deserunt quibusdam et. Esse aut illum cupiditate aliquam et fugiat vitae fugiat. Voluptatem velit incidunt nisi quaerat aut dolorum.
Eveniet magnam aut necessitatibus optio maiores voluptates. Et iste voluptatum vero occaecati. Molestias repudiandae voluptates rerum ut quod minus cumque.
Repudiandae ex natus occaecati exercitationem. Autem quia reiciendis odit. Et eos numquam cupiditate et quia debitis nisi.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...