Hi, If I search for a given ric (GE), and go to Ownership tab. We get data like Top Investors, Investor Type, Breakdown, and Holding Concentration. I want to extract these for a company over time through a codebook in Python. How can I do that? Thank you for the help.
location=rd.get_data( universe=["GE"], fields=['TR.InstrStatLocationId.date', 'TR.InstrStatLocationId', 'TR.InstrStatLocation', 'TR.CategoryInvestorCount', 'TR.CategoryOwnershipPct', 'TR.InstrStatCatSharesHeld', 'TR.InstrStatCatShrsHldVal(Scale=6)'], parameters={'StatType': 3, 'SDate': "2024-05-01", 'EDate': "2024-07-01"}…
Already provided import refinitiv.data as rd rd.open_session() df = rd.get_data( universe = ['HSBA.L'], fields = [ 'TR.RelatedOrgId', 'TR.RelatedOrgName', 'TR.RelatedOrgType' ] ) display(df) However its only for single companies, not really sure how to do this on Codebook then, appreciate your help in advance.
Hi, I have a list of RIC. I want to fetch the frequency or interval of each. Some of them are daily, some weekly, quarterly and so on. I don't want to check one by one. What is the fastest way to have this info? is there a field to specify this. I am using eikon python API. I also use the Excel Eikon plugin.
Hello, I want to get news data from the 2000s. It seems that I need to use ek.get_news_headlines instead of rd.news.get_headlines. However, I can't figure out how to include dates in my code. It gives an error every time. For example ek.get_news_headlines(query='Topic:LSEG and Language:LEN', count=10,…
Hi, I want to fetch the historical data for below fields. What is the correct way to fetch the historical data for a specified Date from history? Please find below the fields and code to replicate the results- fields =…
How to get a list of all levels of a company structure (TREE) in API? Here is the sample code: df = rd.get_data('HSBA.L', ['TR.RelatedOrgId','TR.RelatedOrgName','TR.RelatedOrgType','TR.UltimateParent','TR.HeadquartersCity']) In this example i only get the entities directly below HSBA.L and not thier entities also (the full…
Can codes be used in Rics or tickers?
...or another endpoint ? How to get the value of field "TR.FundLaunchDate" via API PLAYGROUND using searchlight or lookup or another endpoint ? For example I use this EndPoint : https://api.refinitiv.com/discovery/searchlight/v1/ with this Body Request { "View": "FundQuotes", "Filter": "(AssetState ne 'DC' and…
I use Eikon in Excel. 1. How can I get a list of all Korean mutual funds? Even though I used the code below, an error occurred and I was unable to obtain data. =TR("FDS_ALLFUNDS", "RIC,Name", "COUNTRY=South Korea;FUNDTYPE=Mutual Fund") 2. How can I get 10 years of quarterly fund ownership portfolio reports for all the…
It looks like you're new here. Sign in or register to get started.