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)
Best Answer
-
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.
0
Answers
-
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.
0 -
Hi Nick, we're one month later, any information on this so far?
0 -
Hi Nick, we're one month later, any information on this so far?
0 -
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.
0
Categories
- All Categories
- 6 AHS
- 39 Alpha
- 161 App Studio
- 4 Block Chain
- 4 Bot Platform
- 16 Connected Risk APIs
- 47 Data Fusion
- 30 Data Model Discovery
- 608 Datastream
- 1.3K DSS
- 577 Eikon COM
- 4.9K Eikon Data APIs
- 7 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- Trading API
- 2.7K Elektron
- 1.3K EMA
- 236 ETA
- 519 WebSocket API
- 33 FX Venues
- 10 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 20 Messenger Bot
- 2 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 59 Open Calais
- 264 Open PermID
- 39 Entity Search
- 2 Org ID
- PAM
- PAM - Logging
- 8.4K Private Comments
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 20 RDMS
- 1.4K Refinitiv Data Platform
- 367 Refinitiv Data Platform Libraries
- 3 Refinitiv Due Diligence
- LSEG Due Diligence Portal API
- 3 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.1K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 10 World-Check Customer Risk Screener
- 990 World-Check One
- 44 World-Check One Zero Footprint
- 45 Side by Side Integration API
- Test Space
- 3 Thomson One Smart
- 1.2K TR Internal
- Global Hackathon 2015
- 2 Specialists Who Code
- 10 TR Knowledge Graph
- 150 Transactions
- 142 REDI API
- 1.7K TREP APIs
- 4 CAT
- 21 DACS Station
- 117 Open DACS
- 1.1K RFA
- 103 UPA
- 172 TREP Infrastructure
- 224 TRKD
- 886 TRTH
- 5 Velocity Analytics
- 5 Wealth Management Web Services
- 60 Workspace SDK
- 9 Element Framework
- 5 Grid
- 13 World-Check Data File
- Yield Book Analytics
- 46 中文论坛