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 characteristics such as industry, size, country, etc. It will be very painful to do it manually, i.e. using criteria search.
I know that i is possible to retrieve all peers for a company using Python, but I am not sure whether they will be good as a control companies. Ideally, I want to write a function that has some firms characteristics in input and gives me list of companies which satisfies these criteria (+- some allowed deviation).
Could you, please, advice me some way how to do it algorithmically?
Thank you very much!
Nikita
Best Answer
-
@i-sergeeich you need to take a look at the screener app that does exactly that. A screener query/expression can then be exported into either Excel or Python. So:
- Go to Eikon Excel > Thomson Reuters > Screener
- Select criteria and preview the output
- Once you are done click on 'Insert Screen' which is going to paste the screener query into your spreadsheet
- Copy the 'Universe' parameter of the =TR function into your Python code and remove double quotes
- Use the query as an input to your get_data function
Hope this helps!
1
Answers
-
@Zhenya Kovalyov, I am so so sorry for the long answer. I did a mistake, so I am collecting the sample again and haven't tried the solution yet. Therefore, I couldn't answer about the positive results. Could I leave the question open just in case something will go wrong? Thank you very much for the help!
0 -
I sincerely apologise for no answer, I wrote the reason below (see reply to Evgeny post). Please, if it is possible, leave the question open. I will report about the results as soon as possible. Thanks!
0 -
@i-sergeeich sure, it is a community forum, it's going to stay open until you accept it as the correct answer.
0 -
@Zhenya Kovalyov, thank you very much! It works and I received excellent for my thesis..)
0
Categories
- All Categories
- 6 AHS
- 39 Alpha
- 161 App Studio
- 4 Block Chain
- 4 Bot Platform
- 16 Connected Risk APIs
- 47 Data Fusion
- 30 Data Model Discovery
- 608 Datastream
- 1.3K DSS
- 577 Eikon COM
- 4.9K Eikon Data APIs
- 7 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- Trading API
- 2.7K Elektron
- 1.3K EMA
- 236 ETA
- 519 WebSocket API
- 33 FX Venues
- 10 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 20 Messenger Bot
- 2 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 59 Open Calais
- 264 Open PermID
- 39 Entity Search
- 2 Org ID
- PAM
- PAM - Logging
- 8.4K Private Comments
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 20 RDMS
- 1.4K Refinitiv Data Platform
- 367 Refinitiv Data Platform Libraries
- 3 Refinitiv Due Diligence
- LSEG Due Diligence Portal API
- 3 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.1K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 10 World-Check Customer Risk Screener
- 990 World-Check One
- 44 World-Check One Zero Footprint
- 45 Side by Side Integration API
- Test Space
- 3 Thomson One Smart
- 1.2K TR Internal
- Global Hackathon 2015
- 2 Specialists Who Code
- 10 TR Knowledge Graph
- 150 Transactions
- 142 REDI API
- 1.7K TREP APIs
- 4 CAT
- 21 DACS Station
- 117 Open DACS
- 1.1K RFA
- 103 UPA
- 172 TREP Infrastructure
- 224 TRKD
- 886 TRTH
- 5 Velocity Analytics
- 5 Wealth Management Web Services
- 59 Workspace SDK
- 9 Element Framework
- 5 Grid
- 13 World-Check Data File
- Yield Book Analytics
- 46 中文论坛