Company Name
Returns the official company name associated with a stock ticker symbol.
Supported Symbol Formats
| Type | Format | Example |
|---|---|---|
| US Stocks | SYMBOL | AAPL, MSFT |
| ETFs | SYMBOL | SPY, QQQ |
| Options | OCC Symbol | Returns underlying + option details |
Notes
- Returns the official SEC-registered company name
- For ETFs, returns the fund name
- For options, returns formatted option description
- Returns "NA" if the symbol is not found
Examples
When to Use
- Looking up company names from tickers
- Building watchlists with company names
- Creating reports with full company names
- Labeling charts and dashboards
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need sector | Sector() |
| Need industry | Industry() |
| Need exchange | Exchange() |
| Need company description | Description() |
Common Issues & FAQ
Q: Why am I getting "NA"? A: The ticker symbol may be invalid or not in our database. Verify the symbol is correct.
Q: Does this work for ETFs? A: Yes, it returns the ETF's full fund name.
Q: How do I format the output with the ticker?
A: Use a formula like =Name("AAPL")&" ("&"AAPL"&")" to get "Apple Inc. (AAPL)".
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?