Excel API version of ek.get_symbolog() in Python API?

Does someone know if there exist a formula in Excel API that does the same job as ek.get_symbolog() in Python API? I contacted with a helpdesk, but was forwarded to here.

Best Answer

  • Jirapongse
    Jirapongse ✭✭✭✭✭
    Answer ✓

    @iwasaki

    The get_symbology method converts a list of instrument names into another instrument code.

    You may need to contact the Eikon excel support team to verify which excel functions can perform the symbology conversions.

    From my finding, the =RSearch and =TR function can convert instrument codes.

    For example:

    =RSearch("EQUITY","Search:'GB00B1XZS820'","NBROWS:1",,)

    The above code uses the RSearch function to convert ISIN to RIC.

    =TR("GB00B1XZS820,GB0006731235,2005973","TR.PrimaryRICCode,TR.RIC","CODE=MULTI")

    The above code uses the TR function to convert ISIN and SEDOL to RIC.

    However, please directly contact the Eikon Excel support team via MyRefinitv (https://my.refinitiv.com/content/mytr/en/helpandsupport.html) to verify it.

Answers