question

Upvotes
Accepted
9 1 0 3

How to retrieve more informations (assetName, PermID, ISIN, ecc...) about constituents retrieved by a HistoricalChainResolution request?

I can use

{
    "Request": {
        "ChainRics": [
            "0#.SPX:"
        ],
        "Range": {
            "Start": "2008-01-01T00:00:00.000Z",
            "End": "2016-01-01T00:00:00.000Z"
        }
    }
}

to get a list of constituents' RICS, but I'd need to get more informations about those assets (e.g. assetName, ISIN, PermID, etc...).

Is there any way to get these informations by modifying this request or using another request?


Thanks

tick-history-rest-apichain-ric
icon clock
10 |1500

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

1 Answer

Upvotes
Accepted
23k 22 9 14

Hello @nicola.donelli,

If you are an RTH customer, you can look into HistoricalReferenceExtractionRequest.

This is not a search, it is an extraction request, for example:

{ {protocol}}{ {host}}{ {api}}Extractions/ExtractWithNotes

{
    "ExtractionRequest": {
        "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.HistoricalReferenceExtractionRequest",
        "ContentFieldNames": [
           "RIC", "CUSIP", "ISIN", "SEDOL", "Issuer OrgID", "Issuer PermID", "Exchange Code", "Currency Code", "Change Date", "Primary Trading RIC", "Start date"
        ],
        "IdentifierList": {
            "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
            "InstrumentIdentifiers": [
                {
                    "Identifier": "0#.SPX",
                    "IdentifierType": "ChainRIC"
                }
            ],
            "ValidationOptions": {"AllowHistoricalInstruments": true},
            "UseUserPreferencesForValidationOptions": false
        },
        "Condition": {
          "StartDate": "2008-01-01T00:00:00.000Z",
            "EndDate": "2016-08-01T23:59:59.000Z"
        }
    }
}

Results in:

{"@odata.context":"https://hosted.datascopeapi.reuters.com/RestApi/v1/$metadata#Collection(ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.ExtractionRow)","value":[{"IdentifierType":"ChainRIC","Identifier":"0#.SPX","RIC":"WM.N","CUSIP":"939322103","ISIN":"US9393221034","SEDOL":"2942188","Issuer OrgID":"32985","Issuer PermID":"4295905311","Exchange Code":"NYS","Currency Code":"USD","Change Date":"2008-01-01","Primary Trading RIC":"Y","Start date":null},{"IdentifierType":"ChainRIC","Identifier":"0#.SPX","RIC":"WM.N","CUSIP":"939322103","ISIN":"US9393221034","SEDOL":"2942188","Issuer OrgID":"32985","Issuer PermID":"4295905311","Exchange Code":"NYS","Currency Code":"USD","Change Date":"2008-01-18","Primary Trading RIC":"Y","Start date":null},{"IdentifierType":"ChainRIC","Identifier":"0#.SPX","RIC":"WM.N","CUSIP":"939322103","ISIN":"US9393221034","SEDOL":"2942188","Issuer OrgID":"32985","Issuer PermID":"4295905311","Exchange Code":"NYS","Currency Code":"USD","Change Date":"2008-07-03","Primary Trading RIC":"Y","Start date":null}

...,


icon clock
10 |1500

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

Click below to post an Idea Post Idea