Splits Calendar

Use the SF_CALENDAR() function with type="splits" to retrieve historic and upcoming stock split data. The function returns rows for each split within the requested date range and the metrics you select.

=SF_CALENDAR(searchTerms, "splits", startDate, endDate, metrics, options)

The maximum date range for a single call is 90 days. If the range between startDate and endDate is larger, it is truncated to 90 days. For longer ranges, make multiple calls and combine them with HSTACK or VSTACK.

Available metrics

Chain metrics together with & or use "all" to return every column.

Date ("date")
Symbol ("symbol")
Numerator ("numerator")
Denominator ("denominator")
Ratio ("ratio")

Examples

Filter by multiple exchanges

Return all splits on the ASX and NSE over the last 90 days.

=SF_CALENDAR(".AX&.NS", "splits", TODAY()-90, TODAY(), "all")

Filter by exact symbol

Use the $ exact-match operator to return split data for a single ticker.

=SF_CALENDAR("$AAPL", "splits", TODAY()-90, TODAY(), "date&ratio")

For full syntax details, including searchTerms filtering and the options parameter, see the Financial Calendars overview.

Was this helpful?