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
24 8 7 11

pull tick time series with multiple rics at once

ek.get_timeseries( ['AAPL.O','AA'], interval='tick', start_date='2017-10-27T14:10:00', end_date='2017-10-27T16:10:00' ) has error message:

ValueError: Shape of passed values is (4, 177595), indices imply (4, 33723)

it seems that the tick time series for different rics have different length so they can not be concatenated together. But pulling 1 ric at a time is too time-consuming. Anyone knows how to do bulk request for tick?

eikoneikon-data-apipythonrefinitiv-dataplatform-eikonworkspaceworkspace-data-apitick-databulk-download
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.

1 Answer

· Write an Answer
Upvotes
Accepted
78.2k 246 52 72

From the stack, the problem happens when formatting the data frame. However, if I set normalize to True, it works.

ek.get_timeseries( ['AAPL.O','AA'], interval='tick', start_date='2017-10-27T14:10:00', end_date='2017-10-27T16:10:00', normalize=True ) 

However, if you want the data in JSON format instead of data frame, you can set raw_output to True.


normailize.png (28.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.

Thanks a lot for your answer.

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.