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 Nico L. · Apr 17, 2020 at 01:25 PM · eikonscreeneridentifierprivate equity screenerpost-ipo performance

How to match company data from Eikon's PE Screener and Eikon's Screener for public Companies

Dear Refinitiv-Community,


I would like to study impacts of venture capital financing of entrepreneurial firms on their post-IPO performance.

Questions would be like: Does the total venture capital financing volume have an impact of the post-IPO performance?

In order to examine these questions I want to use two different data soruces within Eikon.

I used the "PE Screener" or "Private Equity Screener" to collect data about the venture capital activities of entrepreneurial firms before they went public.

I used the Screener for public companies to collect data on firms that went public in the same time period.

(Only three companies for simplification)

The problem now is that I have two excel files that I want to merge and I couldn't find an identifier variable for companies that match each other between the screeners. I tried to "build" an identifier with Name, founding date, date of IPO etc. but it turned out that these variables differ between the screeners.

Does anyone have an idea to solve this problem? Like knowing an identifier that Ihave missed or another approach collecting the data?

If you need further Information on this issue, I would be happy to provide it here.

Thank you very much in advance!

All the best

Nico

screeners.jpg (152.6 KiB)
example-picture.jpg (317.7 KiB)

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.

7 Replies

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by zoya.farberov · Apr 27, 2020 at 04:02 PM

Hello @Nico L.,

For inquiries on Eikon content, if you are a customer, kindly involve Eikon Helpdesk Online. You can also dial you local Refinitiv helpdesk number and describe your content question, or from your Eikon desktop menu, select Help.

The majority of the members of this forum are developers, the moderators are API experts, we will not be able to help with involved content questions on this forum, especially ones requiring further research. An Eikon content expert with the expertise in your area of content will be assigned to help you a customer, when you open a content support case.

---

For future consideration, if you are asking a new question on API usage, you would like for this question to be immediately visible to the members of a specific API forum (Eikon Data APIs) as well as the moderators with the relevant area of expertise, ask a new question, rather then posting an answer on the existent question thread. You can refer to the existent relevant thread via a link.

---

On my side- I tried

Screener -> Private Equity Exits, Exit Type = IPO.

I see "Date Announced" and "Date Completed", perhaps this will help.

Comment

People who like this

0 Show 1 · 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
Nico L. · May 04, 2020 at 12:09 PM 0
Share

Hello @zoya.farberov,

thank you very much for your help and patience.

It did not work out. I will try to reduce the approach to a smaller market which will give me the option to roughly match the data automatically and correct it manually afterwards.

I learned a lot about the features, possibilities and limitations of Eikon, which is quite nice, so I got that going for me.

Thanks again and all the best,

Nico

avatar image
REFINITIV
Answer by zoya.farberov · Apr 17, 2020 at 04:00 PM

Hello @Nico L.,

I understand that your question is about identifying and correlating Eikon data, as returned by 2 Eikon screener requests. With this type of question, on identifying Eikon content, the best approach for a customer would be to contact Refinitiv Helpdesk Online , selecting product = Eikon, and your question will be assigned to the appropriate Eikon content expert. Or dial your local Refinitiv Helpdesk number and provide all the relevant details verbally.

This forum is intended for Refinitiv API usage, therefore most of the community members are developers, the moderators of the forum are API experts.

Comment

People who like this

0 Show 0 · 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
Answer by Nico L. · Apr 20, 2020 at 02:57 PM

Hello @zoya.farberov,

Thank you for your advise but unfortunately the helpdesk could not answer my question which brought me here.

I get your hint regarding the forum. Can you recommand a more fitting forum for this kind of question?

Thank you very much in advance.

Best regards

Nico

Comment

People who like this

0 Show 0 · 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
REFINITIV
Answer by zoya.farberov · Apr 20, 2020 at 07:11 PM

Hello @Nico L.,

