Is there a way to query the time/date an instrument becomes available in Refinitiv?

cabissi

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,

raksina.samasiri

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.