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?
This 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.