Skip to content

V3_CORPORATE_ACTION_SPLIT() ​

StandardPro
  • Returns the split events for a symbol with an effective date between the specified dates (inclusive). One row per split event.
  • A 4-for-1 forward split reports before_shares 1, after_shares 4, split_ratio 0.25 and event_code SD. A 1-for-10 reverse split reports before_shares 10, after_shares 1, split_ratio 10 and event_code CONSD.

Example ​

=THETADATA.V3_CORPORATE_ACTION_SPLIT("AAPL", "20140101", "20240101")

Parameters ​

symbolRequired  -

The stock or index symbol, or underlying symbol for options.

Type: string
Behavior: Required.
start_dateRequired  -

The start date (inclusive).

Type: string
Behavior: Required.
end_dateRequired  -

The end date (inclusive).

Type: string
Behavior: Required.

Returns ​

A grid (string[][]) - a header row followed by one row per result. See the REST API reference for the full response schema.