Current Quarter EPS Estimate

Returns the consensus analyst estimate for earnings per share in the current fiscal quarter. Equivalent to EPSEstimate() for most use cases.

Notes

  • Same as EPSEstimate() for current quarter
  • Updates as analysts revise estimates
  • Use before earnings reports to set expectations

Examples

=CurrentQuarterEPSEstimate("AAPL")
Current quarter estimate
=CurrentQuarterEPSEstimate("MSFT")
Microsoft's Q estimate

When to Use

  • Pre-earnings analysis
  • Current quarter expectations
  • Same use cases as EPSEstimate()

When NOT to Use

Scenario Use Instead
Need next quarter NextQuarterEPSEstimate()
Need full year CurrentYearEPSEstimate()
Need actual reported EPSActual()

Common Issues & FAQ

Q: How is this different from EPSEstimate()? A: They return the same value - current quarter consensus estimate.

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 Current Quarter EPS Estimate and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions