How to run a SCREENER formula in Excel to CODEBOOK?

MartyS

What is wrong with this screening code?

df, err = ek.get_data('SCREEN(U(IN(Equity(active,public))/UNV:Public/), IN(TR.InstrumentTypeCode,"ADR","BDR"), IN(TR.ExchangeMarketIdCode,"BVMF","XBSP")',[' TR.PrimaryRICCode,TR.CommonName,TR.CompanyMarketCapitalization,TR.TRBCEconomicSector,TR.TRBCBusinessSector,TR.TRBCIndustry,TR.TRBCIndustryGroup,TR.InstrumentType'])

the excel original formula is:
=@TR("SCREEN(U(IN(Equity(active,public))/UNV:Public/), IN(TR.InstrumentTypeCode,""ADR"",""BDR""), IN(TR.ExchangeMarketIdCode,""BVMF"",""XBSP""), CURN=USD)";"TR.CommonName;TR.InstrumentType;TR.ExchangeName;TR.PrimaryRICCode;TR.HeadquartersC"&"ountry";"curn=USD RH=In CH=Fd")

Jirapongse

@MartyS

Thank you for reaching out to us.

Please check the answer on this discussion.