The Excel formula retrieves data from Lipper webservice.
From my observation, it seems that it reports last trade price to excel output.
So I think it always update according to the TRDPRC_1
However, Eikon Data API retrieves data from UDF service.
And give out different data.
Moderators in this forum are not able to confirm nor clarify the data behavior.
Refinitiv Content Helpdesk(https://my.refinitiv.com/) would be able to explain or give you an authoritative answer as why the data behave as you mentioned.
I have submitted case no. 08364124 on your behalf.
Im off to Malaysia this week, so this is a nice timely question on Malaysian Palm Oil Futures, thank you! :)Im not sure whether you are saying you think the HIGH and LOW is correct, but the settlement is wrong compared to another source. Or you are just worried that because the close/settlement price hasn't changed you think it could be incorrect?
I have checked against the exchange website and it looks like the Settlement Price hasn't changed for the past two days. This is possible as while the Highs and Lows come from the trading data. The Settlement Price (close price) is calculated by the exchange and sent out based on their own internal algorithm, which means it is less affected by trade price fluctuations.
If you really do think the settlement price is wrong for this contract then its best to raise it via our support desk and then they can speak directly to the exchange to confirm what we have been sent by them. Do this using the Contact Us button.
As I get no response let me clarify it once more what is happening. Again this morning (8:31) the same thing happens.
But now I also made a comparison between excel API and the python API.
On the left you see the excel output, exactly as expected.
The get_timeseries however returns the incorrect data. It returns a CLOSE value for a weekend day and the CLOSE is repeated for today as well. Both of which do not happen in excel.
The data requests are made at the same time so I would expect the same output. Like I mentioned earlier, the data issue is always resolved towards the end of the day and this happens in nearly all commodities I follow, but most severe in FCPO chain RIC.
When I query for minute data, this issue that the CLOSE is repeated is not present FYI.
Please help with/resolve this issue.