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 varun.divakar · Jan 04 at 03:27 PM · missing data

RICs return null datasets

I am trying the get the Jumbos of a few markets. The corresponding RICs are given below:

LCO, LCC, LRC

The following Jumbo RICs are consistently returning null values in the dataset:

['LCOF8-H8^1' ,'LCOG8-J8^1' ,'LCOJ8-M8^1', 'LCOM8-Q8^1', 'LCON8-U8^1', 'LCOQ8-V8^1', 'LCOU8-X8^1', 'LCOV8-Z8^1' ,'LCOX8-F9^1' ,'LCOZ8-G9^1', 'LCOF9-H9^1', 'LCOG9-J9^1' ,'LCOH9-K9^1', 'LCOJ9-M9^1', 'LCOK9-N9^1', 'LCOM9-Q9^1', 'LCON9-U9^1']


['LCCH5-K5^1', 'LCCK5-N5^1', 'LCCN5-U5^1', 'LCCU5-Z5^1', 'LCCZ5-H6^1', 'LCCH6-K6^1', 'LCCK6-N6^1' ,'LCCN6-U6^1']


['LRCF5-H5^1', 'LRCH5-K5^1', 'LRCK5-N5^1' ,'LRCN5-U5^1' ,'LRCU5-X5^1', 'LRCX5-F6^1' ,'LRCF6-H6^1' ,'LRCH6-K6^1', 'LRCK6-N6^1', 'LRCN6-U6^1']

I am trying to using the eikon's python API using the following code:

e.get_timeseries(jumbo_rics, start_date='2015-1-1')

I am able to pull the other Jumbos during 2015-20 duration

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.

5 Replies

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by chavalit.jintamalit · Jan 11 at 08:42 AM

Hi @varun.divakar

I would not be able to give you the answer on the content availability for either get_data or get_timeseries

But from my observation by using the API, I could see that some instrument has fewer data compared to others.

You will need to contact Refinitiv Content Helpdesk to clarify on this content topic.

Comment

People who like this

0 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 chavalit.jintamalit · Jan 06 at 06:32 AM

Hi @varun.divakar

I checked a few instruments and they do not have the data for the whole period you requested via API.


Also, please review API limitation guideline at https://developers.refinitiv.com/en/api-catalog/eikon/eikon-data-api/documentation

For timeseries interday, you could retrieve up to 3000 records per single API call.


ahs1.png (61.2 KiB)
Comment

People who like this

0 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
Answer by varun.divakar · Jan 07 at 09:08 AM

Hi,

I have investigated this further, and I think the data is missing. I have attached screenshots of the code for only 1 jumbo here below, so there is no chance of hitting the 3000 limitation you have mentioned. This time I have run the code in Reuters Code Creator. Please see that using the both get_data and get_timeseries gives different results. And neither of them have data as such.




1610010498455.png (203.4 KiB)
1610010517872.png (192.0 KiB)
Comment

People who like this

0 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 chavalit.jintamalit · Jan 07 at 01:45 PM

Hi @varun.divakar

Thanks for your additional information.

Now I understand that you are trying to compare the data between get_data() with TR.<xxx>PRICE fields and get_timeseries().


I believe that this instrument code does not carry the data on TR.<xxx>PRICE fields.

This forum is not the best place to ask about content questions.
For an authoritative answer to any content questions, the best resource is the Refinitiv Content Helpdesk.
The moderators here do not have deep expertise in every type of content available through Eikon.
The Refinitiv Content Helpdesk can be reached using Contact Us capability in your Eikon application.
Or by calling the Helpdesk number in your country.
Or at https://my.refinitiv.com/

Comment

People who like this

0 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
Answer by varun.divakar · Jan 08 at 08:09 AM

I am not comparing the two functions. I am showing with example that you can't get data using either of the two available functions. What I am asking you is for a workaround to get the data for this RIC. If the data is not available then please let me know.

Comment

People who like this

0 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 >
10 People are following this question.

Related Questions

not getting the lastest data from Datafeed (Matlab) for RIC aXZHICPXTUR (inflation fixing)

im trying to get a timeseriers of traded volumes for various stock RICS but seems to be lots of missing data for some stocks. I have tried TR.Volume and TR.AccumulatedVolume but both seem to produce missing data

Eikon API python RES event type

Eikon Scripting API (Python) PrimaryRIC's not pulling using Screen as input for tickers

Why does company financial data seem to be missing at certain dates?

  • 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