EURDEPO= returning empty rows in Python

I need to access a full list of RICs contained in EURDEPO= which is displayed in Excel as well as Eikon but in Python there is no rows returned. No matter how many fields are requested. Can someone try and get back ASAP? Need to run for many other currencies so need to be generic, also if there is an alternate suffix available which works for all currencies and say XAU as well. Thanks
Best Answer
-
The additional RICs for the remainder of the tenors in EURDEPO= are under a seperate RIC; 1#EURDEPO= , which is referenced on field LONGPREVLR of EURDEPO= . In Eikon Excel the =TR() function takes care of all this referencing behind the scenes to create a seemless chain of tenors . We will raise with the dev team to see what could be done in Eikon DAPI to more streamline this data retrieval. For most chains this is not an issue since they are fully logicized, but with some of these legacy RICs, they don't all have the current logic in place.
0
Answers
-
Thank you for your inquiry Shahid. EURDEPO= is not a true chain RIC (i.e. doesn't list all the RICs contained in EURDEPO= on a single RIC field. Behind the scenes it is assigning each sub-RIC to its own field .... "LONGLINK1", "LONGLINK2" .... See below screenshots and solution,,,, You basically need to bring in the fields and assign them to a list variable that you can then call via get_data(). Hope this helps.
EURDEPO, e = ek.get_data(['EURDEPO='],
['LONGLINK1',
'LONGLINK2',
'LONGLINK3',
'LONGLINK4',
'LONGLINK5',
'LONGLINK6',
'LONGLINK7',
'LONGLINK8',
'LONGLINK9',
'LONGLINK10',
'LONGLINK11',
'LONGLINK12',
'LONGLINK13',
'LONGLINK14'])
RICs = EURDEPO.iloc[0].tolist()
RICs
0 -
Thanks @James, but I see EURDepo has 24 tenors and here only see 14 i.e: upto 8m
How do you get the remaining ones in python?
The REF_count also says 14, how is excel managed to get beyond 14? I need to do the same in Python
0 -
Hello @shahid.mehboob,
Would like to add to the answers by @James.Perkins that chains (and this RIC is a chain RIC) can be very large, and their nature is iterative.
When un-parsing a chain, one needs to "walk the chain" until LONGNEXTLR becomes empty.
This previous discussion of how to do it in Python may be of interest, and this article discusses how a chain is structured and processed.
0
Categories
- All Categories
- 6 AHS
- 36 Alpha
- 166 App Studio
- 6 Block Chain
- 4 Bot Platform
- 18 Connected Risk APIs
- 47 Data Fusion
- 34 Data Model Discovery
- 684 Datastream
- 1.4K DSS
- 613 Eikon COM
- 5.2K Eikon Data APIs
- 10 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- 3 Trading API
- 2.9K Elektron
- 1.4K EMA
- 248 ETA
- 552 WebSocket API
- 37 FX Venues
- 14 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 23 Messenger Bot
- 3 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 60 Open Calais
- 275 Open PermID
- 44 Entity Search
- 2 Org ID
- 1 PAM
- PAM - Logging
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 22 RDMS
- 1.9K Refinitiv Data Platform
- 630 Refinitiv Data Platform Libraries
- 4 LSEG Due Diligence
- LSEG Due Diligence Portal API
- 4 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.2K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 12 World-Check Customer Risk Screener
- 1K World-Check One
- 46 World-Check One Zero Footprint
- 45 Side by Side Integration API
- 2 Test Space
- 3 Thomson One Smart
- 10 TR Knowledge Graph
- 151 Transactions
- 143 REDI API
- 1.8K TREP APIs
- 4 CAT
- 26 DACS Station
- 121 Open DACS
- 1.1K RFA
- 104 UPA
- 191 TREP Infrastructure
- 228 TRKD
- 915 TRTH
- 5 Velocity Analytics
- 9 Wealth Management Web Services
- 86 Workspace SDK
- 11 Element Framework
- 5 Grid
- 18 World-Check Data File
- 1 Yield Book Analytics
- 46 中文论坛