Use Eikon Python Data API to call the RSearch function formula

leiy
leiy
in Eikon Data APIs

I am trying to use Eikon Python Data API to call the RSearch function to retrieve the complete list of warrants of mexican stock exchange. Here is the code I used: rt = ek.get_data('RSearch("WARRANT","RCSIssuerCountryLeaf:Mexico")', 'TR.CommonName'), but this doesn't work. Does anyone know how to make this work?

Tagged:

Best Answer

  • Alex Putkov.1
    Alex Putkov.1
    Answer ✓

    I'm afraid at the moment Eikon Data APIs do not provide criteria search capability for anything other than equities, which is available with equity screener.
    There's a COM library named RSearch, which provides the same capability as RSearch worksheet function in Eikon Excel, but unfortunately this COM library cannot be used in Python. It can only be used in Microsoft development environment (Visual Studio or VBA Editor).

Answers

  • leiy
    leiy

    Ok. I am looking at the Eikon COM API. According to the website https://developers.thomsonreuters.com/eikon-com/eikon-desktop-data-api/quick-start, the dlls are in the Eikon installation package. However, I don't see dex2.dll, rtx.dll, rsearch.dll in my Eikon installation folder. Can you please tell me where I can find them?

  • Alex Putkov.1
    Alex Putkov.1

    The easiest way to find these files is to search for them in Eikon install folder.
    The files are installed under
    ...\X\Bin\rtx.dll
    ...\X\Bin\Apps\TR.OFFICE.CORE\0.0.0.0\Bin\Dex2.dll
    ...\X\Bin\Apps\TR.OFFICE.CORE\0.0.0.0\Bin\RSearch.dll
    In the above the part of path to the dlls may begin with 'X', 'Y', or 'Z'.

Categories