Im having trouble with missingquarter data for several American companies, including AAPL.

augusto_krappa

data retrieved with:

df_standard, err = ek.get_data(
instruments = ['AAPL.O'],
fields = ['TR.F.IncomeStatement.fieldname','TR.F.IncomeStatement','TR.F.IncomeStatement.date','TR.F.IncomeStatement.FCC'],
parameters = {'Scale': 6, 'SDate': 0, 'EDate': -30,'Period':'FQ0', 'FRQ': 'FQ','AlignType':'PrelimOrPeriodEndDate','ConsolBasis':'Consolidated'}
)

df_ASR, err = ek.get_data(
instruments = ['AAPL.O'],
fields = ['TR.F.ASRIncomeStatement.fieldname','TR.F.ASRIncomeStatement','TR.F.ASRIncomeStatement.date','TR.F.ASRIncomeStatement.FCC'],
parameters = {'Scale': 6, 'SDate': 0, 'EDate': -30,'Period':'FQ0', 'FRQ': 'FQ','AlignType':'PrelimOrPeriodEndDate','ConsolBasis':'Consolidated'}
)


"AAPL.O - Missing quarters detected: DatetimeIndex(['2015-12-31', '2017-12-31', '2018-12-31', '2019-12-31',
'2020-12-31', '2021-12-31', '2023-12-31'],
dtype='datetime64[ns]', freq=None)
INTC.O - Missing quarters detected: DatetimeIndex(['2015-12-31', '2017-12-31', '2018-12-31', '2019-12-31',
'2020-12-31', '2021-12-31', '2023-12-31'],
dtype='datetime64[ns]', freq=None)
JNJ - Missing quarters detected: DatetimeIndex(['2018-12-31', '2019-12-31'], dtype='datetime64[ns]', freq=None)
PEP.O - Missing quarters detected: DatetimeIndex(['2015-12-31', '2017-12-31', '2018-12-31', '2019-12-31',
'2020-12-31', '2021-12-31', '2023-12-31'],
dtype='datetime64[ns]', freq=None)
DIS - Missing quarters detected: DatetimeIndex(['2017-12-31', '2018-12-31', '2019-12-31', '2023-12-31'], dtype='datetime64[ns]', freq=None)
QCOM.O - Missing quarters detected: DatetimeIndex(['2015-12-31', '2016-12-31', '2017-12-31', '2018-12-31',
'2019-12-31', '2020-12-31', '2021-12-31', '2022-12-31',
'2023-12-31'],
dtype='datetime64[ns]', freq=None)
SBUX.O - Missing quarters detected: DatetimeIndex(['2015-12-31', '2018-12-31', '2019-12-31', '2020-12-31'], dtype='datetime64[ns]', freq=None)
KHC.O - Missing quarters detected: DatetimeIndex(['2017-12-31', '2018-12-31', '2019-12-31', '2020-12-31',
'2021-12-31', '2023-12-31'],
dtype='datetime64[ns]', freq=None)
COST.O - Missing quarters detected: DatetimeIndex(['2015-06-30', '2016-06-30', '2017-06-30', '2018-06-30',
'2019-06-30', '2020-06-30', '2021-06-30', '2022-06-30',
'2023-06-30', '2024-06-30'],
dtype='datetime64[ns]', freq=None)
HWM - Missing quarters detected: DatetimeIndex(['2016-12-31'], dtype='datetime64[ns]', freq='Q-DEC')
YUM - Missing quarters detected: DatetimeIndex(['2015-12-31'], dtype='datetime64[ns]', freq='Q-DEC')
VFC - Missing quarters detected: DatetimeIndex(['2017-12-31', '2018-12-31', '2019-12-31', '2020-12-31',
'2023-12-31'],
dtype='datetime64[ns]', freq=None)
TSN - Missing quarters detected: DatetimeIndex(['2017-12-31', '2018-12-31', '2019-12-31', '2023-12-31'], dtype='datetime64[ns]', freq=None)
TPR - Missing quarters detected: DatetimeIndex(['2015-12-31', '2017-12-31', '2018-12-31', '2019-12-31',
'2020-12-31', '2023-12-31'],
dtype='datetime64[ns]', freq=None)
CSX.O - Missing quarters detected: DatetimeIndex(['2015-12-31', '2016-12-31'], dtype='datetime64[ns]', freq=None)
CRI - Missing quarters detected: DatetimeIndex(['2017-12-31', '2018-12-31', '2019-12-31', '2023-12-31'], dtype='datetime64[ns]', freq=None)
CPRI.K - Missing quarters detected: DatetimeIndex(['2015-12-31', '2017-12-31', '2018-12-31', '2019-12-31',
'2020-12-31', '2021-12-31', '2023-12-31'],
dtype='datetime64[ns]', freq=None)
AZO - Missing quarters detected: DatetimeIndex(['2015-06-30', '2016-06-30', '2017-06-30', '2018-06-30',
'2019-06-30', '2020-06-30', '2021-06-30', '2022-06-30',
'2023-06-30', '2024-06-30']"

augusto_krappa

there is also missing data for: STMPA.PA, RIO,LM DGE.L

Jirapongse

@augusto_krappa

Thank you for reaching out to us.

As this forum is more for programming type queries, rather than content queries - I would recommend you raise a 'I need help understanding content within the product' ticket with our helpdesk. That way a Content specialist can work closely with you and verify the content.

augusto_krappa

could you specify which subject please?

Jirapongse

https://community.developers.refinitiv.com/discussion/comment/124711#Comment_124711

@augusto_krappa

The results from the ek.get_data method is similar to the results from Eikon Excel and Workspace Excel.

You can contact the Eikon or Workspace support team to verify the content.