question

Upvotes
Accepted
pfreitas avatar image
1 ●0 ●0 ●1

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?

python#contentdatastream-apifinancial-statements
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Upvotes
Accepted
Jirapongse avatar image
84.9k ●289 ●53 ●77

@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.


1722931763851.png (21.2 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

pfreitas avatar image 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.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.