When using get_timeseries for RIC FCPOJ0, the open, high and low are correct but the close is a d...

When using get_timeseries for RIC FCPOJ0, the open, high and low are correct but the close is a duplicate of yesterdays close. This is not the case with for instance BOK0, where the behaviour is as expected.

Find more posts tagged with

python

eikon

error

data

workspace

eikon-data-api

refinitiv-dataplatform-eikon

workspace-data-api

Accepted answers

chavalit-jintamalit

Hi @eddy_de_groot

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.

All comments

Tim Smith

Hi @eddy_de_groot

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.

eddy_de_groot

That is when I query for prices up to today when the markets are still open.

zoya faberov

Hello @eddy_de_groot,

Could you please give us a quick update on this:

Does the problem continue to occur?

Did you have a chance to contact Content Helpdesk to report the suspected issue and have it investigated by our content experts?

eddy_de_groot

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.

Best regards,

Eddy

chavalit-jintamalit

Hi @eddy_de_groot

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.

eddy_de_groot

thanks for your answer, however I dont understand the following:

"Moderators in this forum are not able to confirm nor clarify the data behavior. "

you are able to replicate it and you see it is wrong. I am asking for a fix, not an explanation as there is no alternative to get historical daily data through the python API and I am getting wrong data points.

Also I find it a bit depressing when you forward the issue to the help desk that the first question I get is what the query is I used, i.e. he/she had no idea what the story behind this query was..

EXPLORE OUR SITES