Actual EPS
Returns the actual reported earnings per share (EPS) from the company's most recent quarterly earnings report. This is the real, reported value that can be compared against analyst estimates to calculate earnings surprise.
How It Works
After a company reports quarterly earnings, this function returns the actual EPS figure from that report. The value updates after each earnings release.
Return Value
Returns the diluted EPS value in USD (or local currency for non-US stocks).
| Example | Meaning |
|---|---|
| 1.85 | Company earned $1.85 per share |
| -0.50 | Company lost $0.50 per share |
Notes
- Updates after each quarterly earnings report
- Represents diluted EPS (accounts for stock options, convertibles)
- Compare with
EPSEstimate()to calculate earnings surprise - For historical EPS data, use
hf_Earning_Per_Share_Diluted()
Syntax
=EPSActual(Symbol, [ReturnType])Returns
Actual reported diluted EPS for most recent quarter in USD
Examples
=EPSActual("AAPL")=EPSActual("MSFT")=EPSActual(A1)=EPSActual("AAPL")-EPSEstimate("AAPL")When to Use
- Viewing most recent reported earnings
- Calculating earnings surprise vs estimates
- Earnings analysis and comparison
- Verifying reported vs estimated EPS
- Post-earnings report analysis
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need EPS estimate before earnings | EPSEstimate() |
| Need earnings surprise amount | EPSSurprise() |
| Need earnings surprise percentage | EPSSurprisePercent() |
| Need historical quarterly EPS | hf_Earning_Per_Share_Diluted() |
| Need annual EPS | EarningsPerShare() |
Common Issues & FAQ
When does this value update?
The value updates after the company releases its quarterly earnings report, typically a few hours after the announcement.
Why is my value different from what I see in the news?
This returns GAAP diluted EPS. News may report non-GAAP or adjusted EPS which excludes certain items.
Why am I getting "NA"?
The company may:
- Not have reported earnings yet
- Be a newer company without earnings history
- Be an ETF or fund (use fund-specific functions instead)
Excel Templates Using Actual EPS
These ready-made MarketXLS templates call EPSActual() 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:
- Analyst Consensus
- Earnings Estimates Consensus Eps Estimates Trends Current Est Fr1 Month Year
- Earnings Estimates Consensus Eps Estimates Trends Current Est Fr1 Value
- Earnings Estimates Consensus Eps Estimates Trends Current Est Fr2 Month Year
- Earnings Estimates Consensus Eps Estimates Trends Current Est Qr1 Month Year
- Earnings Estimates Consensus Eps Estimates Trends Current Est Qr1 Value
- Earnings Estimates Consensus Eps Estimates Trends Current Est Qr2 Month Year
- Earnings Estimates Consensus Eps Estimates Trends Current Est Qr2 Value
See EPSActual used in a complete workbook: Regional Bank Earnings Tracker Excel: A Yield Curve Watchlist for Q1 2026
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today