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
Syntax
=EPSEstimateCurrentQ(Symbol)Returns
number
Analyst consensus EPS estimate for current quarter
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
What is "current quarter"?
The fiscal quarter currently in progress for the company.
How do I calculate earnings surprise?
After earnings release: (Actual EPS - Estimate) / Estimate * 100 = Surprise %
Related Formulas
More MarketXLS Estimates formulas you can use in the same worksheet:
- EPS Surprise
- EPS Surprise Percentage
- EPSEstimate Current Quarter
- EPSEstimate Current Year
- EPSEstimate Next Quarter
- EPSEstimate Next Year
- High Target Price
- Low Target Price
See EPSEstimateCurrentQ used in a complete workbook: Industrials Earnings Tracker Excel: Q1 2026 Tariff Exposure Watchlist Built in MarketXLS
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?