Differences between the API and Excel AddIn

profision
profision Newcomer
edited May 6 in Refinitiv Data Platform Libraries

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

image.png

image.png
Tagged:

Answers

  • profision
    profision Newcomer
    edited May 2

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

Categories