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

pfreitas
pfreitas Newcomer
in Datastream

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?

Tagged:

Best Answer

  • Jirapongse
    Jirapongse ✭✭✭✭✭
    Answer ✓

    @pfreitas

    Thank you for reaching out to us.

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

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

    1722931763851.png

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

Answers

Categories