Download Data from Datastream

roman_pfenninger

Hello Guys

I need some help for a thesis I write. Unfortunately I do not know a way to download a list of all contingent convertible (CoCo) bonds that are currently traded.

I tried downloading all contingent bonds with a trigger - however, there is not such a flied available - at least as far as I know.

Is it possible to do that - and if so - how can I do that?

Thank you very much and best regards

Roman

Zhenya Kovalyov

@roman_pfenninger, not sure how to retrieve this data from DataStream. I guess you could contact the customer support for more information.

If, in addition to DataStream, you have Thomson Reuters Eikon for Office, you can paste the following function in to the Excel for the list of CoCos:

=RSearch("BOND",{"RCSConvertibleGenealogy","'A:H1';'A:L9'"},"NBROWS:2000")

Same request can be done through Eikon COM SDK with the RSearch API

roman_pfenninger

https://community.developers.refinitiv.com/discussion/comment/9404#Comment_9404

Thank you very much! I will do that.