Getting empty data
Hello,
I am trying to request data for Ric "0#NK:" for 2019-04-24. I expanded the chain and got [u'NKH0', u'NKH1', u'NKH2', u'NKM0', u'NKM1', u'NKM9', u'NKU0', u'NKU1', u'NKU9', u'NKZ0', u'NKZ1', u'NKZ2', u'NKZ24', u'NKZ3', u'NKZ9']. Note that in above, I get NKM9. I created a request for 2014-04-24 to get this data (see payload below) but get no data for "Last" or "Volume".
Payload:
@{u'ExtractionRequest': {u'@odata.type': u'#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.TickHistoryIntradaySummariesExtractionRequest',
u'Condition': {u'DisplaySourceRIC': True,
u'MessageTimeStampIn': u'GmtUtc',
u'QueryEndDate': '2019-04-24T23:59:59.999Z',
u'QueryStartDate': '2019-04-24T00:00:00.000Z',
u'ReportDateRangeType': u'Range',
u'SummaryInterval': u'OneMinute',
u'TimebarPersistence': True},
u'ContentFieldNames': [u'Last', u'Volume'],
u'IdentifierList': {u'@odata.type': u'#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentIdentifierList',
u'InstrumentIdentifiers': [{'Identifier': u'NKH0', 'IdentifierType': 'Ric'},
{'Identifier': u'NKH1', 'IdentifierType': 'Ric'},
{'Identifier': u'NKH2', 'IdentifierType': 'Ric'},
{'Identifier': u'NKM0', 'IdentifierType': 'Ric'},
{'Identifier': u'NKM1', 'IdentifierType': 'Ric'},
{'Identifier': u'NKM9', 'IdentifierType': 'Ric'},
{'Identifier': u'NKU0', 'IdentifierType': 'Ric'},
{'Identifier': u'NKU1', 'IdentifierType': 'Ric'},
{'Identifier': u'NKU9', 'IdentifierType': 'Ric'},
{'Identifier': u'NKZ0', 'IdentifierType': 'Ric'},
{'Identifier': u'NKZ1', 'IdentifierType': 'Ric'},
{'Identifier': u'NKZ2', 'IdentifierType': 'Ric'},
{'Identifier': u'NKZ24', 'IdentifierType': 'Ric'},
{'Identifier': u'NKZ3', 'IdentifierType': 'Ric'},
{'Identifier': u'NKZ9', 'IdentifierType': 'Ric'}]}}}
Here is the response url: https://hosted.datascopeapi.reuters.com/RestApi/v1/Extractions/RawExtractionResults('0x06bfa5f8b6b0dfd9')/$value
I am seeing that there is no NKM9 at all.
I drilled further and the notes indicate that there was an error in identifying NKM9 even though on that date it was the most liquid contract.
https://hosted.datascopeapi.reuters.com/RestApi/v1/Extractions/ExtractRawResult(ExtractionId='0x06bfa0c21f10dfc4')
Best Answer
-
I ran the same request, effectively the extraction notes state that NKM9 was "Not found". This can happen if the instrument is a historical instrument, and no longer quoted.
You can set the following validation options in the query, to allow historical instruments (and more) in a query:
...
{ "Identifier": "NKZ9", "IdentifierType": "Ric" }
],
"ValidationOptions": {
"AllowHistoricalInstruments": true,
"AllowInactiveInstruments": true,
"AllowOpenAccessInstruments": true
},
"UseUserPreferencesForValidationOptions": false
}
...That will deliver data for NKM9.
0
Answers
-
The extraction notes are a very effective tool to debug issues.
0
Categories
- All Categories
- 3 Polls
- 6 AHS
- 36 Alpha
- 166 App Studio
- 6 Block Chain
- 4 Bot Platform
- 18 Connected Risk APIs
- 47 Data Fusion
- 34 Data Model Discovery
- 688 Datastream
- 1.4K DSS
- 625 Eikon COM
- 5.2K Eikon Data APIs
- 11 Electronic Trading
- 1 Generic FIX
- 7 Local Bank Node API
- 3 Trading API
- 2.9K Elektron
- 1.4K EMA
- 255 ETA
- 557 WebSocket API
- 38 FX Venues
- 14 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 23 Messenger Bot
- 3 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 60 Open Calais
- 276 Open PermID
- 44 Entity Search
- 2 Org ID
- 1 PAM
- PAM - Logging
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 22 RDMS
- 1.9K Refinitiv Data Platform
- 695 Refinitiv Data Platform Libraries
- 4 LSEG Due Diligence
- LSEG Due Diligence Portal API
- 4 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.2K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 12 World-Check Customer Risk Screener
- 1K World-Check One
- 46 World-Check One Zero Footprint
- 45 Side by Side Integration API
- 2 Test Space
- 3 Thomson One Smart
- 10 TR Knowledge Graph
- 151 Transactions
- 143 REDI API
- 1.8K TREP APIs
- 4 CAT
- 27 DACS Station
- 121 Open DACS
- 1.1K RFA
- 105 UPA
- 194 TREP Infrastructure
- 229 TRKD
- 918 TRTH
- 5 Velocity Analytics
- 9 Wealth Management Web Services
- 92 Workspace SDK
- 11 Element Framework
- 5 Grid
- 18 World-Check Data File
- 1 Yield Book Analytics
- 48 中文论坛