EPS Surprise Percentage
Returns the earnings surprise as a percentage of the consensus estimate. This normalizes the surprise, making it easier to compare across companies with different EPS levels.
Return Value
| Value | Meaning |
|---|---|
| 5.2 | Beat estimates by 5.2% |
| -3.1 | Missed estimates by 3.1% |
| 0 | Met estimates exactly |
Notes
- Positive = beat percentage
- Negative = miss percentage
- More comparable across companies than absolute surprise
Syntax
=EPSSurprisePercent(Symbol, [ReturnType])Returns
number
EPS surprise as percentage of estimate
Examples
=EPSSurprisePercent("AAPL")=EPSSurprisePercent("MSFT")=EPSSurprisePercent(A1)When to Use
- Comparing earnings surprises across companies
- Identifying significant beats/misses relative to expectations
- Screening for consistent beaters (high surprise %)
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need dollar amount of surprise | EPSSurprise() |
| Need actual EPS | EPSActual() |
| Need estimate | EPSEstimate() |
Common Issues & FAQ
Is the value already a percentage?
Yes, a value of 5.2 means 5.2% beat. You don't need to multiply by 100.
Excel Templates Using EPS Surprise Percentage
These ready-made MarketXLS templates call EPSSurprisePercent() 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:
- EPSEstimate Current Quarter
- EPSEstimate Current Year
- EPSEstimate Next Quarter
- EPSEstimate Next Year
- High Target Price
- Low Target Price
- Mean Target Price
- One Year Target Price (Analysts)
See EPSSurprisePercent used in a complete workbook: Earnings Surprise Screener Excel: Track Q1 2026 Earnings Beats and Misses in Real Time
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?