Upgrade from Eikon -> Workspace. Learn about programming differences.

For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
39 3 3 8

Excel Add-in Formula for get_symbology()?

Hi,

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

Thanks,

TTa

pythonworkspace#technologyexcel
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Upvotes
Accepted
18.6k 85 39 63

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.

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

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!

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.