Why do I get a null RIC returned?

neil.gallagher
neil.gallagher Newcomer
in DSS

Hello

A fairly basic question probably but I have just started using the API. In some cases I get a null value for RIC when extracting Terms and Conditions. e.g. SEDOL "7657904" is requested. Are there any rules on when a RIC might be null?

Thanks

Neil

Tagged:

Best Answer

  • Christiaan Meihsl
    Christiaan Meihsl LSEG
    Answer ✓

    Answer part 2 (only 2 images are allowed per answer, sorry):

    @neil.gallagher,

    Clicking on More Results delivers another contributed RIC, XS0174443449=JPML:

    image

    So, using Eikon we found a delisted equity, and an active government bond.

    Why were these RICs not returned by your T&C request ?

    I am not a data expert, but as far as I know, a T&C request will not return a delisted RIC. Even though DSS is not a historically oriented product like TRTH, some calls will return historical RICs, if you add the following options to the IdentifierList in the T&C query:

    "ValidationOptions": { "AllowHistoricalInstruments": true },
    "UseUserPreferencesForValidationOptions": false

    But for this particular Sedol and request it will not deliver more results.

    Note: allowing historical instruments can also be set by default in the user preferences.

    Absence of results could also be due to data coverage.

    You can check the data coverage in the Data Content Guide.
    In tab Field Descriptions, filter the data to display in column C only the Report template Terms and Conditions, and in column D the Field Name RIC. Then scroll to the right to see the data coverage per asset class (y indicates coverage, n is for absence of coverage). Again, not being a data expert I'm not sure where this particular government bond (which is an FRN (floating rate note)) fits in, maybe it will be obvious to you.

    image

    To conclude: I'm not sure why this particular government bond was not returned. Maybe it is because it is contributed data, or because this type of instrument is not covered. If you want to check this in more detail, the best and speediest way to receive an answer is to open a content-related enquiry via My Account or to call the Thomson Reuters Help Desk directly.

    I hope this helps.

Answers

Categories