NexusFi: Find Your Edge


Home Menu

 





Stocks by industry and sector


Discussion in Stocks and ETFs

Updated
      Top Posters
    1. looks_one DarkPoolTrading with 6 posts (1 thanks)
    2. looks_two artemiso with 2 posts (1 thanks)
    3. looks_3 Big Mike with 1 posts (1 thanks)
    4. looks_4 Quick Summary with 1 posts (0 thanks)
      Best Posters
    1. looks_one Big Mike with 1 thanks per post
    2. looks_two shodson with 1 thanks per post
    3. looks_3 artemiso with 0.5 thanks per post
    4. looks_4 DarkPoolTrading with 0.2 thanks per post
    1. trending_up 3,238 views
    2. thumb_up 4 thanks given
    3. group 3 followers
    1. forum 10 posts
    2. attach_file 5 attachments




 
Search this Thread

Stocks by industry and sector

  #1 (permalink)
 
DarkPoolTrading's Avatar
 DarkPoolTrading   is a Vendor
 
Posts: 1,036 since May 2012
Thanks Given: 1,244
Thanks Received: 1,326

Does anyone know if and where it is possible to get detailed industry/sector information for all the NYSE and NASDAQ stocks?

Currently I am using the csv's found here: Company List: [AUTOLINK]NASDAQ[/AUTOLINK], [AUTOLINK]NYSE[/AUTOLINK], & AMEX Companies - [AUTOLINK]NASDAQ[/AUTOLINK].com
This contains every stock along with it's sector and industry, but there are a few problems with the data:

- The NYSE data contains 460 stocks with no industry or sector, ie: they listed as 'n/a'
- The NASDAQ data contains 283 stocks with the same issue as above
- The data is not very granular. When combining the NASDAQ and NYSE you have industries with hundreds of stocks and no way to divide up the companies any further.

Basically what im looking for is to be able to further sub-divide companies. @Big Mike I know in your platform thread you at one stage used NAICS codes which I presume you got from IQFeed however from what I can tell you moved away from that. Im unfortunately not an IQFeed customer (not sure if they would provide that information for a once off fee perhaps). Are you or anyone else aware of a source somewhere to further sub-divide the companies listed on the NASDAQ/NYSE?

A good start would be to at least be able to do something with the hundreds of stocks that have no classification, ie: 'n/a'

I've been looking on the NAICS website where they detail all the codes. But I can't seem to find anywhere which actually identifies the companies which fall under each code. Mike I see here you've talked a bit about parsing the naics data: but I still can't figure out how you have tied that to the actual companies that are in each sub-division.

Many thanks.

Diversification is the only free lunch
Follow me on Twitter Started this thread Reply With Quote

Can you help answer these questions
from other members on NexusFi?
Increase in trading performance by 75%
The Elite Circle
NT7 Indicator Script Troubleshooting - Camarilla Pivots
NinjaTrader
Exit Strategy
NinjaTrader
Trade idea based off three indicators.
Traders Hideout
MC PL editor upgrade
MultiCharts
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
Diary of a simple price action trader
26 thanks
Just another trading journal: PA, Wyckoff & Trends
25 thanks
Tao te Trade: way of the WLD
23 thanks
My NQ Trading Journal
16 thanks
HumbleTraders next chapter
9 thanks
  #3 (permalink)
 
shodson's Avatar
 shodson 
OC, California, USA
Quantoholic
 
Experience: Advanced
Platform: IB/TWS, NinjaTrader, ToS
Broker: IB, ToS, Kinetick
Trading: stocks, options, futures, VIX
Posts: 1,976 since Jun 2009
Thanks Given: 533
Thanks Received: 3,709


Try the fundamental data at EODData. I don't know if they have the stocks categorized that you are missing though.

Fundamental Stock Data for Analysis

Follow me on Twitter Visit my NexusFi Trade Journal Reply With Quote
Thanked by:
  #4 (permalink)
 
Big Mike's Avatar
 Big Mike 
Manta, Ecuador
Site Administrator
Developer
Swing Trader
 
Experience: Advanced
Platform: Custom solution
Broker: IBKR
Trading: Stocks & Futures
Frequency: Every few days
Duration: Weeks
Posts: 50,440 since Jun 2009
Thanks Given: 33,207
Thanks Received: 101,599

I use the public list for tickers, but pull most other fundamental data from IQFeed.

Mike

We're here to help: just ask the community or contact our Help Desk

Quick Links: Change your Username or Register as a Vendor
Searching for trading reviews? Review this list
Lifetime Elite Membership: Sign-up for only $149 USD
Exclusive money saving offers from our Site Sponsors: Browse Offers
Report problems with the site: Using the NexusFi changelog thread
Follow me on Twitter Visit my NexusFi Trade Journal Reply With Quote
Thanked by:
  #5 (permalink)
 
DarkPoolTrading's Avatar
 DarkPoolTrading   is a Vendor
 
Posts: 1,036 since May 2012
Thanks Given: 1,244
Thanks Received: 1,326


shodson View Post
Try the fundamental data at EODData. I don't know if they have the stocks categorized that you are missing though.

Fundamental Stock Data for Analysis

