how do you get ric details in api

dorlovsky

I can get a Ric of a future or option using Search/HistoricalChainResolution or /Search/FuturesAndOptionsSearch the results have some details like Key, Identifier, Description etc and of course the Ric

If I copy the Ric into the search field in web ui I can get more info, like expiration date.

How do I get that from that API. I tried using Search/ReferenceHistory but got nothing back. For example this body returns nothing:
{ "Request": { "Rics": [ "ESH0^0" ], "Range": { "Start": "1990-01-01T00:00:00.000Z", "End": "2017-05-15T00:00:00.000Z" } } }

zoya faberov

Hi @dorlovsky,

The answer provided by the content team:

"Clients were directed to use T&Cs as a
temporary workaround when Historical Reference template was being built.
However, T&Cs merely hold live reference data. It does not hold Historical
Reference data. Clients looking for references on Futures and Options (which
typically expires every month) and other instruments that expire will get
reference data only via. Historical Reference template. For the sake of
simplicity, Tick History clients must use the Historical Reference template for
reference data on all asset categories (minus fixed income references).
"

For an example, please refer to the following request:

{
  "ExtractionRequest": {
    "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.HistoricalReferenceExtractionRequest",
    "ContentFieldNames": [
      "RIC", "CUSIP", "ISIN", "SEDOL", "Issuer OrgID", "Currency Code", "Expiration Date", "Lot Size"
    ],
    "IdentifierList": {
      "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",  
      "InstrumentIdentifiers": [{
        "Identifier": "ESH0^0",
        "IdentifierType": "Ric"
      }]
    },
    "Condition": {
      "StartDate": "2007-09-29T00:00:00.000Z",
      "EndDate": "2017-09-29T12:00:00.000Z"
    }
  }
}

Jirapongse

@dorlovsky

I found that the expiration date of ESH0^0 is available via TermsAndConditionsExtractionRequest.

Then, I used on Demand Extraction with this URL to send the request.

POST: https://hosted.datascopeapi.reuters.com/RestApi/V1/Extractions/Extract

The request message is:

{
    "ExtractionRequest": {
        "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.TermsAndConditionsExtractionRequest",
        "ContentFieldNames": [
           "RIC", "CUSIP", "ISIN", "SEDOL", "Issuer OrgID", "Currency Code", "Expiration Date", "Lot Size"
        ],
        "IdentifierList": {
            "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
            "InstrumentIdentifiers": [
                {
                    "Identifier": "ESH0^0",
                    "IdentifierType": "Ric"
                }
            ]
        }
    }
}

The response is:

{
  "@odata.context": "https://hosted.datascopeapi.reuters.com/RestApi/v1/$metadata#Collection(ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.ExtractionRow)",
  "value": [
    {
      "IdentifierType": "Ric",
      "Identifier": "ESH0^0",
      "RIC": "ESH0^0",
      "CUSIP": null,
      "ISIN": null,
      "SEDOL": null,
      "Issuer OrgID": null,
      "Currency Code": "USD",
      "Expiration Date": "2000-03-17",
      "Lot Size": 50
    }
  ]
}

For more information, please refer to:

• REST API Tutorial 7: On Demand T&C extraction
• DSS Help On Demand Extraction

dorlovsky

this is not at all obvious! how did you know to do that? how would I?

What url are you invoking this on?

The api doc does not show you can show you can do any kind of body at all!
https://hosted.datascopeapi.reuters.com/RestApi.Help/Context/Entity?ctx=Extractions&ent=TermsAndConditionsReportTemplate&sce=Report Template Examples - Create - Terms and Conditions&stp=1&tab=2

Jirapongse

https://community.developers.refinitiv.com/discussion/comment/13743#Comment_13743

I used on Demand Extraction with this URL.

POST: https://hosted.datascopeapi.reuters.com/RestApi/V1/Extractions/Extract.

First, I verified the list of available fields for Term & Conditions and found the "Expiration Date" and "Lot Size" fields in the list.

For more information, please refer to:

• REST API Tutorial 7: On Demand T&C extraction
• DSS Help On Demand Extraction
  

veerapath.rungruengrayubkul

https://community.developers.refinitiv.com/discussion/comment/13743#Comment_13743

@dorlovsky

You can also find all available fields for report templates in the "Field Descriptions" tab of the TICK HISTORY DATA DICTIONARY document. The document can be downloaded from this link.