RDP data queries

mauren.pagsuyuin

HI team, Kindy check if we have the below data in RDP. We tried looking, but unable to find:

1. Country of Incorporation: (i.e 0700.HK ->Cayman Islands)

In Eikon: Found in Corporate Information

In RKD API: Found in Fundamentals Service > Get General Info/Get Snapshot Reports

In RDP: Not Found

2. Free Float percent and it's historical data: (i.e 0700.HK -> 60.1864233493)

In Eikon: Found in Ownership Tab > Free Float

In RKD API: Found in Fundamentals Service > Get General Info/Get Snapshot Reports

In RDP: Not Found

3. Stock Futures Chain RIC from stock RIC: (i.e INFY.NS ->0#INFY:NS)

In Eikon: Found in Derivatives Tab > All Futures > Stock Futures

In RKD API: Not Found

In RDP: Not Found

4. Sector Index from stock RIC: (i.e 0939.HK ->.HSNF(Hang Seng Finance Index)

In Eikon: Found in Corporate Information > Index Membership

In RKD API: Found in Fundamentals Service > Get General Info/Get Snapshot Reports > Index Membership

In RDP: Not found

5. Security Type: (i.e for 0700.HK, Ordinary Shares)

In Eikon: Found in Search Results

In RKD API: Found in Found in Fundamentals Service > Get General Info/Get Snapshot Reports

In RDP: Not Found

6. SZSE SEHK Connect Eligibility : (i.e SHHK_BS)

In Eikon: Not Found

In RKD API: Not Found

In RDP: Not Found

10. A/H Share conversion (i.e 0939.HK ->601939.SS)

In Eikon: Not Found

In RKD API: Not Found

In RDP: Not Found

11. Index Constituents and Weight % including historical data.

In Eikon: Found in Constituents Tab

In RKD API: Quote Chain > Get Chain components and Get Quote chains

In RDP: Not Found

12. Financial Status Indicator: In Elektron, we support this data on FID8570 for Shanghai SE and Shenzhen SE. (For example, 900907.SS FID8570 will be "S")

In Eikon: Not Found

In RKD API: Not Found

In RDP: Not Found

nick.zincone

Hi @mauren.pagsuyuin,

The examples I provided use the RDP Library for Python, which is an ease-of-use library that provides interfaces to hide the underlying RDP API endpoints. For example, the rdp.search() function above uses the Search API (api.refinitiv.com/discovery/search/v1/).

Within Eikon or Refinitiv Workspace, when you open up CodeBook, you will see an example under the folder: /Examples/02-Refinitiv Data Platform Library/ (1.5.0-Function-Search).

However, I would recommend you review my link to the Search article I provided in the previous answer. Not only does that article provide guidance and usage of the service, but has a link to numerous examples demonstrating the concepts.

nick.zincone

Hi @mauren.pagsuyuin,

For the questions related to retrieving some basic company and property-related data, you can use the Search API. For example, here are a few to get you started:

-Country of Incorporation: i.e 0700.HK ->Cayman Islands

rdp.search(
    filter = "PrimaryRIC xeq '0700.HK' and \
              RCSCountryOfIncorporationLeaf ne null",
    select = "PrimaryRIC,RCSCountryOfIncorporationLeaf"
)

-Stock Futures Chain RIC from stock RIC: i.e INFY.NS ->0#INFY:NS

rdp.search(
    filter = "UnderlyingQuoteRIC eq 'INFY.NS' and \
              IsChain eq true",
)

-Sector Index from stock RIC: i.e 0939.HK ->.HSNF(Hang Seng Finance Index)

rdp.search(

filter = "code eq '0939.HK' and IsMemberOfIndex eq true",

select = "DocumentTitle,MainIndexCommonName"

)

I would suggest you reference the Search Article for tips and tricks as well as many examples showing the different techniques and how to approach search.

For your requests related to retrieving values, you can use the get_data() function defined within Eikon Data API, here is an example for you:

-Free Float percent and it's historical data: i.e 0700.HK -> 60.1864233493

df,err = ek.get_data('0700.HK', ['TR.FreeFloatPct'])
df

Within the Eikon desktop, you can use the Data Item Browser as a tool to help define the fields to extract.

mauren.pagsuyuin

@nick.zincone HI Nick, seems like search in RDP has not been introduced to us yet. What is the endpoint in RDP for it?

-Country of Incorporation: i.e 0700.HK ->Cayman Islands

rdp.search(    filter = "PrimaryRIC xeq '0700.HK' and \              RCSCountryOfIncorporationLeaf ne null",    select = "PrimaryRIC,RCSCountryOfIncorporationLeaf"