question

Upvotes
Accepted
1 0 0 1

Verify validity of RICs in Excel

Hi,

I'm very new to this, I've got a long excel spreadsheet with various different instruments and their RICs and I'd like to validate using the Eikon add on their validity and instead of doing it manually one be one have a function or some VBA for that? Please recommend what do.


Thanks,

John

eikoneikon-com-apiricsexcel
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.

1 Answer

Upvotes
Accepted
39.3k 76 11 27

@John S.

This forum is dedicated to software developers utilizing Eikon APIs. The best resource for questions about using Eikon Excel is Refinitiv Helpdesk, which you can reach by calling the Helpdesk number in your country or by using Contact Us capability in Eikon.
The only certain way to find out if a RIC exists is to call it on the real-time datafeed. In Excel you can do this using =TR function and some field name that exists for all RICs, e.g. PROD_PERM.

=TR("EUR=","PROD_PERM")

In the above you can use cell references in =TR function arguments, which allows you to quickly create these formulas for your entire list of RICs. E.g. if you have the RIC in cell A1 you can use

=TR(A1,"PROD_PERM")

Or if you have a list of RICs in the range A1:A10, you can use

=TR(A1:A10,"PROD_PERM")

If the above function returns data for the given RIC you know the RIC exists and you're entitled to view real-time data for it. If the function returns "The record could not be found", the RIC does not exist. If the function returns "Access Denied: User req to PE(...)", the RIC exists, but you're not entitled to view real-time data for it. If you have a large list of RICs, for some of them the function may return "A20: Aggregate item limit exceeded." This means you have exhausted the max number of simultaneous real-time data subscriptions you can have. In other words the list of RICs is too long to be retrieved in one go. You need to split it into chunks and validate each chunk separately.

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.