Excel Add-in Formula for get_symbology()?

tta
tta
in Eikon Data APIs

Hi,

I was wondering if there an Excel formula equivalent to the function get_symbology() in the Python API?

Thanks,

TTa

Tagged:

Best Answer

  • nick.zincone
    nick.zincone
    Answer ✓

    Hi @tta

    Have you tried using the "Formula Builder" within Excel? I did try to perform a symbology lookup for a company and did get some results with this formula:

    =@RDP.Data("MSFT.O","TR.CUSIP;TR.ISIN;TR.SEDOL;TR.CDSRefEntTicker","CH=Fd RH=IN")

    There may be another way but the best resource is the helpdesk within Workspace. You can access the "Get Help & Support" (F1) option and they should be able to provide/confirm symbology lookup capabilities.

Answers

  • tta
    tta
    Thanks, this works.

    Very sorry for the delay as my Excel have some issues loading the Add-in.

    Thanks again and appreciate the help and support!

Categories