Excel Add-in Formula for get_symbology()?

tta

Hi,

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

Thanks,

TTa

Find more posts tagged with

python

excel

workspace

#technology

Accepted answers

nick.zincone

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.

All comments

nick.zincone

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")

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!

EXPLORE OUR SITES