Unmatched financial statements reference dates with date index and EPS Report Date?

I am analysing Apple financial statements and noticed that the displayed date does not match with the reference date, the stock's fiscal year ends in September.

aapl = ds.get_data(tickers = 'US0378331005', fields = ['WC01001A', "WC05901", "WC05902", "WC05903", "WC05904", 'W05350A'], start = '2020-12-31', kind=1, freq = 'Q')

DatesWC01001AWC05901WC05902WC05903WC05904W05350A2020-12-3164698000NoneNoneNone2021-01-272020-09-262021-03-311114390002021-04-28NoneNoneNone2020-12-262021-06-3089584000None2021-07-27NoneNone2021-03-272021-09-3081434000NoneNone2021-10-28None2021-06-262021-12-3183360000NoneNoneNone2022-01-272021-09-252022-03-311239450002022-04-28NoneNoneNone2021-12-252022-06-3097278000None2022-07-28NoneNone2022-03-262022-09-3082959000NoneNone2022-10-27None2022-06-252022-12-3090146000NoneNoneNone2023-02-022022-09-242023-03-311171540002023-05-04NoneNoneNone2022-12-312023-06-3094836000None2023-08-03NoneNone2023-04-012023-09-2981797000NoneNone2023-11-02None2023-07-012023-12-2989498000NoneNoneNone2024-02-012023-09-302024-03-291195750002024-05-02NoneNoneNone2023-12-302024-06-2890753000NoneNoneNoneNone2024-03-30

The data from 2024-06-28 is from 2024-03-30 and it was reported on 2024-05-02, but the table looks like that the data from 202-03-29 was reported on that day, is there a way to match this dates?

Find more posts tagged with

python

datastream-api

financial-statements

#content

Accepted answers

Jirapongse

@pfreitas

Thank you for reaching out to us.

I tested the same formula on the Datastream Excel Addins and got the same result.

=@DSGRID(&quot;@AAPL&quot;,"WC01001A;WC05901;WC05902;WC05903;WC05904;W05350A","2020-12-31","","Q","RowHeader=true;ColHeader=true;Heading=true;DispSeriesDescription=false;YearlyTSFormat=false;QuarterlyTSFormat=false;MonthlyTSFormat=False","")

Please contact the Datastream support team directly via MyAccount to verify the data.

All comments

Jirapongse

@pfreitas

Thank you for reaching out to us.

I tested the same formula on the Datastream Excel Addins and got the same result.

=@DSGRID(&quot;@AAPL&quot;,"WC01001A;WC05901;WC05902;WC05903;WC05904;W05350A","2020-12-31","","Q","RowHeader=true;ColHeader=true;Heading=true;DispSeriesDescription=false;YearlyTSFormat=false;QuarterlyTSFormat=false;MonthlyTSFormat=False","")

Please contact the Datastream support team directly via MyAccount to verify the data.

pfreitas

We found a temporary solution to this problem by setting the end date two years ahead (2026). And now we will try to match the date in the column WC05350A with the index value searhcing for the closest previous date.

EXPLORE OUR SITES