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)
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
Do you know the difference with import refinitiv.data as rd and import eikon as ek ?
