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
Syntax
=Name(Symbol)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
Why am I getting "NA"?
The ticker symbol may be invalid or not in our database. Verify the symbol is correct.
Does this work for ETFs?
Yes, it returns the ETF's full fund name.
How do I format the output with the ticker?
Use a formula like =Name("AAPL")&" ("&"AAPL"&")" to get "Apple Inc. (AAPL)".
Excel Templates Using Company Name
These ready-made MarketXLS templates call Name() in their worksheet formulas. Open one to see the function working inside a complete model.
- Portfolio comparison template
- NASDAQ 100 Movement Tracker: Insight on Advancers and Decliners
- Forecasting the Index Level for the Upcoming Four Days
- Murphy Technology Screen
- Portfolio Management (RBSandiego)
- Portfolio Tracker Excel Spreadsheet
- Stock Health Checkup
- Intra Sector View on the basis of Market Cap
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?