question

Upvotes
Accepted
1 0 0 1

Get RIC or ISIN from company name

Using EIKON with Excel, i want to retrieve either RICs or ideally ISINs for a large number of companies. Now, what I could do is using the "build formula" tool to get the codes manually by typing in the companies' name and selecting the right one from the search suggestions, usually the top hit. I would like to automate this process. Simply selecting the cells with the companies' names as instruments does not work.


Thanks in advance.

eikoneikon-com-apiexceldatastreamisinformula-builderric
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

Upvotes
Accepted
56.2k 145 45 65

@research9

Sorry about the issue that you are facing.

You can refer to the COM APIs for use in Microsoft Office.

The COM APIs can be used with Visual Basic for Applications (VBA), VB, C++, and various other programming languages that can interact with COM.

You can try RSearch to search for instruments.

1667196942428.png

You can also refer to Tutorial 7 - Instrument Search - RSearch for more information.

I hope that this information is of help


1667196942428.png (19.6 KiB)
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.