Google Answers Logo
View Question
Q: list of stocks ( Answered 4 out of 5 stars,   0 Comments )
Subject: list of stocks
Category: Miscellaneous
Asked by: almo7091-ga
List Price: $20.00
Posted: 11 Apr 2006 06:41 PDT
Expires: 11 May 2006 06:41 PDT
Question ID: 717772
I am looking for a list of all S&P 500, Nasdaq 100 and dow 30 stocks
as well as any other listing of stocks
The list needs to be in excel or text format
Subject: Re: list of stocks
Answered By: leader-ga on 11 Apr 2006 10:28 PDT
Rated:4 out of 5 stars
Dear almo7091-ga:

Before even going in detail to where you may access all of the stock
market data in Excel format, I will provide you the links to download
the SP 500, NASDAQ -100 and DOW 30 stocks to Excel.

Following are the links:

S&P500 ?By components?
S&P500?By industry sectors?

NASDAQ (Entire Market) (Text Format)


Apart from the above list, the best place to gather data for any
market is by going to the Yahoo Finance and than downloading the
required info in an Excel format. The only drawback is that you might
have to download data multiple times because Yahoo only generates
excel data for first 50 symbols and so on. A huge advantage is that
you can get the latest data in Excel format for a huge variety of
markets. The place to start is:

Above is the link to US Indices. You will find a list of all the
Active Indices in this page including Dow, NSYE, AMEX etc (Click on
different tabs). Under each Market, Yahoo provides you a list of
Indices in that market (Bio-100, US 100, World leaders, Industrials
etc). In order to pull the data in Excel format, click on the right
hand side of each where it says ?components?. You will see the first
50 components at once. At the end of the page, click on ?Download to
spreadsheet?. This action will allow you to download the first 50. You
can repeat the process again by clicking on ?Next? to get the next 50
symbols and so on...

Here is the link to World Indices:

Other Useful Links


Useful Search Terms

S&P 500 stocks "list"

If you have any questions, don?t hesitate to ask. I am an active
trader myself. I will be able to answer your questions regarding most



Request for Answer Clarification by almo7091-ga on 11 Apr 2006 11:43 PDT
I sent you the $$ and I tipped you

If you would send me the rest of the information at I woudl appreciate it

If there are other places that I might easily gather spreadsheets with
company names I would gladly pay you for that information as well


almo7091-ga rated this answer:4 out of 5 stars and gave an additional tip of: $5.00
great quick service

There are no comments at this time.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  

Google Home - Answers FAQ - Terms of Service - Privacy Policy