@liv.i.lamoy

RSearch function does not return ISINs. You can use TR.CommonName field as criteria in Screener expression, e.g.

=@TR("SCREEN(U(IN(Equity(active,public,primary))/*UNV:Public*/), Contains(TR.CommonName,""Apple Inc""), CURN=USD)","TR.CommonName;TR.ISIN","curn=USD RH=In CH=Fd")

Follow the Screener wizard to explore the options and help you construct Screener expression that fits your use case. To open the Screener wizard click on the Screener button under Refinitiv Eikon tab in Excel ribbon.

Alternatively you can use RSearch function to return the RIC and then convert the RIC to ISIN using =TR function with TR.ISIN field, e.g.

=TR(A1,"TR.ISIN")

In the above A1 is the reference to the cell containing the RIC returned by RSearch.

Hi @liv.i.lamoy,

Are you looking for something like this:

 ek.get_symbology(['XS2262853422', 'XS2252513713'], from_symbol_type="ISIN")

Hi,

Thanks for your quick reply. Not exactly, it looks like you are using Python or some similar program, while I am using Excel with the Refinitiv Eikon add-in. I want to use Rsearch in a similar way to the previous question I shared, e.g.,

Is it possible to look up the ISIN-code (the ticker code would also be helpful) using the company name in a similar way to how you can look up RIC-codes using the Rsearch function?

Hi @liv.i.lamoy,

Sorry, misunderstood. Have you tried using the Screener app within Excel?

Which is effectively this formula:

 =TR("SCREEN(U(IN(AAPL.OQ)/*UNV:Public*/))","TR.CommonName;TR.ISIN;TR.CommonName","curn=USD RH=In CH=Fd")

Refer to this question as well: https://community.developers.refinitiv.com/questions/49094/convert-tickers-to-rics-with-excel.html

I have, but it did not seem like I could reference cells with company names to look up the ISIN-codes or tickers using this app like with Rsearch. How would you reference cells in the Screener app?