Get list of undelying RICs from chain in excel add-in

mpanas

Hi. I am using the excel add-in to get all my data.

Is there a way to get all RICs contained in a chain RIC using the add-in?

For example I want to retrieve all RICs for NYMEX Ethylene CFR NE Asia (ICIS) Electronic Energy Futures

The chain RIC is 0#NA2A:

Jirapongse

@mpanas

You can try the Tutorial 6 - DEX2 example.

Run the Tutorial 6 - DEX2 Fundamental and request the TR.RIC field.

I tested it with the 0#.SETI. I don't have permission to access 0#NA2A:.

Jirapongse

@mpanas

Please let us know which Excel add-in that you are using.

Is it COM APIs for use in Microsoft Office?

mpanas

COM add-in for Excel.

mpanas

Thank you for your reply.

The TR.RIC returns the RIC itself again.

I want to get the list of RICs contained in this specific RIC.

Jirapongse

@mpanas

You can contact the Eikon support team directly via MyRefinitiv to verify which fields or functions in Eikon Excel that can be used to obtain the list of RICs contained in this chain RIC.

Then, I can verify if there is any equivalent method in Eikon COM.

m.bunkowski

Hi @mpanas,

I think that you need to use AdxRtChain method, the sample you can find on the same page provided earlier by @Jirapongse - Tutorial 2 - AdxRtChain