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()
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
Q: When does this value update? A: The value updates after the company releases its quarterly earnings report, typically a few hours after the announcement.
Q: Why is my value different from what I see in the news? A: This returns GAAP diluted EPS. News may report non-GAAP or adjusted EPS which excludes certain items.
Q: Why am I getting "NA"? A: 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)
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today