# December 2023 Update | Market Data

> Earnings data arrives: a future earnings calendar and historical earnings with estimates, actuals and the surprise, in Google Sheets and the API.

Source: https://www.marketdata.app/changelog/december-2023-update/

---

(image: The Market Data December Update banner: an isometric illustration of a figure presenting a pie chart beside a map pin and a bar chart, beside the words DECEMBER UPDATE)

-   [Changelog](/changelog/)

# December 2023 Update

Earnings data arrives: a future earnings calendar and historical earnings with estimates, actuals and the surprise, in Google Sheets and the API.

-   Last updated January 27, 2024

## EARNINGS DATA IS NOW AVAILABLE!

Ready for earnings season? With Market Data, you can get both a **future earnings calendar** as well as **historical earnings data**. Whether you decide to shun these binary events or trade through them is up to you. Now using the Sheets Add-on or the API, you can get the earnings calendar for any U.S. stock and see when it will be reporting. The data includes the fiscal year & quarter, the earnings release date & time, as well as the Wall Street consensus estimate.

You can also review past earnings releases and see how earnings surprises affected the company’s share price. You’ll have access to the **consensus estimate vs the actual results** and the difference in both dollars per share and percent terms.

## HOW DOES IT WORK

`=EARNINGS("AAPL")` will get you future earnings calendar data in Sheets. `https://api.marketdata.app/v1/stocks/earnings/AAPL/` does the same thing, but in the API. We have a [blog post](/sheets/stocks/earnings-calendar/) explaining how to use the EARNINGS formula in Sheets.

## DIVE DEEPER INTO THE UPDATE

Interested in exploring all the possibilities with this feature? Head over to our [Sheets documentation](/docs/sheets/earnings) or our [API documentation](/docs/api/stocks/earnings/) to get a comprehensive understanding of how to make the most of it. We’ve laid out various examples, formats, and potential use-cases to guide you.

It is important to note that this formula is **our first Premium Endpoint and requires a paid Market Data subscription**. Free accounts and trial accounts can only use the AAPL ticker to test it, but cannot use it with other tickers.

## VIDEO TUTORIAL

[How To Get An Earnings Calendar in Google Sheets Using the EARNINGS Formula](https://youtube.com/watch?v=b1P1c1Bwbfo)

If you have 3 minutes to spare, watch this month’s video tutorial and learn how to get started with the EARNINGS formula and see several use-cases for this new tool.

## We also finished this month:

-   Bug: Fixed an issue with daylight savings time
-   API: Add rate limit headers on all requests, even failed ones.
-   Sheets: Date column now output first on candles, matching GOOGLEFINANCE.