Client wants to export portfolio data/file from Eikon to Python
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)
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)
