Is there any way in which I can code the following excel formula in python?
=RSearch("EQUITY","Search:NL0000235190 ExchangeCode:FRA","NBROWS:1")
For a deeper look into our Eikon Data API, look into:
Overview | Quickstart | Documentation | Downloads | Tutorials | Articles
Is there any way in which I can code the following excel formula in python?
=RSearch("EQUITY","Search:NL0000235190 ExchangeCode:FRA","NBROWS:1")
To add to the response by @pierre.faurel, it is however possible to use RSearch COM library in Python similarly to how Adfin Analytics COM library can be used. See https://community.developers.refinitiv.com/questions/18595/view.html
For more details on RSearch COM library see this tutorial
https://developers.refinitiv.com/en/api-catalog/eikon/com-apis-for-use-in-custom-applications/tutorials#tutorial-4-search
Try get_symbology()
get_symbology() only gives me primary RIC, what I need is not primary one, but one belonging to Frankfurt Stock Exchange(Exchange Code: FRA)
You can request symbols with get_symbology function :
>>> eikon.get_symbology(["NL0000235190"], from_symbol_type="ISIN") ISIN OAPermID RIC SEDOL ticker NL0000235190 NL0000235190 4295884955 AIR.PA 4012250 AIR
Can we use text instead of ISIN and get data like ISIN or sedol for the given text company
No, Symbology service can be requestd only with existing code.
Unfortunately, there isn't the equivalent of RSearch in Python API.
Can Symbology use old ISIN and return the current ISIN if a security has had a code change?
I don't think so, but if you provide an example I can check what if anything is possible.