ezyquant.reader.SETDataReader.get_delisted

SETDataReader.get_delisted(symbol_list: List[str] | None = None, start_date: str | None = None, end_date: str | None = None) → DataFrame

Data from table SECURITY_DETAIL. Filter delisted by D_DELISTED != None.

Parameters:

• symbol_list (Optional[List[str]] = None) – N_SECURITY in symbol_list (must be unique).

• start_date (Optional[str] = None) – start of delisted_date (D_DELISTED).

• end_date (Optional[str] = None) – end of delisted_date (D_DELISTED).

Returns:

delisted dataframe contain columns:

• symbol: str - SECURITY.N_SECURITY

• delisted_date: date - D_DELISTED

Return type:

pd.DataFrame

Examples

>>> from ezyquant import SETDataReader
>>> sdr = SETDataReader()
>>> sdr.get_delisted(start_date="2020-02-20", end_date="2020-02-20")
     symbol delisted_date
0    ROBINS    2020-02-20
1    KK202A    2020-02-20
2  CB20220A    2020-02-20
3  CB20220B    2020-02-20