Differences between the API and Excel AddIn

profision · 2025-05-02T13:37:57+00:00

There was an error rendering this rich post.

I'm curious why there is a discrepancy here in the data obtained through ld.get_data() compared to the Excel add-in.

The TRADE_DATE through the Refinitiv Data API is telling me 2025-05-02 for MR50 SPOT and MI3.5 Spot whereas the Excel Addon is telling me 2025-05-01

Find more posts tagged with

price-history

#content

Accepted answers

All comments

profision

For additional context, this is my code:

df_getdata = ld.get_data( universe=["D-PPXDK00", "D-PUABC00", "D-AMFSA00", "D-PUMFD00"], fields=["TRADE_DATE", "TRDPRC_1"] )

Jirapongse

@profision

Thank you for reaching out to us.

The data is from different services. The ld.get_data method gets the values of TRADE_DATE and TRDPRC_1 fields from the real-time service while the RHistory method gets historical data from the historical service.

Typically, the values from the ld.get_data method should be equal to the values on the Quote App and the values from the RHistory method should be equal to the values on the Chart App.

To verify the content, please contact the helpdesk support team directly via MyAccount.

EXPLORE OUR SITES