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 jaydoubleu79 · Mar 02, 2020 at 12:34 PM · timeseriestimeoutslice

Timeout errors on Get_timeseries requests and is slow

Hi!

Im trying to build a screener for european stocks to see which stocks have unusual volume in the last 15 minutes compared to avg volumes.


Im trying to retrieve volume data (for 30days and 15 minutes) in 2 seperate get timeseries calls.

My stock universe is around 6000 RICS, so i divide the list in slices of 200 RICS each and make 2 separate calls per slice to the eikon data api to retrieve the volume data for each slice.

the minute call looks like this.

df = ek.get_timeseries(list_of_slices[x], fields='Volume', interval='minute', count=15)

When i go through all my slices i get quite a few timeout errors:

"2020-03-02 12:55:51,857 P[24172] [MainThread 28276] Request timeout occured"

I then go and retry the slices which fail until I get all data, but this process is painfully slow:

for the daily data: 0:02:51.512791
for the minute data: 0:10:31.204523

(getting the data, not counting the errors, is not really fast either I have to say)

I tried adjusting the slice sizes,smaller leads to less errors, but then I it takes even longer to go through the list.


My question is: How can I get to speed this process up?

Buiding a screener which shows results with a delay up to 10 minutes is pretty much useless :)


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 Alex Putkov. · Mar 10, 2020 at 06:29 PM

The main bottleneck in your process is the fact that all the data is retrieved sequentially, which is due to the synchronous implementation of get_timeseries method. We will be introducing asynchronous methods for data retrieval into Eikon Data APIs, although I don't have the timeframe for this. Until then you may consider using Eikon .NET API that provides asynchronous methods for timeseries data retrieval. Alternatively you may try to run your script several times in parallel with each instance of the script processing a portion of your stocks universe.

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 jaydoubleu79 · Mar 25, 2020 at 07:45 AM

Thank you very much for the answer. Lets hope Async implemetation for Eikon in python is implemented soon-ish :)


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

Related Questions

Eikon Desktop Data API stopped working after changing to a new user on Eikon terminal

get_timeseries - Historical fields inconsistencies (interval = TAS)

Is ITradeData.PriceTick always null?

Include current price in hourly prices time series, python API

I´m getting this error in Codebook: ERROR:pyeikon:HTTP ConnectTimeout: TimeoutException on HTTP request: ReadTimeout(''). No response from Eikon Proxy.

  • 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