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)
