For a deeper look into our DataScope Select REST API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials

question

Upvotes
Accepted
3 1 1 1

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,

dss-rest-api
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
6.8k 14 5 8

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.
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
31.7k 37 11 19

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.

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.