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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials

question

Upvotes
Accepted
4 5 6 7

Chain Ric Intraday Download Request: "all identifiers were invalid. No Extraction performed"

{ "ExtractionRequest": { "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.TickHistoryIntradaySummariesEx tractionRequest", "ContentFieldNames": [ "Close Ask", "Close Bid", "Domain", "High", "High Ask", "High Bid", "Instrument ID", "Instrument ID Type", "Last", "Low", "Low Ask", "Low Bid", "No. Asks", "No. Bids", "No. Trades", "Open", "Open Ask", "Open Bid", "RIC", "Sample Data", "Volume" ], "IdentifierList": { "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentIdentifierList", "InstrumentIdentifiers": [ { "Identifier": "0#.SPX", "IdentifierType": "chainRIC" } ], "ValidationOptions": null, "UseUserPreferencesForValidationOptions": false }, "Condition": { "MessageTimeStampIn": "GmtUtc", "ApplyLegacySummaryTimeLabel": false, "ReportDateRangeType": "Range", "QueryStartDate": "2008-10-13T13:00:00.000-05:00", "QueryEndDate": "2018-10-13T14:00:00.000-05:00", "SummaryInterval": "OneMinute", "TimebarPersistence": true, "DisplaySourceRIC": true } } }

dss-rest-apidatascope-selectdssapihistoricalchain-ricindex
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 25 9 14

Hello @psouto,

I am able to extract TickHistoryIntraday Summary for all constituents of 0#.SPX with the following request.

{ "ExtractionRequest": { "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.TickHistoryIntradaySummariesExtractionRequest", 
"ContentFieldNames": [ "Close Ask", "Close Bid", "Domain", "High", "High Ask", "High Bid", "Instrument ID", "Instrument ID Type", "Last", "Low", "Low Ask", "Low Bid", "No. Asks", "No. Bids", "No. Trades", "Open", "Open Ask", "Open Bid", "Sample Data", "Volume" ], 
"IdentifierList": { "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentIdentifierList", 
"InstrumentIdentifiers": [ 
{ "Identifier": "0#.SPX", "IdentifierType": "ChainRIC" } ], 
"ValidationOptions": null, "UseUserPreferencesForValidationOptions": false }, 
"Condition": { 
"MessageTimeStampIn": "GmtUtc", 
"ReportDateRangeType": "Range", 
"QueryStartDate": "2018-01-11T13:00:00.000-05:00", 
"QueryEndDate": "2018-01-11T14:00:00.000-05:00", 
"SummaryInterval": "OneMinute", 
"TimebarPersistence": true, 
"DisplaySourceRIC": true } } }

Below are some concerns on your request.

- According to DataDictionary "RIC" field is not valid for TickHistoryIntradaySummary Extraction Request.

- ApplyLegacySummaryTimeLabel condition seems not valid for this extraction request.

- The "IdentifierType" should be "ChainRIC" instead of "chainRIC".

- The QueryEndDate is in future (2018-10-13) which might not be correct.

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
32.2k 40 11 19

Hello @psouto,

"0#.SPX" is not a chain instrument, it's a RIC, therefore, please try "Ric" instead of "chainRIC".

(I can see where you coming from, as SPX is an index)

One can learn more about chains from this article: How to expand Chain RICs using the Tick History REST API in Python

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.

Thanks @zoya.farberov!

But what if I want all the members intraday bars?

Hello @psouto,

If you'd like all of the S&P intraday bars, I would request intraday bars supplying the list of constituents RICs.

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.