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.htmlFor more details on RSearch COM library see this tutorialhttps://developers.thomsonreuters.com/eikon-com/eikon-desktop-data-api/learning?content=806&type=learning_material_item
Try get_symbology()
You can request symbols with get_symbology function :
>>> eikon.get_symbology(["NL0000235190"], from_symbol_type="ISIN") ISIN OAPermID RIC SEDOL tickerNL0000235190 NL0000235190 4295884955 AIR.PA 4012250 AIR
Hi All, Isntead of ISIN can we use text like vodafone and get ISIN codes?
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.
get_symbology() only gives me primary RIC, what I need is not primary one, but one belonging to Frankfurt Stock Exchange(Exchange Code: FRA)
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.