discrepancy between RDP API vs Excel RSearch for corporate bonds

Hi,
I am doing a RSearch in Excel for Commerzbank Bonds using
IssuerOrgid = '10436'
in the filter. This returns 7 bonds ( I have some additional filters. Not important here) and I see '"Organization PermID" = '8589934314 in the data retrieved.
I am trying the same search using what is shown below (Python in IntelliJ) but get nothing returned (status of both searches is "OK").
Am I missing something?
Also, in some other similar searches for Corp Bonds I get a empty MaturityDate field. What is the condition to include in the filter to exclude the rows with no values in that field? (would be nice to know all available functions such as "endswith" etc to use in the Filter. Is there a listing somewhere?)
Many thanks in advance
import refinitiv.dataplatform as rdp
rdp_session = rdp.open_desktop_session("-------------")
sOrgPermID = '8589934314'
srchfields = "RIC,ISIN, FullName, CommonName,CompanyName, IssuerLegalName,IssuerOAPermID, IssuerCommonName,IssuerShortName, IssuerOrganization, IssuerOrgid, ParentOAPermID,ParentIssuerName, ParentIssuerID, Currency, MaturityDate "
filterStrLoop1 = " ((DerivedCategory eq 'BOND') or (DerivedCategory eq 'Note')) and ParentOAPermID eq '{0}' and IsActive eq true " \
" and AssetStatus ne 'MAT' and RIC ne null and ISIN ne null ".format(sOrgPermID)
respOrgPermId = rdp.Search.search(view=rdp.SearchViews.GovCorpInstruments, filter=filterStrLoop1, top=GroupSize, select=srchfields)
respOrgPermId.status
respOrgPermId.data.raw.shape
# This one returns values for RSearch in Excel, using IssuerOrgid = '10436' :
sOrgId = '10436'
filterStrLoopOrgId = " ((DerivedCategory eq 'BOND') or (DerivedCategory eq 'Note')) and IssuerOrgid eq '{0}' and IsActive eq true " \
" and AssetStatus ne 'MAT' and RIC ne null and ISIN ne null ".format(sOrgId)
respOrgId = rdp.Search.search(view=rdp.SearchViews.GovCorpInstruments, filter=filterStrLoopOrgId, top=GroupSize, select=srchfields)
respOrgId.status
respOrgId.data.raw.shape
Best Answer
-
I tried all the searches you have above and getting back a lot of results. So, let's break this down. What I noticed was this:
respOrgPermId.statusrespOrgPermId.data.raw.shape
The 'raw' data component is a json object, not a dataframe. Did you try this:
respOrgPermId.statusrespOrgPermId.data.df.shape
Here is a screenshot of what my results look like when I change the above and also print out the results:
0
Answers
-
As a complement to what I wrote, just checked that following RICs (all Commerzbank; I get them via RSearch in Excel) do return values when using ek.get_data()
lstRICs = ['DECZ40KK=', 'DECZ40KK=','DECZ40NB=','DECZ40LM=','CH42327930=','CH2609656=','DECZ40LQ=','DECZ40MB=']
Thanks.
0 -
Hi nick.zincone.1 ,
oh yes. Many thanks for your reply.
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
- 690 Datastream
- 1.4K DSS
- 629 Eikon COM
- 5.2K Eikon Data APIs
- 11 Electronic Trading
- 1 Generic FIX
- 7 Local Bank Node API
- 3 Trading API
- 2.9K Elektron
- 1.4K EMA
- 255 ETA
- 559 WebSocket API
- 39 FX Venues
- 15 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 25 Messenger Bot
- 3 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 60 Open Calais
- 279 Open PermID
- 45 Entity Search
- 2 Org ID
- 1 PAM
- PAM - Logging
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 23 RDMS
- 2K Refinitiv Data Platform
- 716 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
- 106 UPA
- 194 TREP Infrastructure
- 229 TRKD
- 918 TRTH
- 5 Velocity Analytics
- 9 Wealth Management Web Services
- 95 Workspace SDK
- 11 Element Framework
- 5 Grid
- 19 World-Check Data File
- 1 Yield Book Analytics
- 48 中文论坛