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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
16 1 1 5

Historical fundamental data

Hi,

We are learning Eikon python API. There is get_timeseries function which can only get historical prices and volumes. Is there a python function to get historical fundamental data like EPS and ROE?

Thanks.

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpythonhistorical
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.

Upvote
Accepted
9.7k 49 38 60

Hi @dxu,

You can use the get_data() function and specify a date range to retrieve historical fundamental data. The syntax would look something like:

get_data(<instruments>,[<fields>],{'SDate':'2017-06-01','EDate':'2017-08-04'})

for example.

Within Eikon, I would highly recommend using the DIB - Data Item Browser to determine the available fields you can use for the instruments you are interested in.

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.

Upvotes
39.2k 75 11 27

You can use get_data function for this purpose. There's an example at the bottom of Quick Start Guide
https://developers.refinitiv.com/en/api-catalog/eikon/eikon-data-api/quick-start

I also strongly recommend you check out this tutorial, which talks about metadata discovery, i.e. how to find the field names and parameters you can use to retrieve this or that data.
https://developers.refinitiv.com/en/api-catalog/eikon/eikon-data-api/tutorials#fundamentals-api-company-tearsheet-estimate

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.

Upvote
16 1 1 5

Thanks. I can use following code to get historical data. However, there is no date info shown in the result. I tried to use the data item browser to figure out what field I should use to get dates, but could not find it. Could you please help me? thanks.

df, err = ek.get_data(['MSFT.O'], ['TR.EPSMean'],{'SDate':'2015-01-01','EDate':'2018-01-29'})

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