Investor's portfolio data retrieval
I would like to analyze portfolios of institutional investors based in a given location (e.g. country) using the built-in formula in excel or by downloading the data from the web.
For a list of investors (could exceed 1000 Perm Ids) -> for each investor find all/major equity holdings by firm ID (RIC, ISIN, and or any other id), detailed sectors of the firm (GICS and or TBR Sector - as detailed as possible), percentage of the investment portfolio of the investor held in each firm, the market value of the firm, the value held by this investor in the firm as fields. If the list is too big, I would like to focus on holdings only above a certain threshold by % of the portfolio (e.g. all holdings larger than 0.1%).
I found two ways of doing it: by getting investors from the firm side using the "Single Security level Consolidated Ownership Overview" template and from the side of investors using the "Investor Holdings Analysis with Sector Summary" template.
What I would like to have in the formula is a combination of both, based on the description above. The problem is that I am not sure when certain commands pull the information for the investor or the firm.
For example, I would like to use the following formula as a start:
=TR($A$4:$A$836,"TR.SecurityOwnedRIC;TR.InvestorValueHeld;TR.InvestorSharesHeld;TR.SecurityName","Curn=USD CH=Fd SORTD=TR.InvestorValueHeld Null=ZERO",$C$4)
Regarding this, the following questions arise:
1) I would like to add to this formula the percentage of the investor's portfolio invested in this firm. Using your template, I found "TR.ConsHoldPctPortfolio".
If I insert it in the formula (there is no specification of "Investor"), how do I know it corresponds to the original identifier of the investor and to the respective firm by its id?
3) I would also like to add Granular sector information on the firms (constituents of the portfolio) and the market cap of each firm in the portfolio
4) In addition, I would like the formula to repeat ID numbers during the call to see which firms correspond to which investors' IDs.
5) Also, I would like to request the information as of a specific date in the formula.
Does the function TR.HoldingDate corresponds to the investor or the firm?
I would very much appreciate your help!
Best Answer
-
Hi @eressourcen,
This forum is dedicated to software developers using Refinitiv APIs. The moderators on this forum do not have deep expertise in every bit of content available through Refinitiv products, which is required to answer content questions such as this one.
The best resource for the content questions is the Eikon support team, which can be reached by submitting queries through MyRefinitv. The support team will either have the required content expertise ready available or can reach out to relevant content experts to get the answer for you.
Thanks,
0
Answers
-
Hi @eressourcen , did you ever figure out how to do this? Trying to do the same thing now but struggling. Please reach out if you can help!
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 中文论坛