question

Upvotes
Accepted
1 1 1 3

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

eikoneikon-com-apidatastream-apiDownload
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

1 Answer

Upvote
Accepted
4.6k 26 7 22

@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

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Thank you very much! I will do that.

Click below to post an Idea Post Idea