New posts are disabled while we improve the user experience.

You can browse the site, or for urgent issues, raise a query at MyAccount.

question

Upvotes
Accepted
3 0 0 3

Get list of constituents of an issuer curve

Hi,

Does anyone know how I can get a list of constituents of an issuer curve like '0#DEAAAEURAGEBMK='?

In the Data Item Browser, I can only find "TR.IndexJLConstituentsName", which shows the last constituents that joined or left. Is there a way to obtain the full list of constituents?

Thanks.

eikoneikon-data-api#technology#contentconstituentscurves
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.

Upvotes
Accepted
7.5k 18 2 8

Hi @Michael.Medvedovski ,


Here is the equivalent code in RD:

import refinitiv.data as rd
from refinitiv.data.discovery import Chain
rd.open_session()
chain_rics = Chain(name="0#DEAAAEURAGENCY").constituents
rd.get_data(chain_rics, ['OFFCL_CODE','DSPLY_NAME','COUPN_RATE','MATUR_DATE','CF_BID','CF_ASK','RT_YIELD_1'])


screenshot-2023-12-13-at-095943.png


Best regards,

Haykaz


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.

Upvotes
15.6k 33 5 10

Hi @Michael.Medvedovski ,

Is this what you're looking for?

import refinitiv.data.eikon as ek

ek.set_app_key('DEFAULT_CODE_BOOK_APP_KEY')

df, err = ek.get_data(['0#DEAAAEURAGEBMK='], [ 'DSPLY_NAME'])
df

1700639681883.png

However, I'd like to introduce the newer RD Library the provides a simplified Chain interface as below.

import refinitiv.data as rd
from refinitiv.data.discovery import Chain

rd.open_session()

c = Chain(name="0#DEAAAEURAGEBMK=")
print(c.constituents)

1700640314158.png

You should have an access to the RD Library - desktop session if you are currently having an access to Eikon Data API, more detail can be found in the quick start guide

To learn more about chain object, feel free to check this article


1700639681883.png (44.7 KiB)
1700640314158.png (20.0 KiB)
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.

Upvotes
3 0 0 3

Thank you very much @raksina.samasiri for your quick response.

However, what I actually meant was that I want to generate a list of the constituents (especially their ISINs), which are the bonds that were used to construct this issuer curve. I hope you are able to help me.

Bonds in the section "bond constituents":

1700643937991.png

Thank you!


1700643937991.png (72.9 KiB)
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.

Upvote
15.6k 33 5 10

Hi @Michael.Medvedovski ,

Thank you for an information, is this what you're looking for

df, e = ek.get_data(['0#DEAAAEURAGENCY'],['OFFCL_CODE','DSPLY_NAME','COUPN_RATE','MATUR_DATE','CF_BID','CF_ASK','RT_YIELD_1'])
df

1701422591168.png


1701422591168.png (43.6 KiB)
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.

Upvotes
3 0 0 3

Thanks. Though this seems to work via eikon only currently. Does the refinitiv data library have that option as well?

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.

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.