Not getting info from TR.IssuerRating
Hi, I am using the following code:
CORP_COLOMB_US = ['ES122321657=','CO080166524=','CO089109256=','CO141154222=','CO165899431=','CO081101035=' ]
ts2,e2 = ek.get_data(CORP_COLOMB_US,
["TR.BENCHMARKSPREAD.date","TR.BENCHMARKSPREAD","TR.ASSETSWAPSPREAD","TR.MODIFIEDDURATION"],
{'SDate':start_date,'EDate':end_date,'Frq':'D'})
This works fine. However, when I add the field TR.IssuerRating it doesn't work anymore. I looked in the Data Item Browser and the field is supposed to work with historic information as is shown in the picture below.
How should I correct the code in order to get that information?
Thanks!
Best Answer
-
Hi @andrgome
I think you can try this code:
start_date = "2015-12-31"
end_date = "2021-03-15"
RICs= ['195325BN4=','USP3772NHK11=','195325BQ7=','CO018437384=','195325CX1=','CO007401060=',
'195325DL6=','CO010878659=','195325DP7=','195325DR3=','195325DS1=','CO016187933=',
'CO026779405=','195325BM6=','195325BR5=','195325CU7=','195325DQ5=','195325DT9=','195325DX0='] #YANKEES COLOMBIA
fields3 = ["TR.IssuerRating","TR.IR.RatingDate"]
ts1,e1 = ek.get_data(RICs,fields3,{'SDate':start_date,'EDate':end_date,'Frq':'D'})
ts2 = ts1.loc[ts1['Date'] != '']
ts20
Answers
-
Hi @andrgome
I believe that the start_date and end_date that you input to the API call, does not include the date the issuer rating is calculated.
For example, if the date include 8th April 2020, you would get the result.
0 -
Hi,
Thanks for your answer. I tried to do what you explained but it didn't work.
Look the code that I wrote.
start_date = "2019-12-31"
end_date = "2021-03-15"
RICs= ['195325BN4=','USP3772NHK11=','195325BQ7=','CO018437384=','195325CX1=','CO007401060=',
'195325DL6=','CO010878659=','195325DP7=','195325DR3=','195325DS1=','CO016187933=',
'CO026779405','195325BM6=','195325BR5=','195325CU7=','195325DQ5=','195325DT9=','195325DX0='] #YANKEES COLOMBIA
fields3 = ["TR.IssuerRating","TR.IR.RatingDate"]
ts1,e1 = ek.get_data(RICs,fields3,{'SDate':start_date,'EDate':end_date,'Frq':'D'})
ts1
I got an empty dataframe. What should I do?
Thanks!
0 -
Hi @andrgome
I am not a content expert but I believe that it does not make sense to query Issuer Rating with a start date and end date.
Please try this code: (note that CO026779405 should be CO026779405=)
RICs= ['195325BN4=','USP3772NHK11=','195325BQ7=','CO018437384=','195325CX1=','CO007401060=',
'195325DL6=','CO010878659=','195325DP7=','195325DR3=','195325DS1=','CO016187933=',
'CO026779405=','195325BM6=','195325BR5=','195325CU7=','195325DQ5=','195325DT9=','195325DX0='] #YANKEES COLOMBIA
fields3 = ["TR.IssuerRating","TR.IR.RatingDate"]
ts1,e1 = ek.get_data(RICs,fields3)
ts10 -
Hi,
Thanks for your answer. Indeed, when I used the formula without start and end date it works. However I woul like to have it for a time series because I would like to see when an issuer is downgraded or upgraded and the different rating levels.
Thanks anyway for taking a look.
0 -
Thanks! this helps!
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
- 59 Workspace SDK
- 9 Element Framework
- 5 Grid
- 13 World-Check Data File
- Yield Book Analytics
- 46 中文论坛