ETF Category
Returns the investment category classification for an ETF.
Syntax
=ETFCategory(Symbol)Examples
=ETFCategory("SPY")When to Use
- ETF classification
- Portfolio categorization
- Investment research
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Fund family | ETFFundFamily() |
| Asset details | ETF holdings functions |
Common Issues & FAQ
What categories exist?
Large Blend, Small Value, International, Bond, Sector, etc.
Related Formulas
More MarketXLS ETF & Funds formulas you can use in the same worksheet:
- ETF Fund Family CIK Number
- ETF Holdings
- ETF Inception Date
- ETF Report Period Date
- ETF Report Period End Date
- ETF Total Liabilities
- ETF Yield
- Fund Expense Ratio
See ETFCategory used in a complete workbook: ETF Expense Ratio: What It Is, What's Good, and How to Compare Fund Fees in Excel
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?