For a deeper look into our DataScope Select REST API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials

question

Upvotes
Accepted
3 1 1 5

Dual Market List Case

we have a case that there are some stocks registered on two markets and when we try to retrieve data from reuters , the extraction result returned with only the default market,so we need to retrieve the data for the other markets by make filtered query using another market identifier .the current code used to retrieve data is :

var extractionRequest = newTermsAndConditionsExtractionRequest
{
  IdentifierList = InstrumentIdentifierList.Create( new[] {
    newInstrumentIdentifier { Identifier = "DE000A1EWWW0", IdentifierType = IdentifierType.Isin }
  }, null, false),
  ContentFieldNames = new[] {
    "Company Name","Currency Code","ISIN","Issue Price","Issuer Name","MIC List","MIC","SEDOL","SICC",
    "SICC Sector Code","Ticker","Trading Symbol","Trading Status","Official Name","Operating MIC"
  }
};
var extractionResult = ExtractionsContext.ExtractWithNotes(extractionRequest);

Appreciate your quick response because this issue is very critical .

Thanks

dss-rest-apidssdatascope-selectequities
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.

1 Answer

Upvotes
Accepted
11.3k 25 8 14

Hi @rshehata,

As far as I know, you can add source of identifier to specify exchange of instrument to be extracted. For example, the following request will extract data for Vienna Stock Exchange (VIE). The list of available exchange codes for this instrument is in the "Exchange Code List" field.

{
 "ExtractionRequest": {
  "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.TermsAndConditionsExtractionRequest",
  "ContentFieldNames": 
    [ "Company Name","Currency Code","ISIN","Issue Price","Issuer Name",
      "MIC List","MIC","SEDOL","SICC","SICC Sector Code","Ticker",
      "Trading Symbol","Trading Status","Official Name","Operating MIC",
      "Exchange Code List" ],
  "IdentifierList": {
   "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
   "InstrumentIdentifiers": [
    { "Identifier": "DE000A1EWWW0", "IdentifierType": "Isin", "Source": "VIE" }
   ],
   "UseUserPreferencesForValidationOptions": true
  }
 }
}
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.