Thanks shodson, unfortunately it looks like they don't drill down any further than industry/sector. Im hoping to find sub-industries.


Big Mike View Post
I use the public list for tickers, but pull most other fundamental data from IQFeed.

Mike

Thanks Mike, that's what I figured but was hoping I was wrong. The IQFeed developer api monthly cost is unfortunately just not within my budget at this stage.

All I need is to find somewhere that lists the stock symbols along with their naics code, it doesn't even need to be in a downloadable format since I can code something to scrape it. However i've had no luck finding anything.

Diversification is the only free lunch
Follow me on Twitter Started this thread Reply With Quote
  #6 (permalink)
 
DarkPoolTrading's Avatar
 DarkPoolTrading   is a Vendor
 
Posts: 1,036 since May 2012
Thanks Given: 1,244
Thanks Received: 1,326

aha! bingo: ycharts.com has the naics code for each symbol. Now I just need to code something to scrape that data for every symbol in my db

Second task,....figure out how the hell naics codes actually work in terms of classifying companies...

Diversification is the only free lunch
Follow me on Twitter Started this thread Reply With Quote
  #7 (permalink)
 artemiso 
New York, NY
 
Experience: Beginner
Platform: Vanguard 401k
Broker: Yahoo Finance
Trading: Mutual funds
Posts: 1,152 since Jul 2012
Thanks Given: 784
Thanks Received: 2,685

IQFeed seems to be your best bet if you want something cheap and systematic. Level 1 fundamental messages should provide you the NAICS in field 55. I believe IQFeed's fundamental data is sourced from Morningstar, which means you will have a lot of erroneous data, make sure you do your own consistency checks.


Quoting 
aha! bingo: ycharts.com has the naics code for each symbol. Now I just need to code something to scrape that data for every symbol in my db

If you ever fail to do it, I happen to have all of them.

I've taken the 3 lists on the site you mentioned and helped you fill in most of them. I can't give you all of them because I don't own the data but I can give you enough to match the ones Big Mike has since those are easily accessible from public sources. Password via PM.

Attached Files
Elite Membership required to download: nyse.zip
Elite Membership required to download: nasdaq.zip
Elite Membership required to download: amex.zip
Reply With Quote
Thanked by:
  #8 (permalink)
 
DarkPoolTrading's Avatar
 DarkPoolTrading   is a Vendor
 
Posts: 1,036 since May 2012
Thanks Given: 1,244
Thanks Received: 1,326


artemiso View Post
IQFeed seems to be your best bet if you want something cheap and systematic. Level 1 fundamental messages should provide you the NAICS in field 55. I believe IQFeed's fundamental data is sourced from Morningstar, which means you will have a lot of erroneous data, make sure you do your own consistency checks.



If you ever fail to do it, I happen to have all of them.

I've taken the 3 lists on the site you mentioned and helped you fill in most of them. I can't give you all of them because I don't own the data but I can give you enough to match the ones Big Mike has since those are easily accessible from public sources. Password via PM.

Thanks for this, much appreciated.

Diversification is the only free lunch
Follow me on Twitter Started this thread Reply With Quote
  #9 (permalink)
 
DarkPoolTrading's Avatar
 DarkPoolTrading   is a Vendor
 
Posts: 1,036 since May 2012
Thanks Given: 1,244
Thanks Received: 1,326

hi @artemiso

I've attached the 610 symbols I mentioned to you via pm.

Im a little concerned using the naics codes you provided for these symbols because of the potential for some of these codes being for symbols which are no longer active and are being used by new company tickers.

If you get a chance (and are able to based on your data), please could you query these symbols just to make sure your codes are in fact for symbols that are still active.

Diversification is the only free lunch
Attached Files
Elite Membership required to download: new_nyse.csv
Elite Membership required to download: new_nasdaq.csv
Follow me on Twitter Started this thread Reply With Quote
Thanked by:
  #10 (permalink)
 artemiso 
New York, NY
 
Experience: Beginner
Platform: Vanguard 401k
Broker: Yahoo Finance
Trading: Mutual funds
Posts: 1,152 since Jul 2012
Thanks Given: 784
Thanks Received: 2,685



DarkPoolTrading View Post
hi @artemiso

I've attached the 610 symbols I mentioned to you via pm.

Im a little concerned using the naics codes you provided for these symbols because of the potential for some of these codes being for symbols which are no longer active and are being used by new company tickers.

If you get a chance (and are able to based on your data), please could you query these symbols just to make sure your codes are in fact for symbols that are still active.

Noted your PM, I'm tied up with work for the week but will run a query on those symbols when I get the chance.

Reply With Quote




Last Updated on June 29, 2015


© 2024 NexusFi™, s.a., All Rights Reserved.
Av Ricardo J. Alfaro, Century Tower, Panama City, Panama, Ph: +507 833-9432 (Panama and Intl), +1 888-312-3001 (USA and Canada)
All information is for educational use only and is not investment advice. There is a substantial risk of loss in trading commodity futures, stocks, options and foreign exchange products. Past performance is not indicative of future results.
About Us - Contact Us - Site Rules, Acceptable Use, and Terms and Conditions - Privacy Policy - Downloads - Top
no new posts