A conceptual image with a Microsoft Excel theme, representing stock earnings, featuring the title 'EARNINGS' prominently in the center. The image includes visual elements like Excel spreadsheets, pie charts, bar graphs, and financial data. The background mimics the classic green and white color scheme of Excel, emphasizing the use of spreadsheets in financial analysis. This image conveys the practical and analytical aspects of handling stock earnings in Excel.

How To Get An Earnings Calendar For Any Stock In Google Sheets

Add an earnings calendar to Google Sheets using Market Data's EARNINGS formula. Find what Wall Street Analysts are projecting for next quarter.

December 14, 2023
    Add a header to begin generating the table of contents

    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.

    earnings formula example

    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 Examples

    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. The first parameter is used for the ticker. The second parameter allows for filtering the columns that are output or to rearranging the order of the columns. The third and fourth parameters are used for the start date and end date.

    • =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.

    historical use of the earnings formula

    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.

    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.

    Share This Tutorial

    Comments & Questions