Upgrade from Eikon -> Workspace. Learn about programming differences.

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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
16 3 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-apipythonrefinitiv-dataplatform-eikonworkspaceworkspace-data-apihistorical
icon clock
10 |1500

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

Hello @dxu

Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?
If yes, please click the 'Accept' text next to the reply. This will guide all community members who have a similar question. Otherwise please post again offering further insight into your question.

Thanks,
AHS

Hi @dxu

Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?

If so please can you click the 'Accept' text next to the appropriate reply. This will guide all community members who have a similar question.

Thanks,

AHS

Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.

Thanks,

AHS

Upvote
Accepted
17.2k 82 39 63

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 512.0 KiB each and 1.0 MiB total.

Upvotes
39.4k 77 11 27

You can use get_data function for this purpose. There's an example at the bottom of Quick Start Guide
https://developers.thomsonreuters.com/eikon-data-apis/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.thomsonreuters.com/eikon-data-apis/learning?content=14707&type=learning_material_item

icon clock
10 |1500

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

Upvote
16 3 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 512.0 KiB each and 1.0 MiB total.

how do i get the dates associated with each datapoint though?

Hi @dkdg73,

For the field list, you can specify the following:

 ['TR.EPSMean', 'TR.EPSMean.date']

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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