Discover Refinitiv
MyRefinitiv Refinitiv Perspectives Careers
Created with Sketch.
All APIs Questions & Answers  Register |  Login
Ask a question
  • Questions
  • Tags
  • Badges
  • Unanswered
Search:
  • Home /
  • Eikon Data APIs /
avatar image
Question by yongks · Jul 29, 2019 at 11:36 PM · get_datadata errordss data missing

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'})

rows-shifted.png (18.1 KiB)

People who like this

0 Show 0
Comment
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

2 Replies

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by chavalit.jintamalit · Jul 30, 2019 at 03:38 AM

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)
Comment
yongks

People who like this

1 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
REFINITIV
Answer by Alex Putkov. · Jul 31, 2019 at 12:01 PM

@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)
Comment
yongks

People who like this

1 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

Watch this question

Add to watch list
Add to your watch list to receive emailed updates for this question. Too many emails? Change your settings >
8 People are following this question.

Related Questions

Retrieving information about EPS forecasts

Using Python API, how to distinguish between option expiry periodicity (Weekly, Monthly, Quarterly)?

get_data does not seem to handle columns with NULL/empty values properly

Is Eikon API down?

ek.get_data: issue with Frq=FS

  • Feedback
  • Copyright
  • Cookie Policy
  • Privacy Statement
  • Terms of Use
  • Careers
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Alpha
  • App Studio
  • Block Chain
  • Bot Platform
  • Calais
  • Connected Risk APIs
  • DSS
  • Data Fusion
  • Data Model Discovery
  • Datastream
  • Eikon COM
  • Eikon Data APIs
  • Elektron
    • EMA
    • ETA
    • WebSocket API
  • Legal One
  • Messenger Bot
  • Messenger Side by Side
  • ONESOURCE
    • Indirect Tax
  • Open PermID
    • Entity Search
  • Org ID
  • PAM
    • PAM - Logging
  • ProView
  • ProView Internal
  • Product Insight
  • Project Tracking
  • Refinitiv Data Platform
    • Refinitiv Data Platform Libraries
  • Rose's Space
  • Screening
    • Qual-ID API
    • Screening Deployed
    • Screening Online
    • World-Check One
    • World-Check One Zero Footprint
  • Side by Side Integration API
  • TR Knowledge Graph
  • TREP APIs
    • CAT
    • DACS Station
    • Open DACS
    • RFA
    • UPA
  • TREP Infrastructure
  • TRIT
  • TRKD
  • TRTH
  • Thomson One Smart
  • Transactions
    • REDI API
  • Velocity Analytics
  • Wealth Management Web Services
  • World-Check Data File
  • Explore
  • Tags
  • Questions
  • Badges