Retrieve ISIN from company name using Rsearch

liv.i.lamoy
liv.i.lamoy
in Eikon Data APIs

Hi,

I am interested in doing something similar to what is done in this question: https://community.developers.refinitiv.com/questions/23220/ric-symbol-from-stock-name.html, but instead of retrieving the RIC-code I want to search for the ISIN-code. I was able to retrieve RIC-codes using the answer in the question, but am not able to find what criteria can be included in an Rsearch request anywhere, as all links in related questions about the Rsearch function are outdated.

I am using Refinitiv Eikon - Microsoft Excel just like the user that asked the above question. I hope someone is able to help.

Tagged:

Best Answer

  • Alex Putkov.1
    Alex Putkov.1
    Answer ✓

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

Answers

  • nick.zincone
    nick.zincone

    Hi @liv.i.lamoy,

    Are you looking for something like this:

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

    10881-ahs.png

  • liv.i.lamoy
    liv.i.lamoy

    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., 10891-image.png

    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?

  • nick.zincone
    nick.zincone

    Hi @liv.i.lamoy,

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

    10876-image.png

    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

  • liv.i.lamoy
    liv.i.lamoy

    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?

Categories