Python API: FY2007 data is missing

nathan.n.nastili

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?

chavalit-jintamalit

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.

chavalit-jintamalit

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.