Market Data’s EARNINGS formula makes it easy to get upcoming earnings reports for whatever company you’re following. For stock and options traders, earnings release days are days of extreme volatility and these days can present opportunities for investors who look to trade around volatile sessions. Some investors prefer to avoid these days entirely and don’t like to trade binary events such as earnings releases. With the EARNINGS formula, you’ll be able to build your own earnings calendar and keep an eye out for when your positions report earnings.
In the example shown we can see that AAPL is going to report its fiscal 2024 1st quarter earnings on 1/31/2024 before the market opens. This corresponds with the quarter that closes on 12/31/2023, but this is actually AAPL’s first quarter of fiscal 2024. Anyalists have estimated that the earnings reported will be $1.94 per share. At the time of this writing (December 2023), there are no analyst estimates yet for quarters 2-4 since they are more than 5 months out.
Also, reported EPS and the surprise EPS will also return blank cells unless the formula includes historical dates. Since the default formula returns only a future earnings calendar, these columns will always be blank.
Earnings Calendar Syntax
No matter what your preferences are, you can use the EARNINGS formula to find out when a company’s earnings report will be released and what what Wall Street analysts are predicting.
The formula is extremely configurable and uses 4 parameters:
- Stock ticker you want to lookup.
- The columns you want returned. Separate multiple columns with a coma or use the word “all” to return all data.
- The start date.
- The end date.
Earnings Calendar Examples
=EARNINGS("AAPL")- This will output all future earnings reports for AAPL.
=EARNINGS("AAPL","report date")- All future earnings reports, but restrict the column to just the report date. Suppress the rest of the column output.
=EARNINGS("AAPL","report date","today","1 month")- Output only the report date and limit the output to one month from today.
=EARNINGS("AAPL","report date,noheaders","today","1 month")- Output only the report date and limit the output to one month from today and remove the header values from the output. This is useful for building large tables, outputting the result in just a single cell, or for stacking one output row on top of another.
Historical Earnings Calendar for Stocks
It is also possible to get historical earnings reports for any stock using the same formula. Just specify any dates in the past and you’ll get all the earnings for those dates. For example, in the example below I’ve used =EARNINGS("AAPL","all","1/1/2020","12/15/2023") to obtain AAPL’s complete earnings history from 2020 through the present day. When examining historical earnings, the Reported EPS, Surprise EPS, and Surprise EPS % columns will return data. Examining what happened to a stock’s price after a good or bad earnings report can provide insights into what might happen in the future if you decide to trade an earnings release.
Complete Earnings Documentation
See the complete formula documentation for additional details. Also, if you need earnings data via an API, our earnings endpoint provides all the same data you see here, but via our API.
Earnings Is A Premium Formula
Free or trial users may test out the earnings formula using the AAPL ticker, but if you would like to use the formula in your Google Sheets for other tickers, a Market Data subscription is required. Plans start at just $9 per month.
