ezyquant.reader.SETDataReader.get_change_name#

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

Data from table CHANGE_NAME_SECURITY.

Parameters:

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

  • start_date (Optional[str] = None) – start of effect_date (D_EFFECT).

  • end_date (Optional[str] = None) – end of effect_date (D_EFFECT).

Returns:

change name dataframe contain columns:

  • symbol_id: int - I_SECURITY

  • symbol: str - SECURITY.N_SECURITY

  • effect_date: date - D_EFFECT

  • symbol_old: str - N_SECURITY_OLD

  • symbol_new: str - N_SECURITY_NEW

Return type:

pd.DataFrame

Examples

>>> from ezyquant import SETDataReader
>>> sdr = SETDataReader()
>>> sdr.get_change_name(["SMG"])
   symbol_id symbol effect_date symbol_old symbol_new
0        220    SMG  2006-07-31        SMG      SCSMG
1        220    SMG  2014-08-28      SCSMG        SMG
>>> sdr.get_change_name(start_date="2014-08-28", end_date="2014-08-29")
   symbol_id    symbol effect_date  symbol_old symbol_new
0        220       SMG  2014-08-28       SCSMG        SMG
1        221     SMG-F  2014-08-28     SCSMG-F      SMG-F
2        222     SMG-R  2014-08-28     SCSMG-R      SMG-R
3       2793    SMG-W1  2014-08-28    SCSMG-W1     SMG-W1
4       2794    SMG-WB  2014-08-28    SCSMG-WB     SMG-WB
5       3375  SMG-W1-R  2014-08-28  SCSMG-W1-R   SMG-W1-R