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
5 0 0 3

Python API: FY2007 data is missing

I am trying to pull the history of Total revenue for FPCG.PK and I am unable to get the data for 2007-01-31 (red). I tried setting the ReportingState to "All" or "Orig"

I am only able to pull the 9/30/2007 data using the code below

TR = ["TR.TotalRevenue.Date","TR.TotalRevenue"]
df, err = ek.get_data( ['FPCG.PK'], TR, {'Scale': 6, 'SDate': 0, 'EDate': -15, 'FRQ': 'FY', 'ReportingState':'All'})
df

Is it possible to pull 01-31-2007?

eikoneikon-data-apipythonrefinitiv-dataplatform-eikonworkspaceworkspace-data-api
1618350782385.png (62.7 KiB)
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
Accepted
18.2k 21 13 21

Hi @nathan.n.nastili

I received this response from helpdesk.


Our content specialist confirmed that there was a year end change from 31-Jan-2007 to 30-Sep-2007 hence only 30-Sep-2007 is reflecting in Eikon Excel.

I have consulted our GBC experts and confirmed that this is indeed a product limitation for Refinitiv Financials and no workaround is available. Data is only available on the Financials tab of the overview page on the desktop version.


So, this is a limitation and you will not be able to retrieve the 2007-01-31 data point using Eikon Data API or Eikon Excel formula.

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
18.2k 21 13 21

Hi @nathan.n.nastili

I can see the same using Eikon Excel and Eikon Data API.

I raised a ticket no. 09798629 to Content Helpdesk and waiting for their response.


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.

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.