Lockup & Earnout Function (LE)

=spac.LE( type, query, limit, offset, columns )

Returns a table of SPAC lockups and/or earnouts.

Parameters

type

The type to fetch. One of: all, lockup, earnout.

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 lockup/earnout column names to include in the returned table. If not specified, all columns will be returned.

Examples

What are all the lockups on file?

=spac.LE("lockup", "", 100)

What are all the earnouts on file?

=spac.LE("earnout", "", 100)

What are the lockups and earnouts for the SPAC with CIK "0001838814"?

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