History by CIK Function (HIST.CIK)

=spac.HIST.CIK( cik, asOfDate, startDate, endDate, columns )

Returns the point-in-time history of a single SPAC by CIK. Supply a single as-of date for one snapshot, a start and end date for a window, or no dates for the full timeline (newest first).

Parameters

cik

The CIK of the SPAC.

asOfDate

A single snapshot date (YYYY-MM-DD). Cannot be combined with startDate/endDate. Optional.

startDate

The range start (YYYY-MM-DD, inclusive). Optional.

endDate

The range end (YYYY-MM-DD, inclusive). Optional.

columns

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

Use either a single asOfDate or a startDate/endDate window, not both.

Examples

What was the state of the SPAC with CIK "0001838814" on June 1, 2024?

=spac.HIST.CIK("0001838814", "2024-06-01")

Show the history of CIK "0001838814" between two dates.

=spac.HIST.CIK("0001838814", "", "2024-01-01", "2024-06-30")

Show the full point-in-time timeline for CIK "0001838814".

=spac.HIST.CIK("0001838814")