DSS Composite extraction request give one Ric for each Instrument

I am using below extraction request which is currently giving just Instrument and one Ric market with the pricing option values. But somehow this logic is incorrect. Normally for one company(Instrument) there will be more than one markets. For example when i checked from the DSS gui for ISIN "CA0679011084", we received below markets:

How can i achieve this result using composite extraction request ? Below is my extraction request in which when i pass one ISIN "CA0679011084" its returning just one market :

CA0679011084,3348623,3420466,26.774204682,66732329.762991406,,,1779285869,

requestBody = {
    "ExtractionRequest": {
        "@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.CompositeExtractionRequest",
        "ContentFieldNames": [
            "ISIN","Average Volume - 30 Days","Average Volume - 90 Days","Close on Close Volatility - 90 Days","Dollar Daily Value Average - 30 Days","CESR Free Float","CRA Free Float","Outstanding Shares - Issue Shares Amount","Outstanding Shares - Other Shares Amount"
        ],
        "IdentifierList": {
            "@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
            "InstrumentIdentifiers": [{
                "Identifier": "CA0679011084",
                "IdentifierType": "Isin"
            }]
        },
        "Condition": {
            "ScalableCurrency": "true"
        }
    }
}

Below is my python code:composite_extratcion_request.txt

Find more posts tagged with

dss

dss-rest-api

dss-gui

Accepted answers

gteage

@rahul.deshmukh Hi Rahul, the screenshot at the top is from a DSS Search endpoint, therefore you get results as Search does not impact usage.

As the Composite is a Extraction and usage will be applicable, generally DSS selects a single RIC for use for Pricing fields to limit the results.

If you were wanting to get back records for all Sources probably what you are after is to have in the requestBody:

            "InstrumentIdentifiers": [{
                "Identifier": "CA0679011084",
                "IdentifierType": "Isin",
                "Source": "*",
            }]

RIC is a Pricing-level Identifier which already defines the Source. Using the ISIN with the Source using the * wildcard will expand the ISIN (instrument-level) to include all price sources (RICs).

Best regards,

Gareth

All comments

rahul.deshmukh

@Gurpreet Its regarding the same composite extraction request where i am just getting one market per ISIN which is incorrect...Can you please help here..thanks..

gteage

@rahul.deshmukh Hi Rahul, the screenshot at the top is from a DSS Search endpoint, therefore you get results as Search does not impact usage.

As the Composite is a Extraction and usage will be applicable, generally DSS selects a single RIC for use for Pricing fields to limit the results.

If you were wanting to get back records for all Sources probably what you are after is to have in the requestBody:

            "InstrumentIdentifiers": [{
                "Identifier": "CA0679011084",
                "IdentifierType": "Isin",
                "Source": "*",
            }]

RIC is a Pricing-level Identifier which already defines the Source. Using the ISIN with the Source using the * wildcard will expand the ISIN (instrument-level) to include all price sources (RICs).

Best regards,

Gareth

rahul.deshmukh

@gteage thanks for the feedback...its working now and giving the result with all the markets for given Instrument

rahul.deshmukh

@gteage currently for 630 Instruments i am getting almost more than 100k rows returned...I dont know if it also includes Valid and updated markets ...do i have to provide additional option in the extraction requeststo restrict the data with maybe valid and updated markets ?

EXPLORE OUR SITES