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
53 6 3 6

get_data return inconsistent with growing instrument list

Hi, I've been trying to get contract meta data using the function ek.get_data, but the output depends on how many instruments you put in.

Below I have a list of 300 different historical RICs, if I pull all at once, the column TR.FOTickerSymbol is not populated, but if I split the instrument list in two it does get populated. It only seems to affect this column in my example.


This behavior is not consistent, for some RIC combinations I observe the issue below, for other RIC combinations I dont see this.



An example to reproduce:


import eikon as ek

fields= ['TR.InstrumentDescription','TR.AssetCategory','TR.FOTickerSymbol']

instruments = ['LCCF1^2',
 'LCCG1^2',
 'LCCH1^2',
 'LCCJ1^2',
 'LCCK1^2',
 'LCCM1^2',
 'LCCN1^2',
 'LCCQ1^2',
 'LCCU1^2',
 'LCCV1^2',
 'LCCX1^2',
 'LCCZ1^2',
 'LCCF2^2',
 'LCCF2',
 'LCCG2^2',
 'LCCG2',
 'LCCH2^2',
 'LCCH2',
 'LCCJ2^2',
 'LCCJ2',
 'LCCK2^2',
 'LCCK2',
 'LCCM2^2',
 'LCCM2',
 'LCCN2^2',
 'LCCN2',
 'LCCQ2^2',
 'LCCQ2',
 'LCCU2^2',
 'LCCU2',
 'LCCV2^2',
 'LCCV2',
 'LCCX2^2',
 'LCCX2',
 'LCCZ2^2',
 'LCCZ2',
 'LCCF3',
 'LCCG3',
 'LCCH3',
 'LCCJ3',
 'LCCK3',
 'LCCM3',
 'LCCN3',
 'LCCQ3',
 'LCCU3',
 'LCCV3',
 'LCCX3',
 'LCCZ3',
 'LCCF4',
 'LCCG4',
 'LCCH4',
 'LCCJ4',
 'LCCK4',
 'LCCM4',
 'LCCN4',
 'LCCQ4',
 'LCCU4',
 'LCCV4',
 'LCCX4',
 'LCCZ4',
 'LCCF5',
 'LCCG5',
 'LCCH5',
 'LCCJ5',
 'LCCK5',
 'LCCM5',
 'LCCN5',
 'LCCQ5',
 'LCCU5',
 'LCCV5',
 'LCCX5',
 'LCCZ5',
 'LCCF6',
 'LCCG6',
 'LCCH6',
 'LCCJ6',
 'LCCK6',
 'LCCM6',
 'LCCN6',
 'LCCQ6',
 'LCCU6',
 'LCCV6',
 'LCCX6',
 'LCCZ6',
 'LCCF7',
 'LCCG7',
 'LCCH7',
 'LCCJ7',
 'LCCK7',
 'LCCM7',
 'LCCN7',
 'LCCQ7',
 'LCCU7',
 'LCCV7',
 'LCCX7',
 'LCCZ7',
 'LCOF0^0',
 'LCOG0^0',
 'LCOH0^0',
 'LCOJ0^0',
 'LCOK0^0',
 'LCOM0^0',
 'LCON0^0',
 'LCOQ0^0',
 'LCOU0^0',
 'LCOV0^0',
 'LCOX0^0',
 'LCOZ0^0',
 'LCOF1^0',
 'LCOG1^0',
 'LCOH1^0',
 'LCOJ1^0',
 'LCOK1^0',
 'LCOM1^0',
 'LCON1^0',
 'LCOQ1^0',
 'LCOU1^0',
 'LCOV1^0',
 'LCOX1^0',
 'LCOZ1^0',
 'LCOF2^0',
 'LCOG2^0',
 'LCOH2^0',
 'LCOJ2^0',
 'LCOK2^0',
 'LCOM2^0',
 'LCON2^0',
 'LCOQ2^0',
 'LCOU2^0',
 'LCOV2^0',
 'LCOX2^0',
 'LCOZ2^0',
 'LCOF3^0',
 'LCOG3^0',
 'LCOH3^0',
 'LCOJ3^0',
 'LCOK3^0',
 'LCOM3^0',
 'LCON3^0',
 'LCOQ3^0',
 'LCOU3^0',
 'LCOV3^0',
 'LCOX3^0',
 'LCOZ3^0',
 'LCOF4^0',
 'LCOG4^0',
 'LCOH4^0',
 'LCOJ4^0',
 'LCOK4^0',
 'LCOM4^0',
 'LCON4^0',
 'LCOQ4^0',
 'LCOU4^0',
 'LCOV4^0',
 'LCOX4^0',
 'LCOZ4^0',
 'LCOF5^0',
 'LCOG5^0',
 'LCOH5^0',
 'LCOJ5^0',
 'LCOK5^0',
 'LCOM5^0',
 'LCON5^0',
 'LCOQ5^0',
 'LCOU5^0',
 'LCOV5^0',
 'LCOX5^0',
 'LCOZ5^0',
 'LCOF6^0',
 'LCOG6^0',
 'LCOH6^0',
 'LCOJ6^0',
 'LCOK6^0',
 'LCOM6^0',
 'LCON6^0',
 'LCOQ6^0',
 'LCOU6^0',
 'LCOV6^0',
 'LCOX6^0',
 'LCOZ6^0',
 'LCOF7^0',
 'LCOG7^0',
 'LCOH7^0',
 'LCOJ7^0',
 'LCOK7^0',
 'LCOM7^0',
 'LCON7^0',
 'LCOQ7^0',
 'LCOU7^0',
 'LCOV7^0',
 'LCOX7^0',
 'LCOZ7^0',
 'LCOF8^0',
 'LCOG8^0',
 'LCOH8^0',
 'LCOJ8^0',
 'LCOK8^0',
 'LCOM8^0',
 'LCON8^0',
 'LCOQ8^0',
 'LCOU8^0',
 'LCOV8^0',
 'LCOX8^0',
 'LCOZ8^0',
 'LCOF9^0',
 'LCOG9^0',
 'LCOH9^0',
 'LCOJ9^0',
 'LCOK9^0',
 'LCOM9^0',
 'LCON9^0',
 'LCOQ9^0',
 'LCOU9^0',
 'LCOV9^0',
 'LCOX9^0',
 'LCOZ9^0',
 'LCOF0^1',
 'LCOG0^1',
 'LCOH0^1',
 'LCOJ0^1',
 'LCOK0^1',
 'LCOM0^1',
 'LCON0^1',
 'LCOQ0^1',
 'LCOU0^1',
 'LCOV0^1',
 'LCOX0^1',
 'LCOZ0^1',
 'LCOF1^1',
 'LCOG1^1',
 'LCOH1^1',
 'LCOJ1^1',
 'LCOK1^1',
 'LCOM1^1',
 'LCON1^1',
 'LCOQ1^1',
 'LCOU1^1',
 'LCOV1^1',
 'LCOX1^1',
 'LCOZ1^1',
 'LCOF2^1',
 'LCOG2^1',
 'LCOH2^1',
 'LCOJ2^1',
 'LCOK2^1',
 'LCOM2^1',
 'LCON2^1',
 'LCOQ2^1',
 'LCOU2^1',
 'LCOV2^1',
 'LCOX2^1',
 'LCOZ2^1',
 'LCOF3^1',
 'LCOG3^1',
 'LCOH3^1',
 'LCOJ3^1',
 'LCOK3^1',
 'LCOM3^1',
 'LCON3^1',
 'LCOQ3^1',
 'LCOU3^1',
 'LCOV3^1',
 'LCOX3^1',
 'LCOZ3^1',
 'LCOF4^1',
 'LCOG4^1',
 'LCOH4^1',
 'LCOJ4^1',
 'LCOK4^1',
 'LCOM4^1',
 'LCON4^1',
 'LCOQ4^1',
 'LCOU4^1',
 'LCOV4^1',
 'LCOX4^1',
 'LCOZ4^1',
 'LCOF5^1',
 'LCOG5^1',
 'LCOH5^1',
 'LCOJ5^1',
 'LCOK5^1',
 'LCOM5^1',
 'LCON5^1',
 'LCOQ5^1',
 'LCOU5^1',
 'LCOV5^1',
 'LCOX5^1',
 'LCOZ5^1',
 'LCOF6^1',
 'LCOG6^1',
 'LCOH6^1',
 'LCOJ6^1',
 'LCOK6^1',
 'LCOM6^1',
 'LCON6^1',
 'LCOQ6^1',
 'LCOU6^1',
 'LCOV6^1',
 'LCOX6^1',
 'LCOZ6^1']



data,message = ek.get_data(instruments ,fields)
data1,message = ek.get_data(instruments[:150] ,fields)
data2,message = ek.get_data(instruments[150:] ,fields)





eikon-data-apiapipython api
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.

Hi @eddy_de_groot

I just tested and replicated the same behavior. In fact, if I increase your :150 to :278 it works. Changing to :279 fails.

I've reported the issue to the development team.

Hi Nick, we're one month later, any information on this so far?

Hi @eddy_de_groot

The engineering team have confirmed and identified issues with the processing of this request. I've reached out again to get a status - will update here when I hear back.

1 Answer

· Write an Answer
Upvotes
Accepted
24.4k 53 17 14

Hello @eddy_de_groot

Sorry for the late reply. Unfortunately, the product team confirms that the solution is to break down the request into chunks.

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.

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.