No price data for delisted

Hi, can anybody help me understand why if I try to get the prices for AMCR.OQ^F07 I get "Report suppressed because there are no instruments"?

I've attached a Postman screenshot and this is my body code:

{
  "ExtractionRequest": {
    "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.TickHistoryTimeAndSalesExtractionRequest",
    "ContentFieldNames": [
          "Trade - Price",
          "Trade - Volume",
          "Trade - Exchange Time"
    ],
    "IdentifierList": {
      "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",  
      "InstrumentIdentifiers": [{
        "Identifier": "AMCR.OQ^F07",
        "IdentifierType": "Ric"
      }]
    },
    "Condition": {
      "MessageTimeStampIn": "GmtUtc",
      "ApplyCorrectionsAndCancellations": false,
      "ReportDateRangeType": "Range",
      "QueryStartDate": "2006-01-01T00:00:00.000Z",
      "QueryEndDate": "2019-09-21T12:00:00.000Z",
      "DisplaySourceRIC": true
    }
  }
}

Also, there is a way to know if a Instrument have historical prices data before hitting the TickHistoryTimeAndSalesExtractionRequest and get counted in the Datascope Quota Used?

Thank you in advance

Find more posts tagged with

pricing

tick-history-rest-api

Accepted answers

zoya faberov

Hello @veyrejulien

The guidance from a TRTH content expert is:

"I confirm that in TRTH, we have to use active RIC structure to pull data for Delisted, Expired or matured Instruments.

Please use RIC <AMCR.OQ> with the correct date range to pull Time and Sales data.

Historical Reference template is a DSS template where we can use delisted RIC structure to pull data. However, with respect to Tick history templates (Time and Sales, Market Depth, Intraday Summaries and Raw), delisted RIC structure will not work."

All comments

zoya faberov

Hello @veyrejulien

The guidance from a TRTH content expert is:

veyrejulien

HI @zoya faberov, thank you for the answer.

For what I understand I should use the active RIC structure in the correct date range to pull the right data for the correct instrument, I've understand it right?

So I've tried to get the active dates for RIC TW^I07 (21st Century Ins Ord Shs) from Historical Search and I get 2 instrument in response (see attached image) but it seems that no one is the right one. And look like the RIC is not the univocal identifier for an instrument. Am I right?

Can you please help me understand which would be the correct process in order to get the right prices for RICs like TW^I07?

zoya faberov

Hello @veyrejulien,

For a question on content, such as identifying the correct content, understanding the content you are receiving, requesting to investigate the correctness of content, reporting suspected gaps in the content, the best and most efficient way to get these questions answered for customers is to open a support case with Refinitiv Content Helpdesk

I am not a content expert, but in my observation, "TW" is TradeWeb RIC currently, and searches on it appear to return TradeWeb instruments on various exchanges.

You will need to start the search with some identifier for 21st century, such as "FOXA" ?

EXPLORE OUR SITES