How to access all portfolios, monitors, lists through RDP API (in python)

the.swiss

I may have overlooked some documentation but ... here is what I do and try to do

1. I manage my portfolios, monitors and watch lists in WORKSPACE (app, on Windows and Mac OS)
2. I'd like to access a complete list of all those items in python, that is something like:
   ek.get_data('PORTFOLIO([ ALL ],[PORTFOLIO.CURRENCY, PORTFOLIO.BENCHMARK, ...])
   or
   ek.get_data('LIST([ ALL ])

For the sake of clarity, I'd like information on the portfolios, lists, monitors and not their content, the latter I do already having to maintain a list in python manually.

There is an EXCEL export button in WORKSPACEs' PAL. However, that only dumps

Portfolio Name Portfolio Code Owner Last Modified Date

And not a distinction between portfolio, monitor and list.

Besides, I don't like workarounds with EXCEL.

Any ideas?

Many thanks

Alfred

Gurpreet

Hi @the.swiss,

As answered in this question, you can get the data for a portfolio using get_data API call, once you know the portfolio code. If this is not what you want, I would recommend that you reach out to Eikon support via Eikon->Help->Contact Us, and describing your requirement in full detail.

the.swiss

https://community.developers.refinitiv.com/discussion/comment/96163#Comment_96163

Thanks Gurpreet

As mentioned in my question, that I already do.

I am looking at getting the portfolio codes themselves (plus associated data).

Alfred

raksina.samasiri

https://community.developers.refinitiv.com/discussion/comment/96176#Comment_96176

hi @the.swiss ,

The moderators on this forum do not have deep expertise in every type of content available through Refinitiv products. Such expertise is available through Refinitiv Helpdesk. If the Helpdesk can show you how to retrieve it using =@TR formula in Eikon Excel, then the moderators on this forum can help you translate it into the get_data method in the Eikon Data API call. Refinitiv Helpdesk can be reached via MyRefinitiv and you may request from them the =@TR formula in Eikon Excel which can be used to retrieve the data you would like to get.

However, for this case, case number 11470587 was raised on your behalf and the support team is going to contact you soon for providing information.

wasin.w

https://community.developers.refinitiv.com/discussion/comment/96176#Comment_96176

Hello @the.swiss

The support team confirms that it's not possible to retrieve portfolio/lists metadata using TR fields / Eikon Data API.

Hope this helps.

john.tsai

For portfolio:

df, err = ek.get_data(

instruments = ['Portfolio(CustomESGScoresExample)'],

fields = ['TR.PortfolioConstituentName','TR.PortfolioWeight','TR.PortfolioShares']

)

display(df)

For MONITOR list:

df,e = ek.get_data('monitor("NameOfMonitorList")',['TR.RIC'])

ric_lists = df['Instrument'].tolist()

For Lists:

df,e = ek.get_data('list("NameOfList")',['TR.RIC'])

ric_lists = df['Instrument'].tolist()