Is there a data field or a formula that retrieves Fiscal Year convention like FY2026 in Excel?

johndrib.suganob01

Which fiscal year does the field TR.CompanyFYearEnd return exactly? For example, AAPL’s fiscal year end date is September 30, 2026, which corresponds to the end of its 2026 fiscal year.However, LULU’s fiscal year end date is January 31, 2026, which represents the end of its 2025 fiscal year.

My goal now is to determine the fiscal year convention for a list of stocks. Is there a way to find related fields that can help me achieve this in Excel?

ujjawal_khandelwal

Hi @johndrib.suganob01,
Thank you for reaching out!

While we are not content experts and this forum is for software developers looking for technical help related to APIs, I tried finding details about the TR.CompanyFYearEnd on Data Item Browser (DIB) and below is the description:

The fiscal period end date for the next expected annual report.

Thus, the field tells you what the next expected fiscal period end date of a company is. You can also refer to this question which was asked earlier similar to yours. For more content related queries, you can reach out to the LSEG Support team. Hope this helps. Thanks!