How to pull Top 400 AUM companies on CODEBK?

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)")

Best Answer

  • Jirapongse
    Jirapongse ✭✭✭✭✭
    Answer ✓

    @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