SheetsFinance Docs
Options

Earnings

šŸšØ Important:SF_OPTIONS_PRO() requires an active Options subscription. If you only have access to the standard options dataset, use SF_OPTIONS() instead or upgrade on our Pricing page.

The "earnings"dataType returns three years of quarterly, options-derived earnings history metrics such as the earnings date, realised earnings move, earnings straddle percentage, and earnings effect. This is a good dataset for comparing historical earnings moves to the option market's implied expectations.

For a complete function overview, parameter guide, and dataset map, see Options.

=SF_OPTIONS_PRO(symbol, "earnings", "", "", tradeDate, "", metrics, options)

  • symbol is the underlying ticker symbol, for example "AAPL".

  • dataType must be "earnings".

  • tradeDate is optional and requests a historical earnings snapshot when supplied. Use YYYY-MM-DD format, an Excel date serial or Google Sheets date formatted cell.

  • metrics selects which earnings fields to return. Leave blank or use "all" to output the full dataset. Chain specific fields together with & such as "ernDate&ernMv&ernStraPct&ernEffct". See the full list of available metrics in the Metrics section below.

  • options allows additional output formatting or sorting options. Options can be chained together with &.

Tip: This function will always return the previous 12 earnings events (approximately three years of history) up to the tradeDate if supplied, or up to the current date if tradeDate is omitted.

Parameters

Symbol (symbol)

Use the underlying ticker symbol you want to analyze, for example "AAPL". This function does not accept OCC contract symbols because earnings data is only available at the underlying level.

Data Type (dataType)

Must be set to "earnings".

Trade Date (tradeDate)

tradeDate is the historical moment-in-time date for the earnings dataset when you want to view it as it stood on a previous date. Use YYYY-MM-DD format, an Excel date serial or Google Sheets date formatted cell. If omitted, the function returns the current earnings dataset.

Metrics (metrics)

The available earnings metrics are:

  • All ("all")

  • Ticker ("ticker")

  • Earnings Date ("ernDate")

  • Earnings Move ("ernMv")

  • Straddle % ("ernStraPct")

  • Earnings Effect ("ernEffct")

Options (options)

Use options for output formatting modifiers. Chain multiple options together with &.

Formatting options:

  • "NH" removes the header row.

  • "-" reverses the output order.

Examples

Example 1 - Pull current earnings data for all available earnings with all metrics

=SF_OPTIONS_PRO("AAPL", "earnings")
Options Earnings Example 1

Example 2 - Pull a compact earnings move view

=SF_OPTIONS_PRO("AAPL", "earnings", "", "", "", "", "ernDate&ernMv&ernStraPct&ernEffct")
Options Earnings Example 2

Example 3 - Pull a historical earnings snapshot as of a specific date with all metrics

=SF_OPTIONS_PRO("AAPL", "earnings", "", "", "2025-10-01")
Options Earnings Example 3

Was this helpful?
Was this helpful?