By excel formula (not python), given an ADR code only (say: BABA.K), how do I get the RIC of the ultimate parent? I see the formula to get the ultimate parent code but how to get the RIC of a listed parent? (which presumably is '9988.HK' or a Shanghai RIC in this case)