Hello, I am trying to get green bonds data from 2013 to 2023 using Eikon through Advanced search. How can I add a column for whether the issuer is public or private, the ISIN (it gives me the ISIN of the bond only) and the credit rating?
I want to keep only the public firms. It gives me only the ticker but I want the ISIN in order to examine the stock market reaction to the announcement and to collect financial and environmental data for each firm. Also, I only find the PBOC Bond Rating and not the credit ratings (S&P, Moody’s, Fitch).
Thank you in advance!