For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
24 5 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-apipythonworkspaceworkspace-data-apirefinitiv-dataplatform-eikonbulk-downloadtick-data
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

Upvotes
Accepted
45.2k 103 43 60

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.