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
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
Q: Is the value already a percentage? A: Yes, a value of 5.2 means 5.2% beat. You don't need to multiply by 100.
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?