History Function (HIST)

=spac.HIST( asOfDate, query, limit, offset, columns )

Returns the SPAC universe exactly as it stood on a single past date — a point-in-time snapshot. It returns the same columns as the live universe, as of the date you supply.

Parameters

asOfDate

The snapshot date (YYYY-MM-DD). Must be a past date, not today or a future date.

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. Capped at the server maximum.

offset

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

columns

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

Examples

What did the SPAC universe look like on June 1, 2024?

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

Which SPACs were searching as of June 1, 2024?

=spac.HIST("2024-06-01", "status = 'SEARCHING'", 100)

What were the name and status of each SPAC as of June 1, 2024?

=spac.HIST("2024-06-01", "", 50, 0, "name", "status")