Formula that can pull up INPJ.J for GB00B17BBQ50 using Python API

kenley.macandog123
kenley.macandog123 LSEG
in Eikon Data APIs

How to pull RIC using ISIN and select specific market without using RSearch formula
It seems RSearch formula below in Eikon will not work in Python API

=RSearch("EQUITY","Search:'"&A2&"' ExchangeCode:"&B2&"",,)


where A2 is GB00B17BBQ50 B2 is JNB

Tagged:

Best Answer

  • Alex Putkov.1
    Alex Putkov.1 ✭✭✭✭✭
    Answer ✓

    @kenley.macandog123

    You can use RDP Library to achieve what you're looking for. The example below returns the RIC 'INPJ.J', given the ISIN 'GB00B17BBQ50' and exchange code 'JNB' as inputs.

    rdp.lookup(view=rdp.SearchViews.EquityQuotes, scope='IssueISIN', 
               terms='GB00B17BBQ50', filter="ExchangeCode eq 'JNB'", 
               select='RIC')

    For a comprehensive review of using RDP Library to access the Search service on RDP, see the article titled "Building Search into your Application Workflow".

Answers

  • zoya faberov
    zoya faberov ✭✭✭✭✭

    Hello @kenley.macandog123,

    Is

    ek.get_symbology(["GB00B17BBQ50"], from_symbol_type="ISIN",to_symbol_type="RIC")

    what you are looking for?

    Returns:

    GB00B17BBQ50 INVP.L


  • kenley.macandog123
    kenley.macandog123 LSEG

    @zoya faberov Client needs to get South Africa listed RIC which is INPJ.J


  • zoya faberov
    zoya faberov ✭✭✭✭✭

    Hello @kenley.macandog123,

    By default, Eikon Data API returns primary symbol, by specifying bestMatch false

    ek.get_symbology(["GB00B17BBQ50"], from_symbol_type="ISIN",to_symbol_type="RIC",bestMatch=False)

    you should be able to see all RICs that map to this ISIN.

    If this does not satisfy your requirement, in my understanding, an alternative approach that can be explored is to use SCREENER to define specific SCREEN expression, similar to this previous discussion thread, and apply the obtained expression via Eikon Data API python via get_data such as in this previous discussion thread.

    To help define SCREEN expression, to determine if this is feasible, suggest to contact Eikon content experts via Refinitiv Helpdesk Online -> Eikon -> Content. This forum is most helpful for API usage general questions and discussions.

Categories