Retrieve the constituents of a yield curve using Eikon Data API (Python)

Question

Question by tr105 · Sep 13, 2019 at 11:36 AM · python eikon constituents data api

Retrieve the constituents of a yield curve using Eikon Data API (Python)

Hi,

I want to retrieve a list of RICs of the bonds that make up the 0#BUSDNFIBMK= yield curve.

In Excel, we do this using (roughly):

TR("0#BUSDNFIBMK=";"";"CH=Fd RH=IN";B8)

We have tried retrieving all constituent-related fields for this instrument using get_data, but this didn't work as the fields did not exist on this instrument. We expected this, as these entries are empty in the Data Item catalog...

Can you suggest an alternative approach? How does the Excel API retrieve the list of constituents?

Thanks in advance!

0

10 |1500 characters needed characters left characters exceeded

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

Answer 1 · 2019-09-13T13:41:14Z

REFINITIV

Best Answer

Answer by James.Perkins · Sep 13, 2019 at 01:41 PM

try this:

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

fi.png (43.4 KiB)

0 · Share

10 |1500 characters needed characters left characters exceeded

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

Answer 2 · 2019-09-13T12:21:37Z

REFINITIV

Answer by chavalit.jintamalit · Sep 13, 2019 at 12:21 PM

Hi @tr105

Please try this code:

df,e = ek.get_data('0#BUSDNFIBMK=','DSPLY_NAME')
df

ahs.png (81.1 KiB)

0 · Share

10 |1500 characters needed characters left characters exceeded

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

Answer 3 · 2019-09-13T13:08:18Z

Answer by tr105 · Sep 13, 2019 at 01:08 PM

Hi Chavalit, thanks for your incredibly quick reply!

This makes sense, but i'm not there yet. Maybe I've phrased my question wrong. We we want the actual bonds that this curve is based on. How would I get those?

I'm pretty new to this API and Eikon in general, so be sure to correct me if I've misunderstood something.

E.g. if we have the 0#AEURNFI curve, we want to retrieve a list of bonds like

JP096729901=AMER HONDA FIN

US082395458=CARGILL

DE137669226=DAIMLER

FR0011321926=RTE EDF TRANS SA

0 · Share

10 |1500 characters needed characters left characters exceeded

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

Answer 4 · 2019-09-13T20:42:32Z

Answer by tr105 · Sep 13, 2019 at 08:42 PM

Awesome, this seems to do what we want.

Thank you so much!

1 · Share

10 |1500 characters needed characters left characters exceeded

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

Answer 5 · 2019-12-30T11:28:12Z

Answer by tr105 · Dec 30, 2019 at 11:28 AM

@James.Perkins Would it be possible to get this list of constituents at a specific date? I've tried using EDate and SDate just like in https://community.developers.refinitiv.com/answers/48885/view.html but without success (API returns the same results and seemingly ignores the SDate an EDate parameters).

0 · Share

10 |1500 characters needed characters left characters exceeded

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

Retrieve the constituents of a yield curve using Eikon Data API (Python)

5 Replies

Watch this question

Related Questions