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.07177679
However, 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.071777
How do I get the `FY201x` in the Python output?