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:
Please let us know which Excel add-in that you are using.
Hi @mpanas ,
Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?
If so please can you click the 'Accept' text next to the appropriate reply? This will guide all community members who have a similar question.
Thanks,
AHS
Hi,
Please be informed that a reply has been verified as correct in answering the question, and marked as such.
Thanks,
AHS
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:.
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.
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.
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
