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
-
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
1 -
@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.
1 -
Thank you again, this is indeed much more useful!
0
Categories
- All Categories
- 6 AHS
- 39 Alpha
- 161 App Studio
- 4 Block Chain
- 4 Bot Platform
- 16 Connected Risk APIs
- 47 Data Fusion
- 30 Data Model Discovery
- 608 Datastream
- 1.3K DSS
- 577 Eikon COM
- 4.9K Eikon Data APIs
- 7 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- Trading API
- 2.7K Elektron
- 1.3K EMA
- 236 ETA
- 519 WebSocket API
- 33 FX Venues
- 10 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 20 Messenger Bot
- 2 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 59 Open Calais
- 264 Open PermID
- 39 Entity Search
- 2 Org ID
- PAM
- PAM - Logging
- 8.4K Private Comments
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 20 RDMS
- 1.4K Refinitiv Data Platform
- 367 Refinitiv Data Platform Libraries
- 3 Refinitiv Due Diligence
- LSEG Due Diligence Portal API
- 3 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.1K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 10 World-Check Customer Risk Screener
- 990 World-Check One
- 44 World-Check One Zero Footprint
- 45 Side by Side Integration API
- Test Space
- 3 Thomson One Smart
- 1.2K TR Internal
- Global Hackathon 2015
- 2 Specialists Who Code
- 10 TR Knowledge Graph
- 150 Transactions
- 142 REDI API
- 1.7K TREP APIs
- 4 CAT
- 21 DACS Station
- 117 Open DACS
- 1.1K RFA
- 103 UPA
- 172 TREP Infrastructure
- 224 TRKD
- 886 TRTH
- 5 Velocity Analytics
- 5 Wealth Management Web Services
- 60 Workspace SDK
- 9 Element Framework
- 5 Grid
- 13 World-Check Data File
- Yield Book Analytics
- 46 中文论坛