question

Upvotes
Accepted
roman_pfenninger avatar image
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 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Upvote
Accepted
Zhenya Kovalyov avatar image
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 512.0 KiB each and 1.0 MiB total.

roman_pfenninger avatar image roman_pfenninger

Thank you very much! I will do that.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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