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,
