Analyst Consensus
Returns the number of analysts whose estimates are included in the consensus for a stock. A higher number indicates more analyst coverage and potentially more reliable consensus estimates.
Return Value
Returns an integer representing the count of analysts.
| Value | Meaning |
|---|---|
| 37 | 37 analysts cover this stock |
| 5 | 5 analysts cover this stock |
| 0 or NA | No analyst coverage |
Notes
- Higher numbers suggest better analyst coverage
- Large caps typically have 20-40+ analysts
- Small caps may have fewer than 5
- Zero or NA indicates no coverage
Syntax
=AnalystConsensus(Symbol)Returns
Number of analysts in consensus
Examples
=AnalystConsensus("AAPL")=AnalystConsensus("MSFT")=AnalystConsensus(A1)When to Use
- Assessing reliability of consensus estimates
- Identifying well-covered vs underfollowed stocks
- Research coverage analysis
- Filtering stocks by analyst coverage
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need analyst price target | TargetPriceMean() |
| Need EPS estimate | EPSEstimate() |
| Need analyst recommendation | Use analyst rating functions |
Common Issues & FAQ
What is a good number of analysts?
Large caps typically have 20-40+ analysts. Small caps with 5+ analysts have reasonable coverage. Less than 5 may indicate limited coverage.
Why does coverage vary?
Larger, more actively traded companies attract more analyst attention. Smaller companies may have limited or no coverage.
Excel Templates Using Analyst Consensus
These ready-made MarketXLS templates call AnalystConsensus() in their worksheet formulas. Open one to see the function working inside a complete model.
Related Formulas
More MarketXLS Estimates formulas you can use in the same worksheet:
- Earnings Estimates Consensus Eps Estimates Trends Current Est Fr1 Month Year
- Earnings Estimates Consensus Eps Estimates Trends Current Est Fr1 Value
- Earnings Estimates Consensus Eps Estimates Trends Current Est Fr2 Month Year
- Earnings Estimates Consensus Eps Estimates Trends Current Est Qr1 Month Year
- Earnings Estimates Consensus Eps Estimates Trends Current Est Qr1 Value
- Earnings Estimates Consensus Eps Estimates Trends Current Est Qr2 Month Year
- Earnings Estimates Consensus Eps Estimates Trends Current Est Qr2 Value
- Earnings Estimates Consensus Eps Estimates Trends Days30Ago Fr1 Month Year
See AnalystConsensus used in a complete workbook: Analyst Ratings MCP Server: Live Price Targets and Consensus in Excel and AI
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today