For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
7 3 2 5

Get financial period absolute in get_data

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?

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpythondata
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

1 Answer

Upvote
Accepted
3.8k 4 4 6

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:

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


ahs.jpg (220.6 KiB)
ahs1.jpg (51.3 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Click below to post an Idea Post Idea