-
How to get ownership percentage panel data through formula builder?
I want to draw a variable on the percentage of shares held by the largest shareholder at FYE for a panel sample through the excel formula builder but I could not find a variable yet that gives me this information and that I can get the panel data for. So I wanted to ask whether such a variable exists and if so, what the…
-
Eikon Data API syntax document of rd
Hi team, I can easily find the Eikon Data API syntax document in our developers community website. However, when I am using Codebook, the sample codes are using rd, just like: import refinitiv.data as rd I found that the syntax of rd are much different with the document where using ek syntax, just like import eikon as ek…
-
Query the RIC of a ticker using keywords
I have a list of company names and ticker symbols which maybe different from the correct RIC that reuters uses. For example I might say 'Reliance', but the correct RIC would be 'RELI.NS'. I'm using python API. Is there any way I can get the RIC using a keyword programmatically instead of searching manually and finding it…
-
Dividend adjusted historical prices
From what I researched in this forum, Eikon does not provide dividend adjusted historical prices. But since the posts are very old (more than 2 years old), I would like to know if such a feature was implemented since them. Using unadjusted prices for modelling is unacceptable and even free services such as Yahoo have…
-
FCF estimated data from Eikon API doesn't match WS
Hi everyone, I'm confused why the historical free cash flow estimations don't match that of Workspace? Please have a look at the screenshots below: AAPL, Free cash flow estimations from Eikon API AAPL, historical free cash flow estimations from WS In the first photo, the free cash flow estimations (Mean) are highlighted in…
-
I would like to find out if it is possible to do an API call to get daily FX information from Ref...
...intiv into Microsoft D365? I would like to find out if it is possible to do an API call to get daily FX information from Refintiv into Microsoft D365?
-
API Python Importing News Text in bulk
API Python If APPKEY is generated, does it mean I can connect to Eikon via my own Python/Anaconda environment without having to use Codebook? Could you provide a sample script to retrieve the news date, news title, news content, as well as news publisher, of Singapore financial news (news code SG AND GLOFIN) for the last 3…
-
RIC of delisted companies
Hello, I have a list of permid, e.g., ['4296383853', '4295908768'] I need to retrieve the correspnding RICs using the eikon API with python. I tried this code: df, err = ek.get_data(['4296383853', '4295908768'], ['TR.CompanyName', 'TR.RIC']) df print(df) This is what I get: Instrument Company Name RIC 0 4296383853…
-
The Average price for Datasets are wrong.
Hi, I am using Eikon with Python program for a few years. Every time, I contact 'Helpdesk', they said they have not clue about python, so I needed to ask questions on Developer site. I posted the same questions every single time, and i did not get any clear answer at all. Last time I asked, he said he does not have a…
-
API Python Query
I am currently gathering company financial data through Eikon Data API (Python). I have a situation where the only working metric for the 2500+ company identification is the company's full name. I have also tickers and 6-digit CUSIP codes (obtained from the SDC Platinum M&A Database); however, the tickers are for EU…
