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.

Hello @bilou_12

Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?

If yes, please click the 'Accept' text next to the reply. This will guide all community members who have a similar question. Otherwise please post again offering further insight into your question.

Thanks,

AHS

Upvotes
Accepted
11.3k 25 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.