Data Table (DT)

=spac.DT( tableName, query, limit, offset, columns )

Retrieve a dynamic table of results from a defined preset or custom preset.

Parameters

tableName

The name of the preset to request. Valid table names can be found in the "help" section.

query

A string representing the query of the request. See Query Syntax for an explanation of how to use queries. Defaults to BLANK if not specified..

limit

The maximum number of rows to return. Defaults to 2000 if not specified. The limit must be a positive integer.

offset

The number of rows to skip before beginning to return rows. Defaults to 0 if not specified. The offset must be a non-negative integer.

columns

An list of column names to include in the returned table. If not specified, all columns will be returned. See "help" for a list of columns.

Examples

What does the Universe Table currently look like?

=spac.DT("universe", "", 2000)

What are the current yield to maturity values of all SPACs?

=spac.DT("implied-ytm", "", 2000, 0, "ytm_earliest_date", "ytm_latest_date", "ytm_worst_date")

What does the Universe table look like for the 100 most recently filed SPACs?

=spac.DT("universe", "", 100)

What are the SPACs that currently have pending shareholder votes?

=spac.DT("shareholder-votes", "", 500, 0, "name", "share_symbol", "shareholder_vote_date")