how to View old and new ric with change date in HistoricalReference on demand raw extract

I think a good way is HistoricalReferenceExtractionRequest.

Please refer to REST API Tutorial 10 - Historical Reference

Similar to this:

{
    "ExtractionRequest": {
        "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.HistoricalReferenceExtractionRequest",
        "ContentFieldNames": [
           "RIC", "CUSIP", "ISIN", "SEDOL", "Issuer OrgID", "Exchange Code", "Currency Code", "Change Date"
        ],
        "IdentifierList": {
            "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
            "InstrumentIdentifiers": [
                {
                    "Identifier": "DEA0V6ZA.D",
                    "IdentifierType": "Ric"
                },
                {
                    "Identifier": "0048.HK",
                    "IdentifierType": "Ric"
                },
                {
                    "Identifier": "00E1.SG",
                    "IdentifierType": "Ric"
                },
                {
                    "Identifier": "00E2.D",
                    "IdentifierType": "Ric"
                }
            ],
            "ValidationOptions": {"AllowHistoricalInstruments": true},
            "UseUserPreferencesForValidationOptions": false
        },
        "Condition": {
            "StartDate": "1996-05-01T00:00:00.000Z",
            "EndDate": "2017-05-31T23:59:59.000Z"
        }
    }
}

Depending on the use case. Let's take an example of RIC

0048.HK -> 0048.HK^A12-> 8321.HK

Once we have run the previous request, we know the common Isin = KYG211351195

We can issue

  {
    "ExtractionRequest": {
        "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.HistoricalReferenceExtractionRequest",
        "ContentFieldNames": [
           "RIC", "CUSIP", "ISIN", "SEDOL", "Issuer OrgID", "Exchange Code", "Currency Code", "Change Date"
        ],
        "IdentifierList": {
            "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
            "InstrumentIdentifiers": [
                {
                    "Identifier": "KYG211351195",
                    "IdentifierType": "Isin"
                }
            ],
            "ValidationOptions": {"AllowHistoricalInstruments": true},
            "UseUserPreferencesForValidationOptions": false
        },
        "Condition": {
         "StartDate": "1990-05-01T00:00:00.000Z",
            "EndDate": "2017-05-31T23:59:59.000Z"
        }
    }
}

The received data will contain multiple change dates with RICs across this ISIN, with increasing change date.

The first set of changes carries the original RIC 0048.HK. The first occurrence of

0048.HK^A12 is when it was first valid. Then we have multiple changes of

0048.HK^A12 and the last set of changes contains RIC 8321.HK, the first one being when it was first valid.

Do you see how Historical Reference can be used to derive the RICs?

@ykr1314,

This should be the first raw with the changed RIC, in the column "Change Date"