Datapoint Function (DP)

=spac.DP( searchTerm, searchType, columnName )

Select a single data point from a single SPAC by providing a search term, search type, and column name.

Enter the search term, search type, and column name as arguments in the function call. The function will return the unformatted data point for that column of the SPAC if found.

Parameters

searchTerm

A string representing the search term used to find the SPAC. This can be a CIK (Central Index Key), symbol, name, or CUSIP (Committee on Uniform Securities Identification Procedures).

searchType

A string representing the type of search term being used. This can be one of three values: "cik" for CIK, "symbol" for symbol, or "name" for name.

columnName

A string representing the column name of the data point that the user wants to retrieve. See "help" for a list of columns.

Examples

What’s the status of the SPAC with the CIK: "0001433309"?

=spac.DP("0001433309", "cik", "status")

What is the industry of the SPAC with the share symbol "CAZA"?

=spac.DP("CAZA", "symbol", "industry")

What is the IPO date of the SPAC "JWC ACQUISITION CORP"?

=spac.DP("JWC ACQUISITION CORP", "name", "ipo_date")