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 ajalden · Feb 02 at 05:52 PM · pythondata limits

getting different results depending on number of RICs supplied

I am looking to download the quarterly earnings release dates for a list of RICs. When I run the following code with <=40 RICs I get the desired data with about 20 quarterly earnings dates for each company spanning the last 5 years. However, when my list of RICs is longer, it no longer gives me all the dates. Instead, i have some results from 2016 and 2017 mostly and most other dates are missing. What might be causing this performance?

nYrs2incl=5
EDate = -nYrs2incl*365
rptDtTime2, err = ek.get_data(
instruments = RICs,
fields = ['TR.EventStartDate(EventType=RES,SDate=0,EDate=' + str(EDate) + ')'])

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.

7 Replies

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by zoya.farberov · Feb 02 at 08:55 PM

Hello @ajalden,

This looks to be something else, please find my list with AAPL.O ( ~90 instruments), try running below on your side. I get back everything for AAPL.O ( please see the screenshot of the output included above).

Do you observe the same by running:

nYrs2incl=5
EDate = -nYrs2incl*365
df = ek.get_data(
instruments = ["AAPL.O","ADBE.O","ADSK.O","ALTR.O","AMAT.O","AMGN.O","AMZN.O","APCC.O","APOL.O","ATYT.O","BBBY.O","BEAS.O","BIIB.O","BMET.O","BRCM.O","CDWC.O","CECO.O","CELG.O","CHIR.O","CHKP.O","CHRW.O","CMCSA.O","CMVT.O","COST.O","CSCO.O","CTAS.O","CTSH.O","CTXS.O","DELL.O","DISH.O","DLTR.O","EBAY.O","ERICY.O","ERTS.O","ESRX.O","EXPD.O","FAST.O","FISV.O","FLEX.O","GENZ.O","GILD.O","GRMN.O","INTC.O","INTU.O","ISIL.O","IVGN.O","JDSU.O","JNPR.O","KLAC.O","LAMR.O","LBTYA.O","LLTC.O","LNCR.O","LRCX.O","LVLT.O","MCHP.O","MEDI.O","MLNM.O","MOLX.O","MRVL.O","MSFT.O","MXIM.O","NTAP.O","NVLS.O","ORCL.O","PAYX.O","PCAR.O","PDCO.O","PETM.O","PIXR.O","QCOM.O","QLGC.O","RIMM.O","ROST.O","SANM.O","SBUX.O","SEPR.O","SHLD.O","SIAL.O","SIRI.O","SNDK.O","SNPS.O","SPLS.O","SSCC.O","SUNW.O","SYMC.O","TEVA.O","TLAB.O","VRSN.O","WFMI.O","WYNN.O","XLNX.O","XMSR.O","XRAY.O","YHOO.O"],
fields = ['TR.EventStartDate(EventType=RES,SDate=0,EDate=' + str(EDate) + ')'])
pd.set_option('display.max_rows', 2000)
print(df)
pd.reset_option('display.max_rows

Next, replace my list with your list, observe the result, let us 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.

avatar image
REFINITIV
Answer by zoya.farberov · Feb 02 at 06:20 PM

Hello @ajalden,

From the behavior described, seems that you are hitting a request limit.

Please see Eikon Data API Usage and Limits Guideline, data points limit per get_data request is presently at 10K.

If you find yourself requiring more, or (I like to be conservative) anywhere close to the request limit, I would partition the request into several, by partitioning the instrument list into two or more sub-lists, to jointly include all the required instruments and to avoid approaching the limit. You may, alternatively, partition the required dates interval into sub-intervals.

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 ajalden · Feb 02 at 06:53 PM

I don't think that's it. I'll run only about 1000 results and it starts causing problems.

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 zoya.farberov · Feb 02 at 07:59 PM

@ajalden,

1000 data points should be no issue.

Please include the instruments that have content missing, so we can help verify this on our side. Would one of these instrument still have content missing, if you run it alone?

Another possible code is instruments that are not valid for the range selected. For example:

You see what is happening? I have a bunch of instruments on the list, that have been valid only some of the time, or none of the time, and they would result in points missing.


yhoo.gif (56.6 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 ajalden · Feb 02 at 08:41 PM

It's hard for me to send you an exact list but I've been able to replicate the problem whenever I use >50 RICs. For example, when I run AAPL.O on its own I get the full 20 or so earnings release dates. When when I ran a longer list or RICs - in which it was included - I only got these dates:


2016-10-142016-07-142016-04-132017-05-092017-02-09


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 ajalden · Feb 02 at 10:17 PM

This formula seemed to work


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 ajalden · Feb 02 at 10:19 PM

And it works on my list too. this is very odd

Comment

People who like this

0 Show 1 · 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
zoya.farberov ♦♦ · Feb 09 at 11:31 PM 0
Share

Hello @ajalden

Glad to hear it is working

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

How to get all Eikon Python API fields into an excel spreadsheet?

Is it possible to retrieve temperature forecast data via Python API? (for example EC00 Ens data). If yes, which function?

Exclude records with specific field values

download bond description via python API

How to get list of leaver companies of the ASX 100 using the Python API?

  • 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
  • Electronic Trading
    • Generic FIX
    • Local Bank Node API
    • Trading API
  • 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