question

Upvotes
Accepted
3 0 1 4

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

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

python apifundamental-datawatchlistportfolio-management
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvote
Accepted
22.6k 59 14 21

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.


icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Thanks Gurpreet

As mentioned in my question, that I already do.

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

Alfred

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.

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.

Upvotes
1 0 0 0

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

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.