Not receiving any tick history data for OESX fund (RIC: 0#STXE*.EX)

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.

All comments

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.

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?

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?

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.

@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 permitted

How can I get rights for these instruments?

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.

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.

Hi @Jirapongse, how would one get depth data from Times and Sales? Which data is Refinitiv using to construct market depth data?