Using Eikon API, I extracted a huge list of Tikers, which contains all green bond issuers before 2023 (n=2370). The following is the command I used.
response=search.Definition( view = rd.discovery.Views.GOV_CORP_INSTRUMENTS, top=8172, filter = "((DbType eq 'GOVT' or DbType eq 'CORP' or DbType eq 'AGNC' or DbType eq 'OMUN' or DbType eq 'OTHR') and (IsGreenBond eq true and IssueDate lt 2023-01-01))", select = "RIC,IsGreenBond,DBSTicker,ISIN" ).get_data() df = response.data.df.sort_values(by='DBSTicker') df=( df .sort_values (['DBSTicker']) .drop_duplicates(['DBSTicker'],keep='first') ) df=df['DBSTicker'] print(df)
I would like to retrieve a list of all bonds issued (2004-2022) by all green bond issuers using the list of Tickers I extracted. Is there any good way without retrieving a bond list of each issuer one by one.