question

Upvotes
Accepted
1 0 0 1

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?

python apitrth-rest-apimarket-feed
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
56.1k 145 45 65

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.

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.

Hi @Jirapongse, how would one get depth data from Times and Sales? Which data is Refinitiv using to construct market depth data?
@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.

Upvotes
56.1k 145 45 65

@ivan.lovrencic

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.

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
1 0 0 1

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?

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
1 0 0 1

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?

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.

@ivan.lovrencic

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.
Upvotes
1 0 0 1

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

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.

@ivan.lovrencic

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.