-
Own2InvHldgTO OwnTurnover Calculation
In the QA Direct module Ownership V2, there is the table Own2InvHldgsTO: Ownership Investor Holdings Percent ("This table contains information on the volume of shares traded as a percentage of total shares held in an investor's portfolio"). How exactly is this calculated? Is is the sum of the absolute values of the change…
-
TR.FreeFloat call timing out
I'm trying to query data for about 500 RICs, but here are the first 5: 'A.N', 'AABA.OQ^J19', 'AAL.OQ', 'AAP.N', 'AAPL.OQ' if i use this formula: ld.get_history( universe=ok_tickers, fields=['TR.FreeFloat'], start=s, end=e, interval="1D" ), the query times out as it takes too long to queryhence i am trying to look for an…
-
Downloadding Ownership data for US listed REITs
Dear Sir/Madam, I am a PhD student in the REP department at University of Reading, currently working on a research project that requires historical investor ownership data for European and US-listed Real Estate Investment Trusts (REITs). Our university provides access to LSEG data, and I have been attempting to use…
-
How I can download the following data for multiple companies (approximately 60,000) over a period o
I am reaching out to ask how I can download the following data for multiple companies (approximately 60,000) over a period of 20 years in an automated way using the Codebook. I want to download information on Institutional Ownership. More specifically the information marked in yellow in the screenshot bellow. Could you…
-
Quarterly passive ownership data
Hi, For an academic research I would like to retrieve quarterly data (for selected stocks) representing the percentage of shares held passively. Since I have no previous experience with Workspace I could use some help on how to do this. I tried building a formula via the Excel add-in but couldn't find the correct datatype…
-
ETF Ownership of equity
Hi, I am currently looking for a way to retrieve the % of outstanding shares held by ETFs of a single equity. I know that I can do this manually by looking at the Fund Ownership of an individual equity, however, I am looking at 150 equities over the past 20 years on a monthly basis. Thus, doing it manually is not an…
-
Institutional ownership data/ratios
Hi For my thesis, i am trying to gather monthly or quarterly institutional ownership data and ratios on US stock on a long time frame (preferably 1980-now). However, I have been working with the following python code, but are unable to as I do not have access to the product tr_13f which it is based on:…
-
OWNERSHIP DATA BY TYPE AND COUNTRY: EIKON API FOR PYTHON
Dear Developer Community, I am trying to access ownership data. For each firm-year, I seek PctOfSharesOutHeld by investor type in a particular country. I need guidance with the required modificaitons in the following code, I think this requires sum of PctOfSharesOutHeld by InvestorType and by InvAddrCountry. Please guide…
-
holdings data on the ultimate parent level
I'm interested in extracting holdings data of securities (say "AAPL.O" as an example) via the get_data() function of the LSEG Data Library. Using fields such as "TR.HoldingsDate, TR.InvestorFullName, TR.SharesHeld, TR.SharesHeldValue, TR.FilingType" gives me the holdings on the consolidated level. This means I get separate…
-
Phyton API - ScopeError: Insufficient scope for key
I am doing PhD at ESCP Paris. I want to retrieve ownership data for one of my research. I am using the LSEG data library for Python, following the tutorial on GitHub () However, when running the get_data() method, I got the error message: ScopeError: Insufficient scope for…
-
Asking for help with ownership data
Hi there I want to retrieve ownership data for one of my research, I got the error message as follow: ScopeError: Insufficient scope for key=/data/ownership/v1/views/consolidated/breakdown, method=GET. Required scopes: {'trapi.data.ownership.basic'} OR {'trapi.data.ownership.adv'} OR {'trapi.demo-access'} Available scopes:…
-
I want to download ownership structure data of multiple firm. I have tried several ways through Scre
-
Ownership data Delisted companies for specific date
Hi guys, I have a list of delisted companies that I got with the Deal Screener. It looks like this: For these companies I would like to know the ownership structure before the delisting announcement date (for a specific date!). The problem I have is as follows. I can add the ticker, but if I want to use something like…
-
Voting Right & Cashflow Rights Ultimate Owner
Hello everyone, I have the following problem. I want to identify the ultimate owner of a company. For this ultimate owner I want to calculate the cash flow and the voting rights. It is very likely that there is no specific variable for this. However, is there a way to see the voting rights and the cash flow rights for the…
