Industry
Returns the industry classification for a company. Industries are more specific than sectors and group companies with similar business activities.
Sector vs Industry Example
| Stock | Sector | Industry |
|---|---|---|
| AAPL | Technology | Consumer Electronics |
| NVDA | Technology | Semiconductors |
| MSFT | Technology | Software - Infrastructure |
| GOOGL | Communication Services | Internet Content & Information |
Common Industries
Technology sector includes industries like:
- Consumer Electronics
- Semiconductors
- Software - Infrastructure
- Software - Application
- Information Technology Services
Financial Services sector includes:
- Banks - Diversified
- Insurance - Diversified
- Asset Management
- Credit Services
Syntax
=Industry(Symbol)Examples
When to Use
- Detailed company classification
- Finding peer companies
- Industry-specific analysis
- Comparing companies in the same industry
- Building industry-focused watchlists
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need broad classification | Sector() |
| Need company peers | peers() |
| Need full description | CompanyProfile() |
| Need SIC classification | SIC_code() |
Common Issues & FAQ
What's the difference between Sector and Industry?
Sector is broader (e.g., "Technology"), while Industry is more specific (e.g., "Semiconductors"). A sector contains multiple industries.
Why might Industry return "NA"?
This can happen for:
- ETFs (no industry classification)
- ADRs and foreign stocks
- Very new listings
- Invalid symbols
Can I screen for stocks by industry?
Yes, use the MarketXLS Screener to filter by specific industries.
Excel Templates Using Industry
These ready-made MarketXLS templates call Industry() in their worksheet formulas. Open one to see the function working inside a complete model.
Related Formulas
More MarketXLS Profile formulas you can use in the same worksheet:
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today
▶
How does MarketXLS work?