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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials

question

Upvotes
Accepted
25 3 4 8

Issue on SXF price on the 2020-05-19

Hi

Could you please amend the price of SXF on the 2020-05-19.

If you query the endpoint:

https://hosted.datascopeapi.reuters.com/RestApi/v1/Extractions/ExtractWithNotes

with the following json in parameters:

{
    '@odata.type': '#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.ElektronTimeseriesExtractionRequest',
    'ContentFieldNames': ['Trade Date', 'RIC', 'Settlement Price'],
    'IdentifierList': {
        '@odata.type': '#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentIdentifierList',
        'InstrumentIdentifiers': [{
            'Identifier': 'SXFU0',
            'IdentifierType': 'Ric'
        }],
        'ValidationOptions': {
            'AllowHistoricalInstruments': True
        },
        'UseUserPreferencesForValidationOptions': False
    },
    'Condition': {
        'StartDate': '2020-05-12T00:00:00.000Z',
        'EndDate': '2020-05-19T23:59:59.999Z'
    }
}

You will get a wrong price on the 2020-05-19: -9999402 CAD !!

{
    '@odata.context': 'https://hosted.datascopeapi.reuters.com/RestApi/v1/$metadata#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.ExtractionResult',
    'Contents': [{
        'IdentifierType': 'Ric',
        'Identifier': 'SXFU0',
        'Trade Date': '2020-05-18',
        'RIC': 'SXFU0',
        'Settlement Price': -9999402
    }],
}
dss-rest-apidatascope-selectdsserror
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.

Upvotes
Accepted
11.3k 26 9 14

Hi @bilou_12,

The negative price is Null Code which provides more information when price is not available. Below is the description of each value in the DSS User Guide document. The -9999402 means Market Holiday.

You can also configure the following parameter in User Preference to change the behavior.


1589866236212.png (145.2 KiB)
1589866300626.png (63.3 KiB)
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.

Upvotes
25 3 4 8

This is helpful! Thank you!

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.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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