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.