Excel Formula for Beginner

Yoojin
Yoojin Newcomer
in Eikon COM

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.

Tagged:

Best Answer

  • Jirapongse
    Jirapongse ✭✭✭✭✭
    Answer ✓

    @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")

    1707276144624.png

    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.


Answers

Categories