Eikon API has inconsistent output for bond OAS

I am currently using Eikon to save bond OAS data regularly by first querying rdp / govsrch to get a list of bonds and then using eikon's get_data() to pull OAS for these bonds. I've noticed that the number of returns from this query varies greatly, sometimes I get 7k valid returns for the OAS data and sometimes I get 14k. Is there a reason for getting such varied amounts of valid results and is there any predictability to this?
My code is essentially a loop of
data, err = ek.get_data(universe,'TR.OPTIONADJUSTEDSPREADBID',{'SDate':OAS_date})
in which 'universe' is a list of bond RICs and the returned 'data' variable gets added to a dataframe. I pull this data 1000 at a time to avoid data limits so this shouldn't be an issue here.
Any help would be greatly appreciated.
Best Answer
-
Hi @alex.sullivan ,
Thank you for your patience. I've tried with some date and rate but cannot reproduce the issue.
Could you please let me know if the issue is still persist?
If so, it'd be nice if you could provide the value of parameters date and rating that cause this issue for further investigation.
0
Answers
-
@alex.sullivan can you please paste the rdp search query - thanks very much
0 -
@jason.ramchandani01 the rdp search query is listed below, however the rdp search query isn't the issue as it returns a consistent number of bonds. The issue is that given this list of bonds, the ek get_data query has inconsistent behavior.
rdp.search(
view = rdp.SearchViews.GovCorpInstruments,
top = 10000,
filter = "( (RCSCouponCurrencyLeaf xeq 'US Dollar' and RCSCurrencyLeaf eq 'US Dollar') and ((InstrumentTypeDescription xeq 'Note' or \
InstrumentTypeDescription xeq 'Bond' or InstrumentTypeDescription xeq 'Debenture')) and (SeniorityType in ('SR' 'UN')) and \
(RCSCouponTypeGenealogy eq 'M:1EU\A:C1') and DbType eq 'CORP' and RCSAssetCategory eq 'A:J' and (RCSBondGradeLeaf eq \
'Investment Grade' or RCSBondGradeLeaf eq 'High Yield') and DebtType ne 'SYKHYB' and DebtType ne 'SUK*' and IsConvertible\
eq false and IssueDate le "+date+" and MaturityDate gt "+date+" and CouponFrequencyDescription xeq 'Semiannually' and \
FaceOutstanding gt 0 and ((RatingsScope(RatingType eq 'MDY' and CurrentRatingRank ge "+rating+" and CurrentRatingRank le "+rating+"))))",
select = "DBSTicker, RCSAssetCategory,RIC, EJVAssetID, DTSubjectName, BusinessEntity,SeniorityTypeDescription, PI, CUSIP, ISIN, RCSCurrencyLeaf, RCSCountryLeaf, \
CouponRate, MaturityDate, IssueDate, InstrumentTypeDescription,RCSCouponTypeGenealogy,FaceIssuedUSD,RCSBondGradeLeaf,CouponFrequencyDescription,\
FaceOutstanding,RCSCouponCurrencyLeaf,RCSTRBC2012Leaf,RatingsScope(filter:((RatingType xeq 'MDY'))),RatingX1XRatingRank,IndustrySubSectorDescription"
)note that in this code, 'date' and 'rating' are variables which are iterated through to avoid query limits.
0
Categories
- All Categories
- 6 AHS
- 36 Alpha
- 166 App Studio
- 6 Block Chain
- 4 Bot Platform
- 18 Connected Risk APIs
- 47 Data Fusion
- 34 Data Model Discovery
- 683 Datastream
- 1.4K DSS
- 613 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
- 248 ETA
- 552 WebSocket API
- 37 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
- 626 Refinitiv Data Platform Libraries
- 5 LSEG Due Diligence
- 1 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
- 26 DACS Station
- 121 Open DACS
- 1.1K RFA
- 104 UPA
- 191 TREP Infrastructure
- 228 TRKD
- 915 TRTH
- 5 Velocity Analytics
- 9 Wealth Management Web Services
- 84 Workspace SDK
- 11 Element Framework
- 5 Grid
- 18 World-Check Data File
- 1 Yield Book Analytics
- 46 中文论坛