How to perform on-demand Terms and Conditions extract using IdentifierType.Ticker

V

Is it possible to use IdentifierType.Ticker when performing an on-demand extraction? I'm using the following code:

var ExtractionsContext = new ExtractionsContext(new Uri("https://hosted.datascopeapi.reuters.com/RestApi/v1/"), "<your user id>", "<your password>");
            //Create new report template with conditions
            var extractionRequest = new TermsAndConditionsExtractionRequest {
                IdentifierList = InstrumentIdentifierList.Create(
                    new[] { new InstrumentIdentifier { Identifier = "MSFT", IdentifierType = IdentifierType.Ticker } }, null, false),
                ContentFieldNames = new[] 
                {
                    "Ticker",
                    "Asset Type Description",
                    "Security Description",
                    "Issue Date",
                    "RIC",
                    "Asset Status Description",
                    "Asset SubType Description",
                    "Currency Code Description",},
            };
            //Extract - NOTE: If the extraction request takes more than 30 seconds the async mechansim will be used.  See Key Mechanisms 
            var extractionResult = ExtractionsContext.ExtractWithNotes(extractionRequest);
            var extractedRows = extractionResult.Contents;
            //Output
            if (!extractedRows.Any())
                Debug.WriteLine("No rows returned");
            else {
                foreach (var row in extractedRows)
                    Debug.WriteLine(
                        row.Identifier + " (" + row.IdentifierType + ") " +
                        String.Join(", ", row.DynamicProperties.Select(dp => dp.Key + "=" + dp.Value)));
            }
            //Output Notes
            Debug.WriteLine("NOTES:");
            foreach (var note in extractionResult.Notes)
                Debug.WriteLine(note);

The results come back with the following message: MSFT (Ticker) NOTES: All identifiers were invalid. No extraction performed.

Is it not possible? If not, any alternate approach would be most welcome.

Jirapongse

I have used Search/InstrumentSearch with Postman and it works fine with Ticker.

{
  "SearchRequest": {
    "InstrumentTypeGroups": [
      "CollatetizedMortgageObligations",
      "Commodities",
      "Equities",
      "FuturesAndOptions",
      "GovCorp",
      "MortgageBackedSecurities",
      "Money",
      "Municipals",
      "Funds"
    ],
    "IdentifierType": "Ticker",
    "Identifier": "MSFT",
    "PreferredIdentifierType": "Ric"
  }
}

The response is:

  {
            "Identifier": "MSFT.MW",
            "IdentifierType": "Ric",
            "Source": "GSM",
            "Key": "VjF8MHgwMDAzZGQwMDEzNWZiNzI1fDB4MDAwM2RjMDAzNDdiYjgyOHxHU018RVFRVXxFUVRZfE9EU0h8RXx8TVNGVC5NV3wxMTcw",
            "Description": "MICROSOFT ORD",
            "InstrumentType": "EquityQuote",
            "Status": "Valid"
        },
        {
            "Identifier": "MSFT.OQ",
            "IdentifierType": "Ric",
            "Source": "NSM",
            "Key": "VjF8MHgwMDAzZGQwMDEzNWZiNzI1fDB4MDAwM2RjMDAzOGRlMmIxMnxOU018RVFRVXxFUVRZfE9EU0h8RXx8TVNGVC5PUXwxMzAz",
            "Description": "MICROSOFT ORD",
            "InstrumentType": "EquityQuote",
            "Status": "Valid"
        },
...

Please share your code for search.

Jirapongse

I got the same result as yours. It returned "Not found".

{
    "@odata.context": "https://hosted.datascopeapi.reuters.com/RestApi/v1/$metadata#Collection(ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.ExtractionRow)",
    "value": [
        {
            "IdentifierType": "Ticker",
            "Identifier": "MSFT",
            "Error": "Not found"
        }
    ]
}

Please directly contact DSS support team via Contact Us to verify the problem.

You may use search to find RICs for MSFT and then use those RICs with TermsAndConditionsExtractionRequest.

V

Thanks for your reply @jiraponse.phuriphanvchai. With large dynamic lists of securities it would be great to avoid search. I understand tickers are used differently based on exchange and asset type. It would be great to extract based on a combination of exchange, type and ticker. I'll reach out to support.

V

I tried search and no luck. "The identifier Type TICKER is not supported..."