Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS

Track the Number of Analyst Earnings Estimates

The EarningsEstimates_numberofestimates_NumEstimatesInConsensus function lets you see how many analysts have contributed earnings estimates for a given stock. By retrieving this figure directly in Excel, you can gauge the level of analytical coverage and consensus in the market, all within your existing spreadsheet workflow. This makes it easier to compare multiple companies side by side, quickly spot trends in coverage, and make more informed decisions based on how many analysts are following a particular symbol.

Why Use This Function?

  • Quickly see the breadth of coverage for a symbol by analyzing how many estimates are in the consensus.
  • Identify how widely followed a company is by market analysts before making investment decisions.
  • Combine with other MarketXLS data points to build a holistic view (e.g., forward P/E from multiple analysts, EPS growth rates, and so on).
  • Helps highlight companies with low coverage (potentially overlooked) or extremely high coverage (widely followed), aiding deeper research.
  • Useful for both short-term traders and long-term investors looking for breadth of market opinion.

How to Use in Excel

=EarningsEstimates_numberofestimates_NumEstimatesInConsensus("SYMBOL")

• Replace "SYMBOL" with the ticker for which you’d like to retrieve the consensus estimate count.
• Press Enter, and the function will return the number of estimates in the current analyst consensus for that stock.
• If the symbol is invalid or no data is found, the function returns "NA".
• In certain cases (e.g., data is being refreshed), the function might return "Refreshing".
• If your MarketXLS license is invalid, you may see an error message instead of the expected number.

Parameters Explained

Parameter Description Example Values Notes
Symbol The ticker symbol representing the company for which you want to see the number of analyst estimates "AAPL", "MSFT", "TSLA" Must be a valid stock symbol. If unavailable or the symbol has no coverage, the function returns "NA".

• “Symbol” accepts the standard ticker symbol (e.g., “AAPL” for Apple).
• Different symbols will produce different results since each company may have a varying number of analysts providing estimates.

Example Usage

Basic Examples

  1. =EarningsEstimates_numberofestimates_NumEstimatesInConsensus("AAPL")
    • Returns the total number of analyst estimates for Apple.
    • Illustrates coverage for a highly followed company.

  2. =EarningsEstimates_numberofestimates_NumEstimatesInConsensus("XYZ")
    • If "XYZ" does not exist or lacks coverage, it will return "NA".
    • Demonstrates how the function handles invalid or rarely followed tickers.

  3. =EarningsEstimates_numberofestimates_NumEstimatesInConsensus("TSLA")
    • Retrieves the number of analyst estimates for Tesla.
    • Useful for comparing coverage levels with other tech or automotive companies.

Advanced Scenarios

• Combine with MarketXLS’s earnings date function to see if a spike in coverage aligns with an upcoming earnings announcement.
• Use in conjunction with a portfolio sheet to quickly see which holdings have the widest or narrowest analyst coverage.
• If data is mid-refresh, you could see “Refreshing” temporarily instead of a final figure. Once the refresh completes, it will update automatically with the correct number.

Common Questions and Troubleshooting

• Why do I get “NA” for some symbols?

  • The symbol might be unrecognized, or there might be no analyst coverage data available for that ticker. Double-check the ticker or ensure the company is covered.

• Why do I get “Refreshing”?

  • This appears if MarketXLS data is updating in the background. Wait a short time and recheck the cell for updated data.

• Does this function work for all global markets?

  • Typically, US-listed companies are well supported, but coverage can vary, especially for less common tickers.

• How can I fix an error message indicating an invalid license?

  • Verify your MarketXLS subscription status and ensure you are signed in properly. Contact MarketXLS support if the issue persists.

• Can the function handle large lists of symbols?

  • Yes, but each call requests data, so if you have many symbols, you may notice a brief delay. MarketXLS queues data retrieval to ensure smooth performance.

By using EarningsEstimates_numberofestimates_NumEstimatesInConsensus, you can gain a quick snapshot of how many analysts are contributing to the consensus for any stock, helping you gauge analyst sentiment and coverage depth—without ever leaving Excel.

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
MarketXLS Excel Add-in Tutorial - How to Use Number Of Estimates In Consensus and Other Financial Formulas
How does MarketXLS work?