Earnings Date
Returns the next scheduled earnings announcement date for a company. This is useful for tracking when quarterly results will be released.
Supported Symbols
| Type | Format | Example |
|---|---|---|
| US Stocks | SYMBOL | AAPL, MSFT |
| ETFs | N/A | Not applicable |
| Canadian | SYMBOL:CA | SHOP:CA |
Notes
- Returns date in YYYY-MM-DD format
- Date may change if company reschedules
- Some dates are estimates until confirmed
- ETFs don't have earnings dates
Syntax
=earnings_date(Symbol)Examples
=earnings_date("AAPL")=earnings_date("MSFT")=earnings_date("GOOGL")=earnings_date(A1)When to Use
- Planning around earnings announcements
- Building earnings calendars
- Options strategies around earnings
- Portfolio event tracking
- Research scheduling
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need historical earnings | hf_Earnings_per_Basic_Share() |
| Need EPS data | hf_Earnings_per_Basic_Share() |
| Need net income | hf_Net_Income() |
| Need revenue | Revenue() |
Common Issues & FAQ
Why is the date changing?
Companies sometimes reschedule earnings announcements. The date shown is the most current estimate.
Is this confirmed or estimated?
Some dates are confirmed by the company, others are estimates based on historical patterns.
Why does my ETF return NA?
ETFs don't have earnings dates - they hold other securities that do.
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?