League Table Function (LEAGUE)

=spac.LEAGUE( leagueName, key, start, end, limit, offset )

Returns a SPAC league table. Leagues take a date range or a reporting quarter, inputs the DT function cannot express.

Parameters

leagueName

The league to fetch. One of: ipo, despac, pipe-investor, private-placement, serial-sponsor, 13f.

key

League-specific key: the deal role for "ipo" (e.g. underwriter), the funding type for "private-placement" (optional), or the reporting quarter for "13f" (e.g. 2024Q1). Leave blank when not applicable.

start

The start date of the range (YYYY-MM-DD). Required for every league except 13f.

end

The end date of the range (YYYY-MM-DD). Required for every league except 13f.

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.

Examples

What is the IPO underwriter league table for 2024?

=spac.LEAGUE("ipo", "underwriter", "2024-01-01", "2024-12-31")

What is the DeSPAC participant league table for 2024?

=spac.LEAGUE("despac", "", "2024-01-01", "2024-12-31")

What is the 13F league table for the first quarter of 2024?

=spac.LEAGUE("13f", "2024Q1")