Avail function in python API?

Hemant
Hemant Newcomer

=TR($C$5:$C$3500,"TR.TotalAssets-ZAV(AVAIL(TR.TotalCurrLiabilities,TR.OtherCurrentLiabTotal,TR.OtherCurrentLiabilities))","Period=FY2008 Scale=6 Null=Blank Curn=#1",K$5:K$3500,RIC!$J$4)

I am trying to model the above formula using LSEG python API. I am not sure of how to incporate the avail functionality as is being use din the above excel formula. Could someone please help.

Answers

  • Jirapongse
    Jirapongse ✭✭✭✭✭
    edited April 8

    @Hemant

    Thank you for reaching out to us.

    I tested it with the get_data method in the LSEG Data Library for Python.

    df = ld.get_data(
        universe=['IBM.N'],
        fields=['TR.TotalAssets-ZAV(AVAIL(TR.TotalCurrLiabilities,TR.OtherCurrentLiabTotal,TR.OtherCurrentLiabilities))'],
        parameters = {"Period":"FY2008", "Scale":"6"}
    )
    
    df
    

    It can return the data properly.

    image.png