question

Upvotes
Accepted
1 0 1 1

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

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:

#technology#product#contentexcelchain-ricfutures
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

@mpanas

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

Is it COM APIs for use in Microsoft Office?

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

@mpanas

Hi,

Please be informed that a reply has been verified as correct in answering the question, and marked as such.

Thanks,

AHS

Upvotes
Accepted
78.6k 248 52 74

@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:.

1690343378052.png


1690343378052.png (91.1 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

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.

1690358189758.png

1690358189758.png (26.8 KiB)

@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.

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

Upvotes
1 0 1 1

COM add-in for Excel.

1690299165996.png


1690299165996.png (22.0 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.