No Output for Floating Rate Note Index

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
Best Answer
-
@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.
0
Answers
-
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
0 -
@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.
0 -
Thank you again, this is indeed much more useful!
0
Categories
- All Categories
- 3 Polls
- 6 AHS
- 36 Alpha
- 166 App Studio
- 6 Block Chain
- 4 Bot Platform
- 18 Connected Risk APIs
- 47 Data Fusion
- 34 Data Model Discovery
- 685 Datastream
- 1.4K DSS
- 615 Eikon COM
- 5.2K Eikon Data APIs
- 10 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- 3 Trading API
- 2.9K Elektron
- 1.4K EMA
- 252 ETA
- 556 WebSocket API
- 38 FX Venues
- 14 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 23 Messenger Bot
- 3 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 60 Open Calais
- 275 Open PermID
- 44 Entity Search
- 2 Org ID
- 1 PAM
- PAM - Logging
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 22 RDMS
- 1.9K Refinitiv Data Platform
- 652 Refinitiv Data Platform Libraries
- 4 LSEG Due Diligence
- LSEG Due Diligence Portal API
- 4 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.2K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 12 World-Check Customer Risk Screener
- 1K World-Check One
- 46 World-Check One Zero Footprint
- 45 Side by Side Integration API
- 2 Test Space
- 3 Thomson One Smart
- 10 TR Knowledge Graph
- 151 Transactions
- 143 REDI API
- 1.8K TREP APIs
- 4 CAT
- 27 DACS Station
- 121 Open DACS
- 1.1K RFA
- 104 UPA
- 193 TREP Infrastructure
- 228 TRKD
- 917 TRTH
- 5 Velocity Analytics
- 9 Wealth Management Web Services
- 90 Workspace SDK
- 11 Element Framework
- 5 Grid
- 18 World-Check Data File
- 1 Yield Book Analytics
- 46 中文论坛