Now I have a list of company names in excel (over 300), which cannot be identified by Thomson Reuters. How can I transfer these names into RIC code in excel so that I can find relevant data for these companies?
@arslan_sjnThis forum is dedicated to software developers utilizing Refinitiv APIs. The best resource for questions about using Eikon application or Eikon Excel add-in is Refinitiv Helpdesk. For expedient response contact Refinitiv Helpdesk by either calling the Helpdesk number in your country of by using Contact Us capability in your Eikon application.To answer your question, you can use Screener to find private companies by name, e.g.
=TR("SCREEN(U(IN(Private(OrgType(COM, UNK, MKP)))), Contains(TR.CommonName,""1010data""))","TR.CommonName","RH=In CH=Fd")
The row header returned by the above function is the permID for 1010data Inc.
@arslan_sjn
Is this question regarding any Refinitv API?
Yes, I hope to use Thomson Reuters Eikon to get some data about these companies. Now, I find many companies are private companies so they do not have RIC codes. Are there any formula like RSearch to find the PermID for these companies? Thank you.
Thanks so much. I will have a try.
