Client wants to export portfolio data/file from Eikon to Python
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
16
●1 ●1 ●2
How to export portfolio data from Eikon to Python
Hello @MaeAnthea.Diaz
Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?
If so please can you click the 'Accept' text next to the appropriate reply? This will guide all community members who have a similar question.
Thanks,
AHS
Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.
Thanks,
AHS
32.2k
●40 ●11 ●20
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
@zoya faberov Thank you for the answer. I have sent an email to the client and will wait for her response. Appreciate your help.
@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)
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.
Hi Zoya, my name is Kenneth and and I am asking on behalf of Mae and the Client.
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.
32.2k
●40 ●11 ●20
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
