Profile Value
Returns a specific profile data point such as sector, industry, CEO, headquarters, etc.
Syntax
=ProfileValue(Symbol, metric, statistic, profile)Parameters
symbolstringRequired
metricstringRequired
statisticstringRequired
profilestringRequired
Examples
=ProfileValue("AAPL", "sector")When to Use
- Company research
- Sector analysis
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Financial data | FinancialValue() |
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?