Not receiving any tick history data for OESX fund (RIC: 0#STXE*.EX)
Hi everyone,
I am trying to get historical market depth data for options of Eurostoxx 50 (OESX) and I am using the identifiers I get by using the
api.search.historical_chain_resolution(chain_ric, start, end)
I get the results and I get a good amount of RIC identifiers:
STXE100000F7.EX
STXE100000G7.EX
STXE100000H7.EX
STXE100000L1.EX
STXE100000L8.EX
STXE100000R7.EX
STXE100000S7.EX
STXE100000T7.EX
STXE100000X1.EX
STXE100000X8.EX
STXE10000C8.EX
STXE10000F7.EX
STXE10000F8.EX
STXE10000F9.EX
STXE10000G7.EX
STXE10000H7.EX
STXE10000I7.EX
...
However, when I do the API call for historical market depth data with these identifiers, I don't get any results:
api.extractions.tick_history_market_depth_data(
identifiers=identifiers,
start=start,
end=end,
fields=self._reference_fields,
levels=market_depth,
timezone=self._timezone,
message_timestamp="GmtUtc",
)
The time range I used was between 17-03-2017 and 18-03-2017, but I have tried on much larger and different time ranges and there was never any data.
Could someone help me with this?
Best Answer
-
The product team has reviewed the error message and found that the market-depth data is not supported for these instruments. Hence, the application gets the below error message in the notes file which is valid.
row suppressed for lack of 'Distribution Rights - Tick History never allowed for PE 0' permission.
However, the client can do Time and sales, raw and other extraction for these RICs, and will get the data.
0
Answers
-
Thanks for reaching out to us.
When an extraction is completed, there is a Note that contains useful extraction information.
Typically, we can verify the problem from the information in the Note.
For example, I tested with the following request:
{
"ExtractionRequest": {
"@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.TickHistoryMarketDepthExtractionRequest",
"ContentFieldNames": [
"Ask Price",
"Ask Size",
"Bid Price",
"Bid Size",
"Domain",
"History End",
"History Start",
"Instrument ID",
"Instrument ID Type",
"Number of Buyers",
"Number of Sellers",
"Sample Data"
],
"IdentifierList": {
"@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
"InstrumentIdentifiers": [
{
"Identifier": "STXE10000I7.EX",
"IdentifierType": "Ric"
},
{
"Identifier": "STXE100000F7.EX",
"IdentifierType": "Ric"
}
],
"ValidationOptions": {
"AllowHistoricalInstruments": true,
"AllowOpenAccessInstruments": true
}
},
"Condition": {
"View": "NormalizedLL2",
"NumberOfLevels": 10,
"MessageTimeStampIn": "GmtUtc",
"ReportDateRangeType": "Range",
"QueryStartDate": "2017-03-17T09:00:00.000Z",
"QueryEndDate": "2017-03-18T12:00:00.000Z",
"DisplaySourceRIC": true
}
}
}I got the following response:
{
"@odata.context": "https://selectapi.datascope.refinitiv.com/RestApi/v1/$metadata#RawExtractionResults/$entity",
"JobId": "0x083a6aa5dea34ae5",
"Notes": [
"Extraction Services Version 16.2.44415 (c4ac5f5e8fb7), Built Oct 12 2022 22:13:16\nUser ID: 9008895\nExtraction ID: 2000000468767378\nCorrelation ID: CiD/9008895/AAAAAA.083a6aa5de934ae5/RA\nSchedule: 0x083a6aa5dea34ae5 (ID = 0x0000000000000000)\nInput List (2 items): (ID = 0x083a6aa5dea34ae5) Created: 11/01/2022 17:45:03 Last Modified: 11/01/2022 17:45:03\nReport Template (12 fields): _OnD_0x083a6aa5dea34ae5 (ID = 0x083a6aa5dec34ae5) Created: 11/01/2022 17:45:01 Last Modified: 11/01/2022 17:45:01\nSchedule dispatched via message queue (0x083a6aa5dea34ae5)\nSchedule Time: 11/01/2022 17:45:02\nProcessing started at 11/01/2022 17:45:02\nProcessing completed successfully at 11/01/2022 17:45:03\nExtraction finished at 11/01/2022 10:45:03 UTC, with servers: x11q15\nHistorical Instrument <RIC,STXE10000I7.EX> expanded to 1 RIC: STXE10000I7.EX.\nHistorical Instrument <RIC,STXE100000F7.EX> expanded to 0 RICS.\nTotal instruments after instrument expansion = 1\n\n(RIC,STXE10000I7.EX,) row suppressed for lack of 'Distribution Rights - Tick History never allowed for PE 0' permission.\nReport suppressed because no instruments are permitted\n"
]
}According to the Notes, it can't expand STXE100000F7.EX and I don't have distribution rights to this STXE10000I7.EX RIC.
Please share the Note of your extraction.
0 -
Hey @Jirapongse, seems like I am unable to access the `Notes` field in my response. Is there a reason why I wouldn't have a `Notes` field?
Also, even if I had and I got the same issue as you did, what would be the fix for that? How do I get that data then?
0 -
Hi @Jirapongse, I managed to get to my notes.
Seems like I am getting the same thing as you do
(RIC,.STOXX50E,STX) row suppressed for lack of 'Distribution Rights - Tick History never allowed for PE 0' permission.
(RIC,STXE100000F7.EX,) row suppressed for lack of 'Distribution Rights - Tick History never allowed for PE 0' permission.
...I get this for all the identifiers I passed on. How can I access that data? Do I need to buy additional Distribution Rights?
0 -
It may relate to the availability or restriction of the content.
Please contact the Refinitiv Tick History support team directly via MyRefinitiv to clarify the cause of these messages.
(RIC,.STOXX50E,STX) row suppressed for lack of 'Distribution Rights - Tick History never allowed for PE 0' permission.
(RIC,STXE100000F7.EX,) row suppressed for lack of 'Distribution Rights - Tick History never allowed for PE 0' permission.0 -
@Jirapongse my mistake. I found notes!
This is what I get:Extraction Services Version 16.2.44415 (c4ac5f5e8fb7), Built Oct 12 2022 22:13:16
User ID: 9019578
Extraction ID: 2000000468815334
Correlation ID: CiD/9019578/AAAAAA.083a72beb3a34af5/RA
Schedule: 0x083a72beb3b34af5 (ID = 0x0000000000000000)
Input List (2707 items): (ID = 0x083a72beb3b34af5) Created: 11/01/2022 13:04:15 Last Modified: 11/01/2022 13:04:15
Report Template (6 fields): _OnD_0x083a72beb3b34af5 (ID = 0x083a72beb3c34af5) Created: 11/01/2022 13:03:39 Last Modified: 11/01/2022 13:03:39
Schedule dispatched via message queue (0x083a72beb3b34af5)
Schedule Time: 11/01/2022 13:03:54
Processing started at 11/01/2022 13:03:54
Processing completed successfully at 11/01/2022 13:04:16
Extraction finished at 11/01/2022 13:04:16 UTC, with servers: x04q10
Instrument <RIC,.STOXX50E> expanded to 1 RIC: .STOXX50E.
Historical Instrument <RIC,STXE100000F7.EX> expanded to 1 RIC: STXE100000F7.EX.
Historical Instrument <RIC,STXE100000G7.EX> expanded to 1 RIC: STXE100000G7.EX.
Historical Instrument <RIC,STXE100000H7.EX> expanded to 1 RIC: STXE100000H7.EX.
Historical Instrument <RIC,STXE100000L1.EX> expanded to 1 RIC: STXE100000L1.EX.
Historical Instrument <RIC,STXE100000L8.EX> expanded to 1 RIC: STXE100000L8.EX.
Historical Instrument <RIC,STXE100000R7.EX> expanded to 1 RIC: STXE100000R7.EX.
Historical Instrument <RIC,STXE100000S7.EX> expanded to 1 RIC: STXE100000S7.EX.
Historical Instrument <RIC,STXE100000T7.EX> expanded to 1 RIC: STXE100000T7.EX.
Historical Instrument <RIC,STXE100000X1.EX> expanded to 1 RIC: STXE100000X1.EX.
Historical Instrument <RIC,STXE100000X8.EX> expanded to 1 RIC: STXE100000X8.EX.
Historical Instrument <RIC,STXE10000C8.EX> expanded to 1 RIC: STXE10000C8.EX.
Historical Instrument <RIC,STXE10000F7.EX> expanded to 1 RIC: STXE10000F7.EX.
Historical Instrument <RIC,STXE10000F8.EX> expanded to 1 RIC: STXE10000F8.EX.
Historical Instrument <RIC,STXE10000F9.EX> expanded to 1 RIC: STXE10000F9.EX.
Historical Instrument <RIC,STXE10000G7.EX> expanded to 1 RIC: STXE10000G7.EX.
Historical Instrument <RIC,STXE10000H7.EX> expanded to 1 RIC: STXE10000H7.EX.
Historical Instrument <RIC,STXE10000I7.EX> expanded to 1 RIC: STXE10000I7.EX.
Instrument <RIC,STXE10000L0.EX> expanded to 1 RIC: STXE10000L0.EX.
Instrument <RIC,STXE10000L1.EX> expanded to 1 RIC: STXE10000L1.EX.
Instrument <RIC,STXE10000L2.EX> expanded to 1 RIC: STXE10000L2.EX.
Instrument <RIC,STXE10000L3.EX> expanded to 1 RIC: STXE10000L3.EX.
Instrument <RIC,STXE10000L4.EX> expanded to 1 RIC: STXE10000L4.EX.
Instrument <RIC,STXE10000L5.EX> expanded to 1 RIC: STXE10000L5.EX.
Instrument <RIC,STXE10000L6.EX> expanded to 1 RIC: STXE10000L6.EX.
Instrument <RIC,STXE10000L7.EX> expanded to 1 RIC: STXE10000L7.EX.
Instrument <RIC,STXE10000L8.EX> expanded to 1 RIC: STXE10000L8.EX.
Instrument <RIC,STXE10000L9.EX> expanded to 1 RIC: STXE10000L9.EX.
Historical Instrument <RIC,STXE10000O8.EX> expanded to 1 RIC: STXE10000O8.EX.
Historical Instrument <RIC,STXE10000R7.EX> expanded to 1 RIC: STXE10000R7.EX.
Historical Instrument <RIC,STXE10000R8.EX> expanded to 1 RIC: STXE10000R8.EX.
Historical Instrument <RIC,STXE10000R9.EX> expanded to 1 RIC: STXE10000R9.EX.
Historical Instrument <RIC,STXE10000S7.EX> expanded to 1 RIC: STXE10000S7.EX.
Historical Instrument <RIC,STXE10000T7.EX> expanded to 1 RIC: STXE10000T7.EX.
Historical Instrument <RIC,STXE10000U7.EX> expanded to 1 RIC: STXE10000U7.EX.
Instrument <RIC,STXE10000X0.EX> expanded to 1 RIC: STXE10000X0.EX.
Instrument <RIC,STXE10000X1.EX> expanded to 1 RIC: STXE10000X1.EX.
Instrument <RIC,STXE10000X2.EX> expanded to 1 RIC: STXE10000X2.EX.
Instrument <RIC,STXE10000X3.EX> expanded to 1 RIC: STXE10000X3.EX.
Instrument <RIC,STXE10000X4.EX> expanded to 1 RIC: STXE10000X4.EX.
Instrument <RIC,STXE10000X5.EX> expanded to 1 RIC: STXE10000X5.EX.
Instrument <RIC,STXE10000X6.EX> expanded to 1 RIC: STXE10000X6.EX.
Instrument <RIC,STXE10000X7.EX> expanded to 1 RIC: STXE10000X7.EX.
Instrument <RIC,STXE10000X8.EX> expanded to 1 RIC: STXE10000X8.EX.
Instrument <RIC,STXE10000X9.EX> expanded to 1 RIC: STXE10000X9.EX.
Historical Instrument <RIC,STXE10500G7.EX> expanded to 1 RIC: STXE10500G7.EX.
Historical Instrument <RIC,STXE10500H7.EX> expanded to 1 RIC: STXE10500H7.EX.
Historical Instrument <RIC,STXE10500S7.EX> expanded to 1 RIC: STXE10500S7.EX.
Historical Instrument <RIC,STXE10500T7.EX> expanded to 1 RIC: STXE10500T7.EX.
Historical Instrument <RIC,STXE110000L8.EX> expanded to 1 RIC: STXE110000L8.EX.
Historical Instrument <RIC,STXE110000X8.EX> expanded to 1 RIC: STXE110000X8.EX.
Historical Instrument <RIC,STXE11000C8.EX> expanded to 1 RIC: STXE11000C8.EX.
Historical Instrument <RIC,STXE11000F7.EX> expanded to 1 RIC: STXE11000F7.EX.
Historical Instrument <RIC,STXE11000F8.EX> expanded to 1 RIC: STXE11000F8.EX.
Historical Instrument <RIC,STXE11000F9.EX> expanded to 1 RIC: STXE11000F9.EX.
Historical Instrument <RIC,STXE11000G7.EX> expanded to 1 RIC: STXE11000G7.EX.
Historical Instrument <RIC,STXE11000H7.EX> expanded to 1 RIC: STXE11000H7.EX.
Historical Instrument <RIC,STXE11000I7.EX> expanded to 1 RIC: STXE11000I7.EX.
Historical Instrument <RIC,STXE11000L1.EX> expanded to 1 RIC: STXE11000L1.EX.
...
Total instruments after instrument expansion = 2705
(RIC,.STOXX50E,STX) row suppressed for lack of 'Distribution Rights - Tick History never allowed for PE 0' permission.
(RIC,STXE100000F7.EX,) row suppressed for lack of 'Distribution Rights - Tick History never allowed for PE 0' permission.
(RIC,STXE100000G7.EX,) row suppressed for lack of 'Distribution Rights - Tick History never allowed for PE 0' permission.
(RIC,STXE100000H7.EX,) row suppressed for lack of 'Distribution Rights - Tick History never allowed for PE 0' permission.
(RIC,STXE100000L1.EX,) row suppressed for lack of 'Distribution Rights - Tick History never allowed for PE 0' permission.
(RIC,STXE100000L8.EX,) row suppressed for lack of 'Distribution Rights - Tick History never allowed for PE 0' permission.
(RIC,STXE100000R7.EX,) row suppressed for lack of 'Distribution Rights - Tick History never allowed for PE 0' permission.
(RIC,STXE100000S7.EX,) row suppressed for lack of 'Distribution Rights - Tick History never allowed for PE 0' permission.
(RIC,STXE100000T7.EX,) row suppressed for lack of 'Distribution Rights - Tick History never allowed for PE 0' permission.
(RIC,STXE100000X1.EX,) row suppressed for lack of 'Distribution Rights - Tick History never allowed for PE 0' permission.
(RIC,STXE100000X8.EX,) row suppressed for lack of 'Distribution Rights - Tick History never allowed for PE 0' permission.
(RIC,STXE10000C8.EX,) row suppressed for lack of 'Distribution Rights - Tick History never allowed for PE 0' permission.
(RIC,STXE10000F7.EX,) row suppressed for lack of 'Distribution Rights - Tick History never allowed for PE 0' permission.
(RIC,STXE10000F8.EX,) row suppressed for lack of 'Distribution Rights - Tick History never allowed for PE 0' permission.
...
Report suppressed because no instruments are permittedHow can I get rights for these instruments?
0 -
Thank you for the confirmation. We got the same error.
It may relate to the availability or restriction of the content.
Please contact the Refinitiv Tick History support team directly via MyRefinitiv to clarify the cause of those messages.
0 -
Hi
@Jirapongse, how would one get depth data from Times and Sales? Which data is Refinitiv using to construct market depth data?0 -
@ivan.lovrencic
I found that you submitted a case to the Tick History support.
You can ask the support team regarding how to construct depth data from Time and Sales, raw or other extractions.
0
Categories
- All Categories
- 6 AHS
- 37 Alpha
- 161 App Studio
- 4 Block Chain
- 4 Bot Platform
- 16 Connected Risk APIs
- 47 Data Fusion
- 30 Data Model Discovery
- 608 Datastream
- 1.3K DSS
- 577 Eikon COM
- 4.9K Eikon Data APIs
- 7 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- Trading API
- 2.7K Elektron
- 1.3K EMA
- 236 ETA
- 519 WebSocket API
- 33 FX Venues
- 10 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 20 Messenger Bot
- 2 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 59 Open Calais
- 264 Open PermID
- 39 Entity Search
- 2 Org ID
- PAM
- PAM - Logging
- 8.4K Private Comments
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 20 RDMS
- 1.4K Refinitiv Data Platform
- 367 Refinitiv Data Platform Libraries
- 3 Refinitiv Due Diligence
- LSEG Due Diligence Portal API
- 3 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.1K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 10 World-Check Customer Risk Screener
- 990 World-Check One
- 44 World-Check One Zero Footprint
- 45 Side by Side Integration API
- Test Space
- 3 Thomson One Smart
- 1.2K TR Internal
- Global Hackathon 2015
- 2 Specialists Who Code
- 10 TR Knowledge Graph
- 150 Transactions
- 142 REDI API
- 1.7K TREP APIs
- 4 CAT
- 21 DACS Station
- 117 Open DACS
- 1.1K RFA
- 103 UPA
- 172 TREP Infrastructure
- 224 TRKD
- 886 TRTH
- 5 Velocity Analytics
- 5 Wealth Management Web Services
- 59 Workspace SDK
- 9 Element Framework
- 5 Grid
- 13 World-Check Data File
- Yield Book Analytics
- 46 中文论坛