Is there a way to query the time/date an instrument becomes available in Refinitiv?
I noticed that depends on the time of the day I query Refinitiv DataScope Select, data for a particular instrument may or may not be available. I can get a "Not Found" early in the morning but am able to pull the data later in the day. Is there a way to tell when a particular instrument becomes available for data extract?
There is a field "Asset Set Up Date" which seem to serve the purpose but when I tried to retrieve it for follow example using "https://selectapi.datascope.refinitiv.com/RestApi/v1/Extractions/ExtractWithNotes",
{
"ExtractionRequest": {
"@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.CompositeExtractionRequest",
"ContentFieldNames": [
"Instrument ID Type",
"Instrument ID",
"CUSIP",
"CIN Code",
"SEDOL",
"OCC Code",
"ISIN",
"Ticker",
"RIC",
"Trading Status",
"Asset Set Up Date"
],
"IdentifierList": {
"@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
"InstrumentIdentifiers": [
{
"Identifier": "3133ENJ84",
"IdentifierType": "Cusip"
}
],
"ValidationOptions": null,
"UseUserPreferencesForValidationOptions": true
},
"Condition": {
"ScalableCurrency": false
}
}
}
I got a null for this field
{
"@odata.context": "https://selectapi.datascope.refinitiv.com/RestApi/v1/$metadata#DataScope.Select.Api.Extractions.ExtractionRequests.ExtractionResult",
"Contents": [
{
"IdentifierType": "Cusip",
"Identifier": "3133ENJ84",
"Instrument ID Type": "CSP",
"Instrument ID": "3133ENJ84",
"CUSIP": "3133ENJ84",
"CIN Code": null,
"SEDOL": "BN4D867",
"OCC Code": null,
"ISIN": "US3133ENJ841",
"Ticker": "FFCB",
"RIC": "3133ENJ84=RRPS",
"Trading Status": 1,
"Asset Set Up Date": null
}
],
"Notes": [
"Extraction Services Version 16.1.44123 (ed92f5e3e332), Built Aug 10 2022 01:59:20\r\nHoliday Rollover of Universal Close Price requested.\r\nProcessing started at 20220829 02:03:55 PM.\r\nUser ID: 9024916\r\nExtraction ID: 611348569\r\nCorrelation ID: CiD/9024916/AAAAAA.0825a099cbee2997/RA/EXT.611348569\r\nSchedule: _OnD_0x0825a099cbfe2997 (ID = 0x0825a099cdae2997)\r\nInput List (1 items): _OnD_0x0825a099cbfe2997 (ID = 0825a099cc5e2997) Created: 20220829 02:03:53 PM Last Modified: 20220829 02:03:53 PM\r\nSchedule Time: 20220829 02:03:54 PM\r\nReport Template (17 fields): _OnD_0x0825a099cbfe2997 (ID = 0x0825a099cc0e2997) Created: 20220829 02:03:53 PM Last Modified: 20220829 02:03:53 PM\r\nProcessing completed successfully at 20220829 02:03:55 PM, taking 0.346 Secs.\r\nExtraction finished at 20220829 06:03:55 PM UTC, with servers: x04A06, QSDHA1 (0.0 secs), QSHC12 (0.1 secs)\r\nUsage Summary for User 9024916, Client 110902, Template Type Composite\r\nBase Usage\r\n Instrument Instrument Terms Price\r\n Count Type Subtype Source Source\r\n------- ----------------------------------- ---------------------------- -------------- ----------------------------------------\r\n 1 Agency N/A N/A\r\n-------\r\n 1 Total instrument charged.\r\n 0 Instruments with no reported data.\r\n=======\r\n 1 Instrument in the input list.\r\nNo Evaluated Pricing Service complex usage to report -- 1 Instrument in the input list had no reported data.\r\nWriting RIC maintenance report.\r\n",
"Identifier,IdentType,Source,RIC,RecordDate,MaintType,OldValue,NewValue,Factor,FactorType\r\n"
]
}
Any one has any advise on this?
Thanks,
Best Answer
-
hi @cabissi ,
Case number 11540717 was closed with the following resolution.
Upon checking the above notes file, there was no embargo applied for the CUSIP 3133ENJ84. If the embargo is applied for any of the instruments in the input list, the details will be provided in the notes file.
For more details on the Emargoed Extractions, please refer to the attached DSS User Guide – Page 129.0
Answers
-
Hello @cabissi ,
I suspect that the specific content is not available at a point of time, and later it becomes available, due to the embargo policy. When an instrument is in embargo period it will manifest in Extraction Notes as " Instrument in the input list had no reported data.".
Please see REST API Tutorial 3: On Demand intraday extraction, embargo on processing embargoed content via DSS REST API and Refinitiv DataScope Select GUI User Guide to learn more about the embargos.
To confirm that this instrument is being embargoed and how long the embargo period is, the best approach is to engage with Refintiv content experts directly via: Refinitiv Helpdesk Online -> Content -> DSS. For this question, case #11540717 has been opened on your behalf, please expect our content support expert to reach out to you shortly, via email.
0
Categories
- All Categories
- 6 AHS
- 36 Alpha
- 166 App Studio
- 6 Block Chain
- 4 Bot Platform
- 18 Connected Risk APIs
- 47 Data Fusion
- 33 Data Model Discovery
- 682 Datastream
- 1.4K DSS
- 613 Eikon COM
- 5.2K Eikon Data APIs
- 10 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- 3 Trading API
- 2.9K Elektron
- 1.4K EMA
- 248 ETA
- 552 WebSocket API
- 37 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
- 275 Open PermID
- 44 Entity Search
- 2 Org ID
- 1 PAM
- PAM - Logging
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 22 RDMS
- 1.8K Refinitiv Data Platform
- 625 Refinitiv Data Platform Libraries
- 5 LSEG Due Diligence
- 1 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
- 26 DACS Station
- 121 Open DACS
- 1.1K RFA
- 104 UPA
- 191 TREP Infrastructure
- 228 TRKD
- 915 TRTH
- 5 Velocity Analytics
- 9 Wealth Management Web Services
- 83 Workspace SDK
- 11 Element Framework
- 5 Grid
- 18 World-Check Data File
- 1 Yield Book Analytics
- 46 中文论坛