Raising obo a client: TR.F.TotAssets in API

Options
RogelynMayAgustin
RogelynMayAgustin LSEG
edited 7:51AM in Refinitiv Data Platform Libraries

I am trying to retrieve some balance sheet data for a sample of large cap in euro area. Among them, I am not able to find the data even though I was able to 2 weeks ago:
ACBr.AT
FR0000131104
DE0005140008
ES0180907000
IT0005239360
DE0005552004
DE0007100000
ES0148396007
FR0000120073
FR0010208488

Do you know why is this the case?

this is the python code:

TotalAssets, err = ek.get_data(tickers,

    fields=['TR.F.TotAssets.calcdate','TR.F.TotAssets'],

    parameters={'SDate': '2019-12-31','Curn': 'EUR','Scale': '9'}

)

these are my tickers:

tickers = ['NL0011540547', 'IE00BF0L3536', 'ACBr.AT', 'IT0001031084', 'IT0004776628','BMPS.MI', 
'IT0000784196', 'ES0113211835', 'IT0005218380', 'ES0113860A34','ES0113900J37', 'IE00BD1RP616', 
'ES0113307062', 'ES0113679I37', 'AT0000BAWAG2','FR0000131104', 'IT0000066123', 'ES0140609019', 
'DE000CBK1001', 'FR0000045072','IT0005412025', 'DE0005140008', 'DE0008019001', 'AT0000652011', 
'GRS323003012','IT0000072170', 'NL0011821202', 'IT0000072618', 'BE0003867844', 'BE0003565737',
'ES0168675090', 'IT0000062957', 'GRS003003035', 'FR0000120685', 'GRS014003032','AT0000606306', 
'FR0000130809', 'IT0003487029', 'ES0180907000', 'IT0005239360','DE0005552004', 'DE0005557508',
 'DE0005785604', 'DE0007100000', 'DE0007164600','DE0007236101', 'DE0007664039', 'DE000A1EWWW0', 
'DE000BASF111', 'DE000BAY0017','ES0109067019', 'ES0144580Y14', 'ES0148396007', 'ES0178430E18', 
'FI0009000681','FR0000073272', 'FR0000120073', 'FR0000120271', 'FR0000120321', 'FR0000120578',
'FR0000120644', 'FR0000121014', 'FR0000121485', 'FR0000121667', 'FR0000121972','FR0000125486', 
'FR0000127771', 'FR0000133308', 'FR0010208488', 'IE0001827041','LIN.O', 'IT0003128367', 'IT0003132476',
 'NL0000009538', 'NL0000235190','NL0000388619', 'NL0010273215', 'NL0011794037', 'BE0974293251',
 'DE0005190003']

I provided the following to the client:

import refinitiv.data as rd


rd.open_session()


df = rd.get_data(

    universe = ['ACBr.AT','BNPP.PA','DBKGn.DE','UNI.MC','CRDI.MI','DHLn.DE','MBGn.DE','ITX.MC','AIRP.PA','ENGIE.PA'],

    fields = ['TR.F.TotAssets.calcdate','TR.F.TotAssets(Period=FY0,Frq=FY,SDate=2019-12-31,Scale=9,Curn=EUR)']

)


display(df)

image.png


However, as per client it doesn't seem to work.

He said:
I usually use this key to connect with the python api
ek.set_app_key('REMOVED')
how does it work with the import refinitiv.data as rd library

image.png

Do you know the difference with import refinitiv.data as rd and import eikon as ek ?

Tagged:

Answers

  • Gurpreet
    Gurpreet admin

    Hi @RogelynMayAgustin

    The code you provided is correct and yields results. Their app key is also correct (which I have removed from question). Most likely some of their dependencies might be incorrect. The Eikon data API is legacy and we support the newer LD library only.

    You can ask the user to setup a clean virtual environment with LD library and try the code snippet again.

  • RogelynMayAgustin
    RogelynMayAgustin LSEG

    Thank you @Gurpreet
    I'll check with the client again.

Categories