Discover Refinitiv
MyRefinitiv Refinitiv Perspectives Careers
Created with Sketch.
All APIs Questions & Answers  Register |  Login
Ask a question
  • Questions
  • Tags
  • Badges
  • Unanswered
Search:
  • Home /
  • Eikon Data APIs /
avatar image
Question by i-sergeeich · Jan 08, 2019 at 11:23 AM · pythoneikondata on company levelretrive similar companies

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

People who like this

0 Show 0
Comment
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Reply

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by Zhenya Kovalyov · Jan 08, 2019 at 11:48 AM

@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:

  1. Go to Eikon Excel > Thomson Reuters > Screener
  2. Select criteria and preview the output
  3. Once you are done click on 'Insert Screen' which is going to paste the screener query into your spreadsheet
  4. Copy the 'Universe' parameter of the =TR function into your Python code and remove double quotes
  5. Use the query as an input to your get_data function

Hope this helps!

Comment
i-sergeeich

People who like this

1 Show 3 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

avatar image
i-sergeeich · Jan 15, 2019 at 06:15 PM 0
Share

@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!

avatar image
REFINITIV
Zhenya Kovalyov ♦♦ i-sergeeich · Jan 16, 2019 at 04:20 AM 0
Share

@i-sergeeich sure, it is a community forum, it's going to stay open until you accept it as the correct answer.

avatar image
i-sergeeich · Jul 11, 2019 at 11:02 AM 0
Share

@Zhenya Kovalyov, thank you very much! It works and I received excellent for my thesis..)

Watch this question

Add to watch list
Add to your watch list to receive emailed updates for this question. Too many emails? Change your settings >
9 People are following this question.

Related Questions

Articles over period of time

Fixed Income Government Auction Static Data

Extracting all historical companies listed on the ASX using the Python API?

In the Eikon News API, how can I get the tags in Python?

Download historical volume for (continuation) Futures with Eikon API

  • Feedback
  • Copyright
  • Cookie Policy
  • Privacy Statement
  • Terms of Use
  • Careers
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Alpha
  • App Studio
  • Block Chain
  • Bot Platform
  • Calais
  • Connected Risk APIs
  • DSS
  • Data Fusion
  • Data Model Discovery
  • Datastream
  • Eikon COM
  • Eikon Data APIs
  • Elektron
    • EMA
    • ETA
    • WebSocket API
  • Legal One
  • Messenger Bot
  • Messenger Side by Side
  • ONESOURCE
    • Indirect Tax
  • Open PermID
    • Entity Search
  • Org ID
  • PAM
    • PAM - Logging
  • ProView
  • ProView Internal
  • Product Insight
  • Project Tracking
  • Refinitiv Data Platform
    • Refinitiv Data Platform Libraries
  • Rose's Space
  • Screening
    • Qual-ID API
    • Screening Deployed
    • Screening Online
    • World-Check One
    • World-Check One Zero Footprint
  • Side by Side Integration API
  • TR Knowledge Graph
  • TREP APIs
    • CAT
    • DACS Station
    • Open DACS
    • RFA
    • UPA
  • TREP Infrastructure
  • TRIT
  • TRKD
  • TRTH
  • Thomson One Smart
  • Transactions
    • REDI API
  • Velocity Analytics
  • Wealth Management Web Services
  • World-Check Data File
  • Explore
  • Tags
  • Questions
  • Badges