How to export portfolio data from Eikon to Python

MaeAnthea.Diaz

Client wants to export portfolio data/file from Eikon to Python

zoya faberov

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

MaeAnthea.Diaz

https://community.developers.refinitiv.com/discussion/comment/86847#Comment_86847

zoya faberov Thank you for the answer. I have sent an email to the client and will wait for her response. Appreciate your help.

MaeAnthea.Diaz

https://community.developers.refinitiv.com/discussion/comment/86847#Comment_86847

@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)

zoya faberov

https://community.developers.refinitiv.com/discussion/comment/86861#Comment_86861

@MaeAnthea.Diaz ,

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.

KennethCedric.Gonzales

https://community.developers.refinitiv.com/discussion/comment/86862#Comment_86862

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.

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'])
because "Units/PAR" is not working for example. A list would be really useful.

zoya faberov

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