How to pull Top 400 AUM companies on CODEBK?

TatiannahMarie.Hidalgo

Query: I'm trying to retrieves the top 400 AUM companies via Refinitiv Data Python library. I found an excel formula, but I'm wondering if I can do the same with Python?

=TR("SCREEN(U(IN(equity(active,public,primary))/*UNV:Public*/), TOP(TR.AssetsUnderManagement(Period=FY0) , 400, nnumber), CURN=USD)","TR.CommonName;TR.AssetsUnderManagement(Period=FY0)","Scale=6 curn=USD RH=In CH=Fd SORTD=TR.AssetsUnderManagement(P"&"eriod=FY0)")

Jirapongse

@TatiannahMarie.Hidalgo

Thank you for reaching out to us.

You can use the screener with the ld.get_data or rd.get_data method.

syntax = "SCREEN(U(IN(equity(active,public,primary))), TOP(TR.AssetsUnderManagement(Period=FY0) , 400, nnumber), CURN=USD)"
fields = ['TR.CommonName','TR.AssetsUnderManagement(Period=FY0)']
parameters = {'Scale':6, 'curn':'USD','SORTD':'TR.AssetsUnderManagement(Period=FY0)'}
df = ld.get_data(
    universe = syntax, 
    fields =fields,
    parameters = parameters)
df