Can you perform a screener type search in RDP

armandnaude
armandnaude Explorer
in Refinitiv Data Platform

In Eikon data api I can perform the following search:

dfexch,e =ek.get_data('SCREEN(U(IN(Equity(active,public,countryprimaryquote))/*UNV:Public*/), IN(TR.ExchangeMarketIdCode,"XNZE"), IN(TR.InstrumentTypeCode,"CHESS","DRC","FULLPAID","ORD","PARTPAID","STAPLED"))',['TR.RIC','TR.CommonName', 'TR.EXCHANGEMARKETIDCODE','TR.ISPRIMARYINSTRUMENT','TR.ISPRIMARYQUOTE','TR.ISCOUNTRYPRIMARYQUOTE','TR.ISIN','TR.InstrumentType','TR.InstrumentTypeCode', 'TR.TRBCEconomicSector', 'TR.TRBCEconSectorCode'])


The closest I have gotten is:

df = rdp.search(view=rdp.SearchViews.EquityQuotes, filter = "Mic eq 'XNZE'", top = 10000, select ="DocumentTitle , RIC, GicsCode, RCSTRBC2012")

But this is not 1000% correct!

How would I do this in RDP? Also from looking at the EquityQuotes SearchView metadata I can see the following fields:
IsPrimaryIssueRIC, IsPrimaryRIC

But I cannot find anything relating to TR.IsCountryPrimaryQuote - what is the equivalent field or how would I determine this?
By way of example for the RIC ANZ.NZ fro ANZ Bank:

Eikon data api gives - TR.ISPRIMARYINSTRUMENT: True, TR.ISPRIMARYQUOTE: 0, TR.ISCOUNTRYPRIMARYQUOTE: True

RDP gives - IsPrimaryRIC: False, IsPrimaryIssueRIC: False

I assume TR.IsPrimaryQuote maps to IsPriamryIssueRic but what does TR.IsPrimaryInstrument map to as it clearly does not map to IsPrimaryRic? And what is the equivalent or how do you determine TR.IsCountryPrimaryQuote?

Also how do I get TRBC, GICS, ICB, and NAICS sector codes from RDP?


Thank you kindly.

Tagged:

Best Answer

  • Alex Putkov.1
    Alex Putkov.1 ✭✭✭✭✭
    Answer ✓

    @armandnaude

    You're right, RDP Search API does not provide a property that is equivalent to TR.ISCOUNTRYPRIMARYQUOTE in Eikon. And I'm afraid I don't see a way to replicate the search you perform in the Screener in Eikon using RDP Search API.

Answers

Categories