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.
