extractions.tick_history_time_and_sales not working

requesting fields = ["Trade - Price"] for 'Identifier': '.VIX' for a full day of quotes 2022-09-29 to 2022-09-30
Getting empty string today.. Works everyday.
Are there any outages that explain this?
Best Answer
-
Hello @tr.tickhistory ,
I see the same as my colleague @Jirapongse and I believe this is the same as you see as well:
Request:
{{protocol}}{{host}}{{api}}Extractions/ExtractRaw
{
"ExtractionRequest": {
"@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.TickHistoryTimeAndSalesExtractionRequest",
"ContentFieldNames": [
"Quote - Ask Price",
"Quote - Ask Size"
],
"IdentifierList": {
"@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
"InstrumentIdentifiers": [{
"Identifier": ".VIX",
"IdentifierType": "Ric"
}]
},
"Condition": {
"MessageTimeStampIn": "GmtUtc",
"ApplyCorrectionsAndCancellations": false,
"ReportDateRangeType": "Range",
"QueryStartDate": "2022-09-29T00:00:00.000Z",
"QueryEndDate": "2022-09-30T00:00:00.000Z",
"DisplaySourceRIC": true
}
} }Results for me in:
{
"@odata.context": "https://selectapi.datascope.refinitiv.com/RestApi/v1/$metadata#RawExtractionResults/$entity",
"JobId": "0x08314e7436d33bbb",
"Notes": [
"Extraction Services Version 16.1.44123 (ed92f5e3e332), Built Aug 10 2022 01:55:41\nUser ID: 19945\nExtraction ID: 2000000456226425\nCorrelation ID: CiD/19945/AAAAAA.08314e7436c33bbb/RA\nSchedule: 0x08314e7436d33bbb (ID = 0x0000000000000000)\nInput List (1 items): (ID = 0x08314e7436d33bbb) Created: 10/04/2022 19:18:56 Last Modified: 10/04/2022 19:18:56\nReport Template (2 fields): _OnD_0x08314e7436d33bbb (ID = 0x08314e7436e33bbb) Created: 10/04/2022 19:18:54 Last Modified: 10/04/2022 19:18:54\nSchedule dispatched via message queue (0x08314e7436d33bbb)\nSchedule Time: 10/04/2022 19:18:55\nProcessing started at 10/04/2022 19:18:55\nProcessing completed successfully at 10/04/2022 19:18:56\nExtraction finished at 10/04/2022 19:18:56 UTC, with servers: x02q13\nInstrument <RIC,.VIX> expanded to 1 RIC: .VIX.\nTotal instruments after instrument expansion = 1\n\n(RIC,.VIX,MXP) row suppressed for lack of 'MXP (CBOE CSMI)' permission.\nReport suppressed because no instruments are permitted\n"
]
}I.e. I lack the permissions to request this content.
When I look up my user profile via DSS GUI, I see the none for CBOE CSME MXP permissions- I am not permissioned for the content:
I can venture a guess as to why you were able to see this content previously- there was a PCN about content normalization issued: PCN204885-Tick History Content Changes – October 2022 . Some content was normalized/cleaned up and this may have resulted in access to this content requiring explicit permissioning assigned going forward.
However, to get a definitive explanation on this specific content permissions requirement, it is best to contact Refinitiv Tick History content experts via Refinitiv Helpdesk Online -> Content -> RTH directly.
Let us know if you are unable to proceed- will help by opening a content support case on your behalf.
0
Answers
-
Hello @tr.tickhistory ,
I am not sure if you are requesting programmatically, or via Datascope GUI. If you are requesting programmatically, and your code was working consistently before, you can be sure this is not an API usage/coding-related issue.
In My Refintiiv -> Service Alerts I see several Refintiv Tick History - Planned Maintenance notifications, stating that users may experience disruptions, I think #270353 is the relevant alert, should be still in progress:
please note that the time of completion is estimated.
Hope that this information helps
0 -
Thanks Zoya
I'm requesting programatically and indeed it was working fine till last week every day.
The above alert seems relevant but it seems to suggest that outage will only be on 9Oct22. This function hasn't been working since approx 7:00 GMT 3Oct22.
Is there any fix / alternate way to get this data?
I'm after historic VIX spot data sampled every 5min (I'm extracting tick-data here and downsampling it).
Regards
0 -
Sorry about the issue that you are facing.
I ran the TickHistoryTimeAndSalesExtractionRequest and got the following notes.
"Notes": [
"Extraction Services Version 16.1.44123 (ed92f5e3e332), Built Aug 10 2022 01:55:41\nUser ID: 9008895\nExtraction ID: 2000000455986240\nCorrelation ID: CiD/9008895/AAAAAA.08314d2e0c633b89/RA\nSchedule: 0x08314d2e0c733b89 (ID = 0x0000000000000000)\nInput List (1 items): (ID = 0x08314d2e0c733b89) Created: 10/04/2022 10:04:02 Last Modified: 10/04/2022 10:04:02\nReport Template (6 fields): _OnD_0x08314d2e0c733b89 (ID = 0x08314d2e0c833b89) Created: 10/04/2022 10:04:00 Last Modified: 10/04/2022 10:04:00\nSchedule dispatched via message queue (0x08314d2e0c733b89)\nSchedule Time: 10/04/2022 10:04:01\nProcessing started at 10/04/2022 10:04:01\nProcessing completed successfully at 10/04/2022 10:04:02\nExtraction finished at 10/04/2022 09:04:02 UTC, with servers: x01q13\nInstrument <RIC,.VIX> expanded to 1 RIC: .VIX.\nTotal instruments after instrument expansion = 1\n\n(RIC,.VIX,MXP) row suppressed for lack of 'MXP (CBOE CSMI)' permission.\nReport suppressed because no instruments are permitted\n"
]
}Did you get any notes when performing the extraction?
Typically, you can check the notes to verify why there is no data when performing the extraction.
I hope that this information is of help
0 -
I see that the Rest API doesn't support ExtractWithNotes for
Times and Sales
data.So I don't see any Notes (I'm using an
ExtractRaw
API call).What do you see as the result of the extraction? Does it return any data?
0 -
The ExtractRaw supports Notes. It is in the HTTP response if the HTTP status code is 200.
If the HTTP status code of the ExtractRaw is 202, the Notes is in the response of the Extractions/ExtractRawResult(ExtractionId='<Extraction ID>') end point.
0 -
Looks like I am using a different endpoint.
See below the http response i get. Shows 0b content.
Could you pls suggest a solution? Does the response to your request get some data?
0 -
Hello @tr.tickhistory ,
The endpoint that you use to extract result is correct:
{{protocol}}{{host}}{{api}}Extractions/RawExtractionResults('{{jobId}}')/$value
The part after "RawExtractionResults(" that is different is jobID.
Please refer to tutorial REST API Tutorial 4: On Demand tick data extraction for a brief intro on the required steps to process TimeAndSales on demand request.
The section Request tick data - HTTP response discusses jobId in response.
Hope this information is helpful
0 -
My requests were returning data till last week.. They have stopped since yesterday. Can you please confirm if there is an outage or if you also see no data while requesting historical Time and Sales for .VIX spot?
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
- 695 Datastream
- 1.5K DSS
- 631 Eikon COM
- 5.2K Eikon Data APIs
- 12 Electronic Trading
- 1 Generic FIX
- 7 Local Bank Node API
- 4 Trading API
- 2.9K Elektron
- 1.4K EMA
- 255 ETA
- 561 WebSocket API
- 39 FX Venues
- 15 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 25 Messenger Bot
- 3 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 60 Open Calais
- 281 Open PermID
- 46 Entity Search
- 2 Org ID
- 1 PAM
- PAM - Logging
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 23 RDMS
- 2K Refinitiv Data Platform
- 734 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
- 106 UPA
- 194 TREP Infrastructure
- 229 TRKD
- 918 TRTH
- 5 Velocity Analytics
- 9 Wealth Management Web Services
- 96 Workspace SDK
- 11 Element Framework
- 5 Grid
- 19 World-Check Data File
- 1 Yield Book Analytics
- 48 中文论坛