Refinitiv Data Platform News — Middle Office Compliance Use Cases
See Zoya Farberov’s full article on the Developer Portal.
How could you pass along a large list of identifiers (CUSIP, ISIN and or SEDOLs) and retrieve a company PermID, OrgName and status as an API response or as a bulk file? Well, with this method!
There are serval possible approaches, including RDP API, to implement this Refinitiv Data Platform (RDP) News use case.
As we would like to showcase an approach in Python, and as ease of use is one of our primary considerations, the selected integration approach takes advantage of Refinitiv Data Library for Python- a brand-new, light, ease-of-use RDP integration offering, currently in pre-release.
Refinitiv Data Library for Python is documented on developer portal (see References section) and is positioned as a Refinitiv-supported member for Refinitiv Data Libraries family, its sister libraries being Refinitiv Data Library for .NET, and Refinitiv Data Library for TypeScript that is being prepared.
We are going to use Desktop session.
The Two Examples
- Data Library — Symbol Conversion via Search
- Data Library — Endpoint using Symbology
The reason we wish to show both approaches is that RD Library Symbol Conversion requires the RDP user to have permissions to RDP Search service. Whereas RDP Library Endpoint access only requires RDP user to have permissions to the specific endpoint in use, in this case RDP Symbology endpoint.
Data Library — Symbol Conversion via Search
- Import Refinitiv Data Library
- Open RDP Session (Workspace)
- Setup short default list with 3 IDs
- Read working list with 2k+ IDs ( SEDOLS)
- Convert the short list of symbols to PermIDs using Symbol Conversion
- Request organization’s common name and status
- Convert 2K list to PermIDs using Symbol Conversion
- Chunk the required list- define a helper function
- Run chunked request and produce single result
References section links to the complete example code on GitHub. In the next discussion we are going to focus on the specifics aspects of conversion and lookup using RD Library.
Data Library — Endpoint Using Symbology
- Import Refinitiv Data Library
- Define a helper function listToChunks
- Open RDP Session ( Workspace)
- Setup short default list with 3 IDs
- Read working list with 2k+ IDs ( SEDOLS)
- Define Symbology Lookup Request Body Skeleton
- Request lookup of the short list of symbols to PermIDs using Endpoint
- Requests Lookup for Longer List of IDs using Endpoint (chunk)
- Request organization’s common name and status of the short list
- Request organization’s common name and status of the short list (chunk)
References section links to the complete example code on GitHub. In the next discussion we are going to focus on the specifics aspects of conversion and lookup using RD Library.
To see the whole method, see Zoya Farberov’s full article on the Developer Portal.
References
- The complete source code for the use case is available on GitHub: Refinitiv-API-Samples/Example.RDP.Python.RDPNewsMiddleOfficeComplianceUseCases (github.com)
- Quickstart Python example is available on Refinitiv developers portal: https://developers.refinitiv.com/en/api-catalog/refinitiv-data-platform/refinitiv-data-platform-apis/download
- Refinitiv developers forums — RDP section:
