Download Data from Datastream

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

Best Answer

  • @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

Answers