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

pfreitas
pfreitas
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

  • pfreitas
    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.

Categories