-
I am looking to get institutional ownership % of a list of 1500 equities for which I have RIC codes.
Am I able to get this data quarterly from 2009-2025? and am I able to do it through the excel extension?
-
Ownership Contact Email Address
Why are there certain companies wherein Contact Email Address is not aligned in Python. Sample companies are OILI.NS’ , ‘ASPN.NS. Data is aligned in both excel and product. Code used : import refinitiv.data as rd rd.open_session() df = rd.get_data( universe = ['OILI.NS'], fields = [ 'TR.FirmInvestorId(SDate=2025-08-31)',…
-
How to get Insider's ownership for a specific date for a panel of RIC?
I am trying to collect insiders ownerhsip and role as of 31 december of each year (2018-2022) for a list of RICS but cannot find any data. What is the proper way to download them? Best regards,
-
Accessing Ownership Data via WS Codebook - LSEG Data Library
Client Name: Federico Vicentini | Case 15406907 Account: Graduate Institute of International Development and Studies Product: WS For Students Query: I am trying to use the Codebook App to utilize the LSEG Data Library to access Ownership data (to which I have access through Workspace). Unfortunately, I receive a 403 error…
-
Question about OwnTypeCode in Global Ownership and Institutional (13F) Holdings Database
Dear platform users, I have access to the Global Ownership and Institutional (13F) Holdings database. While working with the database, I encountered a question regarding the definition of one variable. In the Owner Information dataset, the variable OwnTypeCode serves as the owner type identifier. However, the values (e.g.,…
-
family-controlled firms
Could you please let me know how I can download ownership structure data on companies, in order to verify whether they are family-controlled?
-
Is it possible to please send a Python notebook of this process?
Query: Is it possible to please send a Python notebook of this process? Can you please help us with the Python Code for the below. Initial Query: is there an API for top 10 shareholders of a stock? in excel. Resolution Provided to the Client. i) To get the top 10 list of a company's shareholders per shareholding percentage…
-
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…
