Upgrade from Eikon -> Workspace. Learn about programming differences.

For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
yongks avatar image
1 ●1 ●2 ●2

get_data return columns which is shifted due to missing data

When query for TR.OPENPRICE and TR.VOLUME, the columns are shifted due to missing data. See picture attached.

Questions:

  1. Why is there a mssing OPENPRICE data on 28/1/2013 ?
  2. Is there a fix for to ensure row is not shifted due to missing value ?
df4, error = ek.get_data( 'MBBM.KL',
          ['TR.OPENPRICE.Date','TR.OPENPRICE', 'TR.VOLUME','TR.VOLUME.date'],
           parameters = {
                   'SDate':  '2013-01-25',
                   'EDate':  '2013-02-05'})

eikoneikon-data-apipythonrefinitiv-dataplatform-eikonworkspaceworkspace-data-apidss-rest-apierror
rows-shifted.png (18.1 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

veerapath.rungruengrayubkul avatar image   veerapath.rungruengrayubkul

@yongks

Hi,

Thank you for your participation in the forum.

Is the reply below satisfactory in answering your question?

If yes please click the 'Accept' text next to the most appropriate reply. This will guide all community members who have a similar question.

Otherwise please post again offering further insight into your question.

Thanks,

AHS

pimchaya.wongrukun01 avatar image   pimchaya.wongrukun01

Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.

Thanks,

AHS

2 Answers

· Write an Answer
Upvote
Accepted
chavalit-jintamalit avatar image
18.2k ●21 ●13 ●21

Hi @yongks

There are 2 topics in your question.

1. Why the data point of OPENPRICE for 28th Jan 2013 is not present?

You can contact Refinitiv Content Helpdesk at this URL for an authoritative answer.

I can see the same on the Eikon Desktop.

2. Data return from the get_data

The data will fill in on each of the columns, please see this as an example that I can retrieve data from different time period and combine them in a single call.

So this is expected behavior.


ahs1.png (132.6 KiB)
ahs2.png (57.6 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvote
Alex Putkov.1 avatar image
39.4k ●77 ●11 ●27

@yongks
In addition to the answer by @chavalit.jintamalit be advised that when you're mixing fields from different categories (see the illustration of TR.OPENPRICE and TR.VOLUME falling under different categories in Formula Builder wizard in Eikon Excel) the timeseries returned for these fields are not guaranteed to be aligned on the date.


The timeseries may not even have the same periodicity, e.g. you can retrieve company income statement items from say quarterly reports and daily stock price history in the same request. For your use case instead of TR.OPENPRICE consider using TR.PriceOpen field, which falls under the same category as TR.Volume. In the following request the timeseries returned for each field will align on the date.

ek.get_data(['MBBM.KL'], ['TR.PriceOpen.date','TR.PriceOpen',
                         'TR.Volume','TR.VOLUME.date'],
           {'SDate':'2013-01-25', 'EDate':'2013-02-05'})

screenshot1.png (61.6 KiB)
screenshot2.png (46.0 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.