Excel Formula for Beginner

Yoojin

I'm trying to do a couple of very simple tasks in Excel: 1. retrieve a RIC based on ISIN and 2. retrieve GICS industry group based on the RIC (I'm not even sure if there is a way to retrieve the industry group from ISIN).

Currently, I would first use Build Formula to grab RICs. An example of formula looked like =TR($L$12,"TR.RIC","CH=Fd RH=IN",M13. Then I would manually type in =TR($L$12,"TR.GICSIndustryGroup") in a different cell using the cell reference. However, I don't know how to apply this last formula to other cells. So if there's a list of RICs in A1:A25, then I want to populate the GICS industry group for each of the RIC. I can't seem to drag the formula down so the cell reference dynamically applies to the next cell while keeping the formula, so I've been manually typing the same formula while only changing the cell reference.

If you could walk me through like I'm five, that would be amazing. I'm very new to this.

Jirapongse

@Yoojin

Thank you for reaching out to us.

As fas as I know, it can retrieve both RIC and industry group from ISIN within one formula.

For example:

=TR("US4592001014","TR.RIC;TR.GICSIndustryGroup")

However, for the questions regarding Eikon Excel, please contact the Eikon support team directly via MyRefinitiv. The support team can help you generating and verifying the Excel formulas.

Yoojin

Thank you. I'll reach out to the support team.