No Output for Floating Rate Note Index

Markuss

Hello,

I am trying to get the underlying index of various instruments that are floating rate notes. I'm working with the Python API.

Example CUSIPs I am using are: 3128X9Z86, 31331GW70, 31331GYN3, 31331GYN3

When using get_data(CUSIP_List, fields=["TR.FICouponTypeDescription", (other (working) stuff)]) they all correctly show up as "Floating: Fixed Margin over Index". However, I cannot get the underlying index or the margin over the index. I've tried:

"TR.FLOATINGRATENOTEINDEXVALUE"
"TR.UNDERLYINGINDEX"
"TR.NIFloatingRateIndex"
"TR.DISCOUNTMARGIN"
"TR.DivNotes"
"TR.Notes"
"TR.WarrantNotes"

All these codes gave me no output.

I would be happy with any of the following: (Optimally) the margin over the index, the mere index, the "coupon formula" field or the "notes" field.

Coupon Formula Field:

Notes Field:

Kindly,

Markus

jason.ramchandani01

@Markuss Hi I think there are a number of fields that look promising:

I think TR.FiIndexRIC might be the one you want. Also note the instruments you provided are matured instruments.

Regarding the margin over the index i found these:

I think TR.ADF_MARGIN is the one you want. I hope this can help.

Markuss

https://community.developers.refinitiv.com/discussion/comment/80269#Comment_80269

Thank you very much, Jason! It works!

A question on your screenshots: Is that part of the formula builder or where is it possible to directly see the instrument-specific output?

Best,

Markus

jason.ramchandani01

https://community.developers.refinitiv.com/discussion/comment/80274#Comment_80274

@Markuss So the screenshots are from the Data Item Browser app (type DIB into Eikon search bar) - here you can check all fields by content type and if you include an instrument it even gives you the values - which I find and II think in these cases - you will find useful.

We also have the latest generation Code Creator app (type CODECR into Eikon search bar - this one provides similar functionality but can actually creeate the python code snippet entirely for you. It does not have the values coming through but it has many functions that are quite useful such as PCT_CHANGE which can be included with your fields to get more output types - so you could check those out as well. I hope this can help.

Markuss

https://community.developers.refinitiv.com/discussion/comment/80270#Comment_80270

Thank you again, this is indeed much more useful!