Missing Q32025 data when end_date='2025-11-28' is used

myla.dumanhog

I am unable to retrieve Q3 2025 earnings data for tickers 2882.TW and 2883.TW using Refinitiv Data API, despite the earnings release dates being before the specified end_date.

Details:

• For 2882.TW, expected earnings release date for Q3 2025: 28-Nov-2025
• For 2883.TW, expected earnings release date for Q3 2025: 24-Nov-2025
• Code:

end_date='2025-11-28'
params = {'SDate': '-8Q', 'EDate': end_date, 'Curn': 'TWD', 'Period': 'FQ0', 'Frq': 'FQ'} # last 8 quarters as of universe_date

field = 'TR.F.IncAvailToComExclExordItems'
rd.get_data(['2882.TW'], [field, field + '.fperiod', field + '.periodenddate'], params)

Observed Issue:

• When running the code as of 28-Nov-2025, Q3 2025 data does not appear in the output.
• Data only appears if end_date is set to 2025-12-01.
• I expect Q3 2025 data to be available as of 28-Nov-2025, since the earnings release date is before that date.
• I am surprised that the 2025 Q3 datapoint is missing when using end_date = '2025-11-28', even though the earnings release date for Q3 2025 is before that date.

Additional Points for Confirmation:

• If this query were executed in Excel, what should the end_date be to include Q3 2025?
• Why does the API require an end_date in December when the earnings release date is mid-November (e.g., 17-Nov or 24-Nov)?
• Shouldn’t Q32025 data be included when end_date is 28-Nov-2025, given that the release date is before 28-Nov?

Jirapongse

@myla.dumanhog

Thank you for reaching out to us.

I checked data in Workspace Excel with the following formulas.

=@RDP.Data("2883.TW","TR.F.IncAvailToComExclExordItems;TR.F.IncAvailToComExclExordItems.fperiod;TR.F.IncAvailToComExclExordItems.periodenddate","Period=FQ0 Frq=FQ SDate=-8Q EDate=2025-11-28 CH=Fd RH=IN CURN=TWD",B2)


=@RDP.Data("2883.TW","TR.F.IncAvailToComExclExordItems;TR.F.IncAvailToComExclExordItems.fperiod;TR.F.IncAvailToComExclExordItems.periodenddate","Period=FQ0 Frq=FQ SDate=-8Q EDate=2025-12-01 CH=Fd RH=IN CURN=TWD",B14)

The output is similar to the API.

Therefore, this could be a content question. The API can retrieve the same data as the =RDP.Data Excel function.

Please contact the Workspace Excel to verify the content and formulas.