Previous Earnings Report Time
Returns the timing indicator (BMO: Before Market Open, AMC: After Market Close) for the most recent earnings report.
Syntax
=mxls.PreviousEarningsReportTime(Symbol)Examples
=PreviousEarningsReportTime("AAPL")When to Use
- Earnings timing analysis
- Historical earnings patterns
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Earnings date | PreviousEarningsReportDate() |
Related Formulas
More MarketXLS Estimates formulas you can use in the same worksheet:
- Price to EPS Estimate Current Year
- Price to EPS Estimate Next Year
- Quarterly Earnings Growth YoY
- Target Price
- 5-Year EPS Growth Rate
- Actual EPS
- Analyst Consensus
- Earnings Estimates Consensus Eps Estimates Trends Current Est Fr1 Month Year
See PreviousEarningsReportTime used in a complete workbook: Earnings Surprise Screener Excel: Track Q1 2026 Earnings Beats and Misses in Real Time
Market data in your Excel sheets
1 billion usable data points on stocks, options, ETFs, and fundamentals, with simple Excel formulas.
See plans
▶
How does MarketXLS work?