-
How to obtain a list of company's peers, in Excel, with formulas?
Hello, I am looking for a way (a formula, hopefully) to obtain a list of tickers of companies that constitute peers of a given company - in Ms Excel with Refinitiv Workspace, using formulas (or VBA) rather than manually clicking through the Peers app. This needs to be done for a number of companies, so it cannot be done…
-
Extracting multiple historic relative valuation ratios via Eikon API (python)
Hi, I'm hoping someone may be able to help me with the following issue. I'm new to python so this may seem like a novice request. Apologies in advance. I wish to extract relative valuation data (P/E, P/B, P/S, EV/EBITDA - all TTM) on all S&P500 constituent stocks for the period 2006-2021 into a table on python. What is the…
-
API Is it possible to obtain company peers by specific criteria?
Hi all I am currently using the Python API to obtain peer companies for given instruments. Is there a possibility to obtain peers based on specific criteria. I am currently only able to obtain the Starmine peers but would be interested in industry peers from a given region. Regards Phil
-
How can I extract the "Refinitiv Competitor" value of StarMine peers in Python API ?
Hi, I would like to access the "Refinitiv Competitor" field of the peers analysis (cf image below) within the Python API. Is this possible ? Thanks,
-
How to use Eikon API to retrieve the peers list
Hi Team, I want to find out if we can use the API to pull in a list of names who would be considered a peer group for a stock. Eg) See peers list circled in the lower right for the company Core Laboratories (CLB). Thanks, Bingsen
-
How to retrieve peers multiple mean/median for a list of companies at given date
I have a csv file containing the list of RICs and specific date for each RIC, like this: I want to retrieve the mean and median multiple (P/E, EV/EBITDA) for each company at its specific date, and I've written the following code: df=pd.read_csv(loc) dataset=[] df2=df["ticker"].values.tolist() df3=df["date"].values.tolist()…
-
How to retrieve different Peer Sets and fields?
I would like to access the full data provided by the Peer Sets Manager in the Eikon Terminal through the API. I am unable to find any useful information through the Data Explorer. I have read the following posts: * How to get Peers list? * How to get peers list for a given company's RIC * [Python API] How to retrieve…
-
Is it possible to write an algorithm to find similar companies for each firm in the given sample?
Hello! I am writing a Thesis where I exploit news shocks to see the effect on the stock prices of the companies. Now I have a sample with several hundred companies and there characteristics downloaded from Eikon (treated sample). It is necessary to find a control companies to each firm in the sample, basing on different…
-
How to get Peers list?
How to reproduce in Python this Excel formula? =TR("SCREEN(U(IN(Peers("&Company!RIC&"))),IN(TR.GICSSectorCode,"""&'Peer List'!GICSSectorCode"""),CURN=USD)","TR.RICCode")