How to export portfolio data from Eikon to Python
Best Answer
-
Hello @MaeAnthea.Diaz ,
There is no "one API call" approach, please see this previous discussion thread for the detailed information.
1. One approach could be to request the list of instruments from portfolio using EDAPI python, and, also using EDAPI python, to request any available fields on the lust of instruments.
For example, I have portfolio SAMPLE_UK_LRGCORE defined:
2. Another approach could be:
1. From Refinitiv Workspace/Eikon, open Portfolio holdings into Excel
2. From Excel, Save File as CSV-formatted
3. Lastly, using EDAPI python, read CSV into pandas Dataframe the complete holdings from file:
Hope this information helps
0
Answers
-
zoya faberov Thank you for the answer. I have sent an email to the client and will wait for her response. Appreciate your help.
0 -
@zoya faberov - client responded that it worked, thank you.
Also, client wants to add the quantity and NAV with a date (let's say 18/10/2021 (inception date)
0 -
Quantity, I believe is "Units/PAR". Once they run approach 2, they should see all the content in their portfolio in Eikon.RW exported and imported into DF. I have only screenshotted the small first part of it.
0 -
Hi Zoya, my name is Kenneth and and I am asking on behalf of Mae and the Client.
Thanks for your help, do you have a list with all the fields like 'CF_NAME' (see below):ek.get_data("lists('Adventurer S&E')",['CF_NAME','ASK','BID'])
the client had a follow up question.
As per the client.
because "Units/PAR" is not working for example. A list would be really useful.0 -
Hello @KennethCedric.Gonzales and @MaeAnthea.Diaz
I would like to suggest to encourage the client developer to register with developers portal and and use developers forums directly, to search many available answers and participate in questions and discussions directly, as well.
The available fields and how they are populated is specific to the instrument's exchange and market sector. Using Data Item Browser tool allows to examine all available fields:
, and see which of the fields are available and what values they are populated with:
next we should be able to request the fields from EDAPI python code.
Additional details and step-by-step on Data Item Browser usage can be found in article Eikon Excel Company Tearsheet in Python (Part 1)
Hope this information helps
0
Categories
- All Categories
- 6 AHS
- 37 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
- 59 Workspace SDK
- 9 Element Framework
- 5 Grid
- 13 World-Check Data File
- Yield Book Analytics
- 46 中文论坛