Unaligned time series fields

I extract multiple time series fields for an instrument in one query using `get_data`. I came across debt and equity RICs for which there are rows in the response where the fields' values refer to different dates. In other words, the data fields are not aligned based on their respective date.

I would not have expected this behavior and did not find any sort of documentation on this. Is this a glitch or is this how the API is supposed to work? In case of the latter, I would have to query the date for every individual field and perform a merge, which is far from ideal.

Thank you for your help!

para = {
    'SDate': '2013-01-01',
    'EDate': '2019-12-31',
    'DateType': 'AD',
    'CURN': 'EUR'
}
df, err = ek.get_data(['136447AW9='], ['TR.BIDPRICE.DATE','TR.BIDPRICE.VALUE','TR.MIDYIELD.DATE','TR.MIDYIELD.VALUE'], field_name=True, parameters=para)

As an example, I marked one line where this is the case.

The same applies to the following stock

df, err = ek.get_data(['BENE.F^L15'], ['TR.PRICECLOSE.DATE','TR.PRICECLOSE.VALUE','TR.ISSUEMARKETCAP.DATE','TR.ISSUEMARKETCAP'], field_name=True, parameters=para)

Find more posts tagged with

python

eikon

workspace

eikon-data-api

refinitiv-dataplatform-eikon

workspace-data-api

Accepted answers

zoya faberov

Hello @jhonny,

I believe you are describing an inconsistency in Eikon content ((suspected), as returned by Eikon Data API.

I have tested the same request in Eikon Excel, and appear to observe the same results:

=TR("136447AW9=", "TR.BIDPRICE.DATE;TR.BIDPRICE.VALUE;TR.MIDYIELD.DATE;TR.MIDYIELD.VALUE","SDate=2013-01-01 EDate=2019-12-31 DateType=AD CURN=EUR",C6:F1800)

If the question is on Eikon content, if you suspect the content is incorrect, and not on API and retrieval, the best approach for a customer is to get this investigated by Refinitiv Helpdesk, select "I need help understanding content" for product "Thomson Reuters Eikon" and provide the complete details.

Let us know if this information helps.

All comments

zoya faberov

Hello @jhonny,

I believe you are describing an inconsistency in Eikon content ((suspected), as returned by Eikon Data API.

I have tested the same request in Eikon Excel, and appear to observe the same results:

=TR("136447AW9=", "TR.BIDPRICE.DATE;TR.BIDPRICE.VALUE;TR.MIDYIELD.DATE;TR.MIDYIELD.VALUE","SDate=2013-01-01 EDate=2019-12-31 DateType=AD CURN=EUR",C6:F1800)

Let us know if this information helps.

jhonny

Hi @zoya.farberov, thanks for your answer. I may misunderstand you, but let me emphasize that I am not challenging that the data values are correct. I am asking whether the structure of the API response above is expected. My problem with it is that when I query multiple time series fields, I expect that all fields' values for some date X appear in the same row. This is not the case in my example above: you see in the same row the BIDPRICE from 2019-12-15 and the MIDYIELD from 2019-11-21. My expectation was that I do not have to query the date parameter of the second field, MIDYIELD, once I already have the date for BIDPRICE. Had I only queried the date column for BIDPRICE, I would have assigned field values of MIDYIELD to the wrong date. I tend to view it as an API and not a data problem, because I would expect the API to deal with the fact that any two time series fields do not always have an observation for the same date. But I appreciate that I may be wrong depending on how your Databases work internally. If you are still convinced this is a content question, please tell me and I will forward this to the Helpdesk.

umer.nalla

Hi @jhonny

Generally speaking, I would expect the backend to do the heavy lifting and fill any missing values on such a potentially large dataset (if possible) - rather than a Desktop API which is executed at the PC and therefore most likely not as efficient.

jhonny

Thank you for your answers,@zoya faberov and @umer.nalla. I received the following response from the Content Helpdesk stating that this is an API Issue and not a Content Issue. They instruct me to ask a question in this forum - although I provided them with the link of my actual question here. This has not been helpful.

Content Helpdesk response:

Checked this with our method of work and I was able to confirm that support for Python API is through the developers forums with hundreds of users per specific APIs and a handful of developers who monitor the same.

Please register and check the forum through the link below:

https://developers.thomsonreuters.com/

There's also a brief guide and an FAQ page via link below:

https://developers.thomsonreuters.com/eikon-com/eikon-desktop-data-api

From the first link I sent, there's a Question and Answer tab and we can search Python on the search box to bring up all Python related Forum pages. We can tweak our keywords to have an optimal search result.

On the Question and Answer page, there's a button on the upper left hand corner that lets us submit a Question via "Ask a Question" option. We can use the function to submit our API question and one of our developers will attend to it shortly. However, since this is a forum based help site, the turn-around time or service level is not guaranteed that it will be picked up within the day.

We are a Content related but I see in your query that the description is not a Content related

jhonny

So my understanding is correct that this is an unexpected behavior?

EXPLORE OUR SITES