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
- I manage my portfolios, monitors and watch lists in WORKSPACE (app, on Windows and Mac OS)
- 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
Best Answer
-
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.
1
Answers
-
Thanks Gurpreet
As mentioned in my question, that I already do.
I am looking at getting the portfolio codes themselves (plus associated data).
Alfred
0 -
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.
0 -
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.
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()
0
Categories
- All Categories
- 6 AHS
- 37 Alpha
- 161 App Studio
- 4 Block Chain
- 4 Bot Platform
- 16 Connected Risk APIs
- 47 Data Fusion
- 30 Data Model Discovery
- 608 Datastream
- 1.3K DSS
- 577 Eikon COM
- 4.9K Eikon Data APIs
- 7 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- Trading API
- 2.7K Elektron
- 1.3K EMA
- 236 ETA
- 519 WebSocket API
- 33 FX Venues
- 10 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 20 Messenger Bot
- 2 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 59 Open Calais
- 264 Open PermID
- 39 Entity Search
- 2 Org ID
- PAM
- PAM - Logging
- 8.4K Private Comments
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 20 RDMS
- 1.4K Refinitiv Data Platform
- 367 Refinitiv Data Platform Libraries
- 3 Refinitiv Due Diligence
- LSEG Due Diligence Portal API
- 3 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.1K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 10 World-Check Customer Risk Screener
- 990 World-Check One
- 44 World-Check One Zero Footprint
- 45 Side by Side Integration API
- Test Space
- 3 Thomson One Smart
- 1.2K TR Internal
- Global Hackathon 2015
- 2 Specialists Who Code
- 10 TR Knowledge Graph
- 150 Transactions
- 142 REDI API
- 1.7K TREP APIs
- 4 CAT
- 21 DACS Station
- 117 Open DACS
- 1.1K RFA
- 103 UPA
- 172 TREP Infrastructure
- 224 TRKD
- 886 TRTH
- 5 Velocity Analytics
- 5 Wealth Management Web Services
- 59 Workspace SDK
- 9 Element Framework
- 5 Grid
- 13 World-Check Data File
- Yield Book Analytics
- 46 中文论坛