Value and code retrieval using Eikon Python API
RICs.csv - the file containing a sample of 9000+ RICs (I need to run my code on a different file with 100,000 RICs, but for your experimentation purposes it will be easier to run the code on this file).
RDP Code to optimize - includes an RDP code that fails to work. Please note that I want to recover the data specifically with rdp.historical_pricing.summaries because there are some RICs whose data can only be retrieved with this code.
Here are the fields I want to recover:
- bond fields: mid yield, mid price, ask price, ask yield, bid yield, bid price, ratings, transaction volume.
- dates: 2016 Jan 1 - 2021 Dec 31
- interval: monthly
Sample Output - Eikon.csv - includes a sample output generated through the eikon library. In other words, I want to have the code with rdp.historical_pricing.summaries that retrieves output of this type because with rdp.historical_pricing.summaries might add additional data that is not being retrieved by eikon libraries (as you can see, there are several N/As in the output).
For now I would only kindly ask you to provide a sample code for the RDP library or edit mine (with rdp.historical_pricing.summaries). I solved the issue with rd.get_data myself.
Best Answer
-
Hello @MaeAnthea.Diaz ,
I have found that a very similar requirement was discussed on the dev forums before, please see this previous discussion thread.
If the issue the error that the client is facing is timeout? then as discussed in more detail in the linked thread, the approach that is likely to work best is:
- Obtain and use the latest RD library
- Partition the required list into sublists, a.k.a. "chunking"
- Request the required content for each sub-list, iterating through them and saving the result
- Assemble or concatenate the obtained results
You may wish to encourage the developer you are working with to register on dev portal, and participate in dev forums directly.
Hope that this helps
1
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
- 370 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 中文论坛