Verify validity of RICs in Excel

John S.
John S. Newcomer
in Eikon COM

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

Tagged:

Best Answer

  • Alex Putkov.1
    Alex Putkov.1 ✭✭✭✭✭
    Answer ✓

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

Categories