EURIBOR EndOfDay Extraction

devtime

Hello,

I am trying to retrieve the EURIBOR rates from this Ric with an EndOfDayPricingExtractionRequest.

And the API is returning a null value. However, on the Datascope Select GUI there are values for these fields, only from two days before.

So my question is, is there any way to retrieve the first row through the API? Or do I have to do a PriceHistoryExtractionRequest API call? I wanted to avoid specifying the date in my request body.

Jirapongse

@devtime

Thank you for reaching out to us.

Can you share the "Notes" in the response?

I tested the EndOfDayPricingExtractionRequest and found that I don't have permission to request this item.

    "Notes": [        "Extraction Services Version 18.3.1.48082 (0d5e6bbb8e4a), Built Jan 10 2025 19:43:09\r\nHoliday Rollover of Universal Close Price waived.\r\nUser has overridden estimates broker entitlements.\r\nProcessing started at 03/07/2025 PM 05:10:50.\r\nUser ID: 9008895\r\nExtraction ID: 2000000876630613\r\nCorrelation ID: CiD/9008895/AAAAAA.094e12fd676ae680/RA\r\nSchedule: 0x094e12fd677ae680 (ID = 0x0000000000000000)\r\nInput List (1 items):  (ID = 0x094e12fd677ae680) Created: 03/07/2025 PM 05:10:50 Last Modified: 03/07/2025 PM 05:10:50\r\nReport Template (73 fields): _OnD_0x094e12fd677ae680 (ID = 0x094e12fd678ae680) Created: 03/07/2025 PM 05:10:49 Last Modified: 03/07/2025 PM 05:10:49\r\nSchedule dispatched via message queue (0x094e12fd677ae680)\r\nSchedule Time: 03/07/2025 PM 05:10:49\r\n(RIC,EURIBOR1MD=,RCT)  row suppressed for lack of 'European Money Markets Institute (EMMI)' permission.\r\nProcessing completed successfully at 03/07/2025 PM 05:10:50, taking 0.093 Secs.\r\nExtraction finished at 03/07/2025 AM 10:10:50 UTC, with servers: xc27en3nQ16, QSDHA1 (0.0 secs), QSHC05 (0.0 secs)\r\nNo usage to report -- 1 Instrument in the input list had no reported data.\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"    ]

However, it works with the PriceHistoryExtractionRequest.

{

    "ExtractionRequest": {

        "@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.PriceHistoryExtractionRequest",

        "ContentFieldNames": [

            "RIC",

            "Trade Date",

            "Universal Close Price"

        ],

        "IdentifierList": {

            "@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",

            "InstrumentIdentifiers": [

                {

                    "Identifier": "EURIBOR1MD=",

                    "IdentifierType": "Ric"

                }

            ],

            "ValidationOptions": {

                "AllowHistoricalInstruments": true

            }

        },

        "Condition": {

            "AdjustedPrices": true,

            "QueryStartDate": "2025-03-03",

            "QueryEndDate": "2025-03-05"

        }

    }

}

You may need to contat the DSS support team team directly via MyAccount to verify the content.