Dataseries Horizontal Function (DS.H)

=spac.DS.H( searchTerm, searchType, columnNames )

Select a series of data points from a single SPAC horizontally. This function takes a search term (CIK , Symbol , or Name ) and a list of column names to retrieve the specified data points for the SPAC. The function returns a dynamic array of data values.

The row represents the specified SPAC, and each column represents a different column name specified in the columnNames parameter.

Parameters

searchTerm

A string representing the search term used to find the SPAC. This can be a CIK (Central Index Key), symbol, or name.

searchType

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

columnNames

a series of strings representing the column names of the data points that the user wants to retrieve. See "help" for a list of columns.

Examples

What’s the name, status, and industry of the SPAC with the CIK: "0001433309"?

=spac.DS.H("0001433309", "cik", "name", "status", “industry”)

What is the IPO date, announced date, and closing date of the SPAC with the share symbol "CAZA"?

=spac.DS.H("CAZA", "symbol", "ipo_date", "announced_date", “closing_date”)

What is the share symbol and share close price of the SPAC "JWC ACQUISITION CORP"?

=spac.DS.H("JWC ACQUISITION CORP", "name", "share_symbol", "share_close_price")