14777072- please assist on this Query

Nataraja

I am using the `lseg.data` Python API to retrieve quarterly financial data. However, I am encountering an issue where multiple records are returned for the same date, which I believe should correspond to a single value per```test_fields = ["TR.EarningsRetentionRatePct", "TR.EarningsRetentionRatePct.date"]

Jirapongse

@Nataraja

Thank you for reaching out to us.

To handle this issue, you need to compare the data from API with the data from =RDP.Data function on the Workspace Excel. I ran the following formula on the Workspace Excel.

=@RDP.Data("MWA","TR.EarningsRetentionRatePct.Date;TR.EarningsRetentionRatePct","Sdate=2000-01-01 EDate=2025-01-01 Frq=FQ Period=FQ0 Adjusted=0 Curn=USD ReportType:MR CH=Fd RH=IN",E2)

The output on the Workspace Excel is similar to the data retrieved by the API.

According to this information, it could be a content issue.