Avail function in python API?

Hemant

=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)
=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.

Jirapongse

@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.