Number Of Employees (Historical)
Returns the historical number of employees for a company. This data is typically reported in annual reports and can show workforce growth or contraction over time.
Supported Symbols
| Type | Format | Example |
|---|---|---|
| US Stocks | SYMBOL | AAPL, MSFT |
| ETFs | SYMBOL | SPY, QQQ |
| International | SYMBOL | SHOP, TSM |
Parameters
| Parameter | Description |
|---|---|
| Symbol | Stock ticker symbol |
| Year | Fiscal year (2020, 2021) or period code (lq, ly, lt) |
| Quarter | Optional: 1, 2, 3, or 4 for quarterly data |
| TTM | Optional: Set to "TTM" for trailing twelve months |
Employee-Based Metrics
| Metric | Calculation |
|---|---|
| Revenue per Employee | Revenue / Employees |
| Profit per Employee | Net Income / Employees |
| Assets per Employee | Total Assets / Employees |
Notes
- Employee count includes full-time and often part-time workers
- Contractors may not be included
- Useful for productivity and efficiency analysis
Examples
=hf_Number_of_employees("AAPL", 2023)=hf_Number_of_employees("AMZN", 2023, 2)=hf_Number_of_employees("GOOGL", "ly")=hf_Number_of_employees("META", 2023, , "TTM")=hf_Number_of_employees(A1, B1, C1)When to Use
- Analyzing workforce growth trends
- Calculating revenue per employee
- Understanding company scaling
- Comparing efficiency across companies
- Tracking layoffs and hiring sprees
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need current count | Number_of_Employees() |
| Need labor costs | hf_Selling_General_and_Administrative_Expense() |
| Need compensation data | Manual research |
| Need contractor count | Not available |
Common Issues & FAQ
Q: Why did Meta's employee count drop sharply? A: Meta conducted significant layoffs in 2022-2023, reducing headcount substantially. This is visible in historical data.
Q: Why is Amazon's count so high? A: Amazon has a large warehouse and logistics workforce, making it one of the largest employers globally.
Q: Why am I getting "NA"? A: Employee data is typically only available annually. Quarterly data may not be available for all companies.
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?