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)")
1
●0 ●0 ●0
How to pull Top 400 AUM companies on CODEBK?
87.1k
●294 ●53 ●79
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
