EURIBOR EndOfDay Extraction

devtime
devtime Newcomer
edited March 7 in DSS

Hello,

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

image.png

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.

image.png

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.

Answers

  • Jirapongse
    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.

  • devtime
    devtime Newcomer

    Thank you for the quick answer,
    here are the notes from my request:

    "Extraction Services Version 18.3.1.48082 (0d5e6bbb8e4a), Built Jan 10 2025 19:43:09\r\nHoliday Rollover of Universal Close Price waived.\r\nProcessing started at 03/07/2025 09:03:26.\r\nUser ID: 9037195\r\nExtraction ID: 2000000876600116\r\nCorrelation ID: CiD/9037195/AAAAAA.094e190e47fae6cb/RA\r\nSchedule: 0x094e190e480ae6cb (ID = 0x0000000000000000)\r\nInput List (1 items): (ID = 0x094e190e480ae6cb) Created: 03/07/2025 09:03:26 Last Modified: 03/07/2025 09:03:26\r\nReport Template (12 fields): _OnD_0x094e190e480ae6cb (ID = 0x094e190e481ae6cb) Created: 03/07/2025 09:03:25 Last Modified: 03/07/2025 09:03:25\r\nSchedule dispatched via message queue (0x094e190e480ae6cb)\r\nSchedule Time: 03/07/2025 09:03:26\r\n(RIC,EURIBOR1MD=,RCT) row suppressed for lack of 'European Money Markets Institute (EMMI)' permission.\r\nNo prices needed currency scaling.\r\nProcessing completed successfully at 03/07/2025 09:03:26, taking 0.069 Secs.\r\nExtraction finished at 03/07/2025 09:03:26 UTC, with servers: xc17xkxnQ17, QSDHA1 (0.0 secs), QSHC08 (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\n"

    I am getting the same message.

  • Jirapongse
    Jirapongse ✭✭✭✭✭

    It could relate to this permission message. Please contat the DSS support team team directly via MyAccount to verify it.