Corporate Actions Function (CA)

=spac.CA( actionType, query, limit, offset, columns )

Returns a table of SPAC corporate actions for a given action type.

Parameters

actionType

The action type to fetch. One of: all, completion-vote, early-liquidation-vote, liquidation, extension-vote, other-actions, record-date, tender-offer, tender-offer-to-complete.

query

A string representing the query of the request, using the same syntax as the DT function. Defaults to blank if not specified.

limit

The maximum number of rows to return. Defaults to 10 if not specified.

offset

The number of rows to skip before beginning to return rows. Defaults to 0 if not specified.

columns

A list of corporate-action column names to include in the returned table. If not specified, all columns will be returned.

Examples

What extension votes are on file?

=spac.CA("extension-vote", "", 100)

What are all the corporate actions for the SPAC with CIK "0001838814"?

=spac.CA("all", "cik = '0001838814'")

List the CIK and action date of the 50 most recent tender offers.

=spac.CA("tender-offer", "", 50, 0, "cik", "action_date")