Get financial period absolute in get_data

dayquant
dayquant
in Eikon Data APIs

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?

Tagged:

Best Answer

  • marcin.bunkowski
    marcin.bunkowski
    Answer ✓

    Hi @dayquant

    You can display it, using the same field with suffix "TR.EPSMeanEstLastYrGrowth.periodyear".
    If you are using Eikon Excel already you can discover all other suffixes using Build Formula tool:

    image

    fields = ['TR.EPSMeanEstLastYrGrowth.periodyear','TR.EPSMeanEstLastYrGrowth'] 
    eps_df,err = ek.get_data(['TCS.NS'], fields, parameters={'FRQ': 'FY', 'CH': 'IN', 'SDate': 0, 'EDate': -9})

    image

Categories