There's a delay in API data updates.

liumenghui
liumenghui Newcomer
edited May 7 in DSS

A discrepancy exists between Excel and the API: Excel successfully pulls the latest crude oil data immediately after the 22:30 (Beijing Time) Wednesday release, but the API endpoints return outdated data. Is there a way to optimize the API's refresh cycle to ensure real-time data availability?

Eg:

=RDP.HistoricalPricing("GL-DEL-T-EIA;DST-DEL-T-EIA;RFO-DEL-T-EIA;PRO-SUP-T-EIA;PROD-DEL-T-EIA;GL-OUT-T-EIA;DST-OUT-T-EIA;JET-OUT-T-EIA;PRO-OUT-T-EIA;RFO-OUT-T-EIA;C-OUT-T-EIA","COMM_LAST","START:01-JAN-1996 ADJUSTED:YES SOURCE:RFV INTERVAL:P1W",,"TSREPEAT:NO CH:Fd RH:Timestamp",A7)

Tagged:

Answers

  • Jirapongse
    Jirapongse ✭✭✭✭✭

    @liumenghui

    Thank you for reaching out to us.

    I assume that you are retrieve historical data from the historical pricing service on RDP.

    Please contact the Historical Pricing API support team directly via MyAccount regarding the release times of those RICs.

Categories