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 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 or our API documentation 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
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.