question

Upvotes
Accepted
the.swiss avatar image
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.

raksina.samasiri avatar image   raksina.samasiri

hi @the.swiss ,

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

wasin.w avatar image   wasin.w

<AHS>

Case 11470587 is closed with the following resolution:

After a collaboration with our Product Specialist, they confirm that it's not possible to retrieve portfolio/lists metadata using TR fields / Eikon Data API.
wasin.w avatar image   wasin.w

Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.

Thanks,


AHS

2 Answers

· Write an Answer
Upvote
Accepted
Gurpreet avatar image
21.9k ●58 ●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.

the.swiss avatar image the.swiss
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 avatar image raksina.samasiri the.swiss

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 avatar image wasin.w the.swiss

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
john.tsai avatar image
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.