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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
25 3 3 8

Trying to download historical employee count with get_data, only returns current data

I am trying to download historical employee count with the API, using

TR.Employees and get_data. But this only returns the current value. How do we get the history?

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.

1 Answer

Upvotes
Accepted
4.6k 26 7 22

@9029ef3d-816c-4b3d-b8a4-7e45f818c246, in order to have the result returned as series make sure you specify the SDate and EDate:

 df, e = ek.get_data('AAPL.O', 'TR.Employees.fperiod, TR.Employees', {'SDate':'0','EDate':'-9','Period':'FY0', 'Frq':'FY'})


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.

is it only annual? or interim as well?

I believe the number of employees is only available in annual reports through Eikon. But you may want to verify this with Refinitiv Helpdesk, since this is purely a content question not specific to the use of APIs.

Click below to post an Idea Post Idea