This developers forum, as I mentioned is geared toward general Refinitiv API questions and discussions. We, moderators of this forum, do our best to provide the answers for such questions that are not answered by the community. The feedback we get is that the forum is very helpful to the Refinitiv developer community, it makes the job of our client developers easier. Anyone can register as a new community member, and once registered and logged in, can search and read our forums, and ask questions on the API forums, the forums are public.

For Refinitiv customers, the way to get answers to content questions is Refinitiv Helpdesk. We provide and maintain many different content sets. Upon the receipt of a content request from a customer, an appropriate Refinitiv content expert gets assigned to work on the question for as long as required to fully research the inquiry.

Consequently, there is no more fitting forum for content questions.

Is there a specific recommendation you were given by content helpdesk? Or a reason why you could not be helped? What is the content support case number you were assigned? I can try to look into this, just in case we can be of further help.

Comment

People who like this

0 Show 0 · 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
Answer by Nico L. · Apr 21, 2020 at 07:44 AM

Hello @zoya.faberov

my case number is 08561387 and I was provided with a solution I already knew: how to solve this problem manually. But the real question is, how to match a lot more companies from PE Screener and Screener for public companies by an identifier or a specific approach of extracting the data.

Unfortunately, I was told that there is no identifier and no other way to extract the data from Eikon and was told to use "TR on Demand" but the given contact does not reply to my mails so far.

So it is already super time consuming and frustrating.

I am very thankful for any help, so if you look into this and maybe have some advice or further information, it would be great. Maybe there was a misunderstanding in the correspondence.

Thank you very much in advance!

Best regards

Nico

Comment

People who like this

0 Show 0 · 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
REFINITIV
Answer by zoya.farberov · Apr 21, 2020 at 08:40 PM

Hello @Nico L.,

As a disclaimer, I am a developer, rather then an Eikon content expert.

The approach that is suggested via content inquiry should remain definitive.

From looking at the case, I agree you have understood your options correctly. You can compile the ID map between the PE Screener and general Screener results yourself, via available fields. Or you can commission a service with consultancy, where we will do the project for you, that may also be subject to availability and waiting time, and if you are interested to know more on that front, your organization's account manager may be a good contact to involve to help you.

From my looking at the Screeners in more detail, if I was designing this, I would try to run Company Website in PE Screener results to Organization Website in general Screener results, as my primary map. And any results that end up one-to-many match,I would try to disambiguate via Company Name to Company Name match.


Comment

People who like this

0 Show 0 · 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
Answer by Nico L. · Apr 27, 2020 at 10:31 AM

Hello @zoya.farberov,


Thank you very much for your much-appreciated help and suggestions!


I considered another way of matching by using the screener's private companies universe. There you have the Spotify AB with the variable Ultimate Parent ID which is the Organization Perm ID of Spotify Technology SE in the private company universe. Unfortunately, I cannot find a proper way to filter the private companies by IPO date, investment date, founding date. There is an option to filter by the variable Ultimate Parent ID but it just allows for around 10 IDs per search. I tried to work with the corresponding excel formula so that I might be able to copy the command by just changing the ID every time by VLOOKUP or something but I currently fail due to my limited excel skills.

=TR("SCREEN(U(IN(Private(OrgType(COM, UNK, MKP)))/*UNV:Private*/), (Contains(TR.UltimateParentId,""5037833896"") OR Contains(TR.UltimateParentId,""4298032874"") OR Contains(TR.UltimateParentId,""5000661471"")), CURN=USD)";"TR.CommonName;TR."&"UltimateParentId;TR.UltimateParent";"curn=USD RH=In CH=Fd")

Is it possible to change the respective ID by linking the formula to a table of the public parent companies?

Do you understand the problem and is that more of a topic for you? Or do you have any solution in mind for this problem?

Thank you for your patience and commitment!

Best regards

Nico


Comment

People who like this

0 Show 0 · 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.

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 >
10 People are following this question.

Related Questions

Screener sort and top results

How to find field names in Eikon Python API?

Port number was not identified. Check if Eikon Desktop or Eikon API Proxy is running.

error set_app_key

With which instruments and formula are 'TR.PriceClose' and 'TR.EV' linked ?

  • 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