Hello guys,
I’m trying to download all the Green Bonds listed in BGN in Bloomberg, once I have them all I should use BCHAIN() to download all the bonds issued by the same issuers of the green bonds with the same rating, bond structure, currency, seniority, collateral and coupon type. For each of green and normal bond I need maturity and issuing date and issued amount. Then when I have both green and conventional bond I should download using BDH the yield to maturity, the dailing closing prices bid and ASK. In order to do that faster I world like to use VBA in Excel. Can you Yelp me?
Thank you,
Daniele