=FINR Not being Returned

On DSS when I search for RIC for the ISIN US207932AB01 it retunes the two instruments below, both instruments have the same ISIN but different identifiers.

When I try and run a historical request via the DSS REST API using the ISIN 'US207932AB01' it only returns the instrument on the EJV source and not both, which I thought it would have, If I run a similar request for the ISIN 'GB00BH4HKS39'; I get several records returned on various sources.

Without being able to get the RIC from the ISIN we can't get the Time and Sales data.

Find more posts tagged with

dss-rest-api

#content

#product

Accepted answers

Jirapongse

@jason.dance

Typically, the TickHistoryTimeAndSalesExtractionRequest works with ISINs but I am not sure why it doesn't work with US207932AB01. You need to contact the Refinitiv Tick History support team to verify what the problem is.

You can use the https://selectapi.datascope.refinitiv.com/RestApi/v1/Search/InstrumentSearch endpoint to search for the RICs of this ISIN.

{
  "SearchRequest": {
    "InstrumentTypeGroups": [
      "CollatetizedMortgageObligations",
      "Commodities",
      "Equities",
      "FuturesAndOptions",
      "GovCorp",
      "MortgageBackedSecurities",
      "Money",
      "Municipals",
      "Funds"
    ],
    "IdentifierType": "Isin",
    "Identifier": "US207932AB01",
    "PreferredIdentifierType": "Ric"
  }
}

The output is:

All comments

Jirapongse

@jason.dance

Thanks for reaching out to us.

I saw the same problem when using the TickHistoryTimeAndSalesExtractionRequest with this ISIN US207932AB01. The notes property shows the following information.

Instrument <ISN,US207932AB01> expanded to 0 RICS.\nInstrument <ISN,US207932AB01> expanded to 0 RICS.\n\nReport suppressed because there are no instruments

Please contact the Refinitiv Tick History support team directly via MyRefinitiv to verify what the problem is.

jason.dance

@Jirapongse Thanks for your reply, my understanding is that you can't request Time and Sales data by using an ISIN it must be a RIC. As we are unable to get the RIC from the Historical Request we can't then get the Time and Sales data.

Jirapongse

@jason.dance

You can use the https://selectapi.datascope.refinitiv.com/RestApi/v1/Search/InstrumentSearch endpoint to search for the RICs of this ISIN.

{
  "SearchRequest": {
    "InstrumentTypeGroups": [
      "CollatetizedMortgageObligations",
      "Commodities",
      "Equities",
      "FuturesAndOptions",
      "GovCorp",
      "MortgageBackedSecurities",
      "Money",
      "Municipals",
      "Funds"
    ],
    "IdentifierType": "Isin",
    "Identifier": "US207932AB01",
    "PreferredIdentifierType": "Ric"
  }
}

The output is:

jason.dance

Thank you, we have been looking at using the CMOABS Search which brings back the same results as the above instrument search. I have an open ticket with Refinitiv with, although they seem to think this is normal behavior which I disagree with.

EXPLORE OUR SITES