question

Upvotes
Accepted
1 1 1 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.

Hi @research9 ,

Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?
If so please can you click the 'Accept' text next to the appropriate reply? This will guide all community members who have a similar question.

Thanks,
AHS

Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.

Thanks,


AHS


1 Answer

· Write an Answer
Upvotes
Accepted
78.8k 250 52 74

@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.

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.