Stock split history

A stock split history returns every split a company has recorded, including the split date, the share relationship, and the resulting ratio. Use the SF_TIMESERIES() function with the period argument set to "splits". Stock split history is available in both Google Sheets and Microsoft Excel, and from the Basic plan upward.

=SF_TIMESERIES(symbol, startDate, endDate, period, metrics, options)

symbol is the stock or coin ticker symbol, either as a cell reference or a string (e.g. "AAPL").
startDate and endDate filter the split history and are written in YYYY-MM-DD format. Omit both to return the company's full available split history, or supply either date independently to filter the results.
period set this argument to "splits" to return stock split history.
metrics selects which split data to return. Leave it blank or use "all" to return every split metric.
options formats the output. Use "-" for descending order and "NH" for no header.

The results are returned as a two-dimensional time-series table, with one row per split.

Available metrics

The split metrics are returned in this default order:

Metric	Description
`date`	Effective date of the split
`numerator`	Number of new shares in the stated split relationship
`denominator`	Number of old shares in the stated split relationship
`splitRatio`	Numeric value calculated as numerator divided by denominator
`splitType`	Classification of the split

How splitRatio works

splitRatio is the number of new shares you receive per old share. It is calculated as numerator / denominator.

A 4-for-1 split has numerator 4, denominator 1, and a splitRatio of 4.
A 1-for-10 reverse split has numerator 1, denominator 10, and a splitRatio of 0.1.

Examples

Full available history with all metrics

Return every split on record with all metrics:

=SF_TIMESERIES("AAPL","","","splits","all","")

Full history with selected metrics

Return only the date and split ratio:

=SF_TIMESERIES("AAPL","","","splits","date&splitRatio","")

Date-filtered split history

Filter the history to a date range and select the metrics you need:

=SF_TIMESERIES("AAPL","2010-01-01","2025-12-31","splits","date&numerator&denominator&splitRatio","")

No headers

Remove the header row with the "NH" option:

=SF_TIMESERIES("AAPL","","","splits","all","NH")

Selecting metrics and formatting output

Chain metrics together with the & character to return only the columns you need, for example "date&splitRatio". Leaving metrics blank or setting it to "all" returns every split metric.

The existing SF_TIMESERIES formatting options remain available, including "NH" for no header and "-" for descending order. Dates should use YYYY-MM-DD format.

When no splits exist within the requested range, the output is empty or returns the standard no-data message.

For the general SF_TIMESERIES() signature, parameters, and shared behavior, see the Time series guide. For plan availability and pricing, see Pricing and plans. To look up split events across many symbols instead, see Splits Calendar.

Was this helpful?