question

Upvotes
Accepted
dorlovsky avatar image
1 ●0 ●1 ●3

how do you get ric details in api

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" } } }

tick-history-rest-api
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

pimchaya.wongrukun01 avatar image   pimchaya.wongrukun01

Hello @dorlovsky

Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query? If yes please click the 'Accept' text next to the reply. This will guide all community members who have a similar question. Otherwise please post again offering further insight into your question.

Thanks,

AHS

zoya faberov avatar image   zoya faberov

Hello @dorlovsky,

Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.

Thanks,

-AHS

3 Answers

· Write an Answer
Upvotes
Accepted
zoya faberov avatar image
32.2k ●40 ●11 ●20

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"
    }
  }
}
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvotes
Jirapongse avatar image
79.2k ●251 ●52 ●74

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

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvotes
dorlovsky avatar image
1 ●0 ●1 ●3

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%20Template%20Examples%20-%20Create%20-%20Terms%20and%20Conditions&stp=1&tab=2

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Jirapongse avatar image Jirapongse

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:

veerapath.rungruengrayubkul avatar image veerapath.rungruengrayubkul
@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.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.