Hello,
For a sample RIC: `TCS.NS`, I am able to get `Earnings Per Share - Mean Growth (This Yr/Last Yr)` for past 10 years from Eikon Excel using below formula
=TR("TCS.NS","TR.EPSMeanEstLastYrGrowth","Frq=FY SDate=0 EDate=-9 CH=Fd RH=fperiod",$B$3)
Below is the output I get
Earnings Per Share - Mean Growth (This Yr/Last Yr) FY2020 9.40539773 FY2019 18.3350431 FY2018 -0.645308754 FY2017 11.73778622 FY2016 4.923145118 FY2015 7.888132552 FY2014 22.78673625 FY2013 26.04042365 FY2012 4.767541095 FY2011 26.07177679However, when I tried to convert the formula into Python API, I get the values of `Earnings Per Share - Mean Growth (This Yr/Last Yr)` but I do not get the corresponding financial year as seen in the output of Excel formula.
fields = [ek.TR_Field('TR.EPSMeanEstLastYrGrowth')] eps_df = ek.get_data(instruments=['TCS.NS'], fields=fields, parameters={'FRQ': 'FY', 'CH': 'IN', 'SDate': 0, 'EDate': -9})and below is my output
Instrument Earnings Per Share - Mean Growth (This Yr/Last Yr) 0 TCS.NS 9.405398 1 TCS.NS 18.335043 2 TCS.NS -0.645309 3 TCS.NS 11.737786 4 TCS.NS 4.923145 5 TCS.NS 7.888133 6 TCS.NS 22.786736 7 TCS.NS 26.040424 8 TCS.NS 4.767541 9 TCS.NS 26.071777How do I get the `FY201x` in the Python output?