EPS Estimate Current Quarter
Returns the analyst consensus estimate for Earnings Per Share (EPS) for the current fiscal quarter.
Supported Symbol Formats
| Type | Format | Example |
|---|---|---|
| US Stocks | SYMBOL | AAPL, MSFT |
Use Cases
- Pre-earnings analysis for current quarter
- Earnings surprise calculations
- Quarterly tracking
Examples
=EPSEstimateCurrentQ("AAPL")=EPSEstimateCurrentQ("MSFT")=EPSEstimateCurrentQ(A1)When to Use
- Monitoring current quarter expectations
- Pre-earnings analysis
- Comparing estimates vs actual (after earnings)
- Building earnings dashboards
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need next quarter estimate | EPSEstimateNextQ() |
| Need annual estimate | EPSEstimateCurrentY() |
| Need actual reported EPS | EarningsPerShare() |
Common Issues & FAQ
Q: What is "current quarter"? A: The fiscal quarter currently in progress for the company.
Q: How do I calculate earnings surprise? A: After earnings release: (Actual EPS - Estimate) / Estimate * 100 = Surprise %
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?