What is the python code for the excel formula below:
=@TR("AXXN.O^J92","TR.EPSEstValue","SDate=19901231 EDate=19870101 Frq=D Period=1fq1989 CH=Fd;IN;brokername;fperiod RH=calcdate")
Upgrade from Eikon -> Workspace. Learn about programming differences.
For a deeper look into our Eikon Data API, look into:
Overview | Quickstart | Documentation | Downloads | Tutorials | Articles
14.9k
●32 ●5 ●10
Hi @irene.bandal-upo@refinitiv.com ,
The Data Item Browser and Eikon Data API in Python can help you in generating the Python code for the Eikon Data API with the steps below, In the Data Item Brower (DIB)
- Put instrument into the field (RIC)
- Search for the data item (field name)
- On Parameters tab, adjust the value of parameters you're interested
- Click this to copy the code for field name with parameters applied
And from the DIB and some code adjustment, is this what you're looking for?
import eikon as ek
ek.set_app_key('YOUR EIKON APP KEY')
df, err = ek.get_data(['AXXN.O^J92'], ['TR.EPSEstValue.calcdate', 'TR.EPSEstValue'],
{'SDate':'19901231', 'EDate':'19870101', 'Period':'1fq1989', 'Frq':'D'})
df
