New posts are disabled while we improve the user experience.

You can browse the site, or for urgent issues, raise a query at MyAccount.

question

Upvotes
Accepted
rahul.deshmukh avatar image
23 ●11 ●18 ●24

How to get DSS EndOfDayPricingExtractionRequest historical data

Dear All,

We are using below DSS EndOfDayPricingExtractionRequest which is working fine.

{
   "ExtractionRequest":{
      "@odata.type":"#DataScope.Select.Api.Extractions.ExtractionRequests.EndOfDayPricingExtractionRequest",
      "ContentFieldNames":[
         "RIC",
         "Security Description",
         "Universal Close Price Date",
         "Universal Close Price",
         "Base Currency Code"
      ],
      "IdentifierList":{
         "@odata.type":"#DataScope.Select.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
         "InstrumentIdentifiers":[
            { "Identifier":"USF=", "IdentifierType":"Ric" },
            { "Identifier":"USFFTARGET=", "IdentifierType":"Ric" },
            { "Identifier":"ECBDF=ECBF", "IdentifierType":"Ric" },
            { "Identifier":"SARON.S", "IdentifierType":"Ric" },
            { "Identifier":"SONIAOSR=", "IdentifierType":"Ric" },
            { "Identifier":"EUROND=", "IdentifierType":"Ric" },
            { "Identifier":"CORRA=", "IdentifierType":"Ric" },
            { "Identifier":"AUDOND=", "IdentifierType":"Ric" },
            { "Identifier":"JPONMU=RR", "IdentifierType":"Ric" }
         ],
         "ValidationOptions":null,
         "UseUserPreferencesForValidationOptions":false
      },
      "Condition":null
   }
}


But now the requirement is to load the historical data starting from 01.01.2023 till today(Initial Load). Can you please tell us how to get historical data from the above request ? Can we put start and end date filter in the above request ?


Thanks and regards,

Rahul D

#technologydss-rest-apidsson-demand-extraction
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.

2 Answers

· Write an Answer
Upvote
Accepted
Jirapongse avatar image
87.8k ●294 ●53 ●79

@rahul.deshmukh

Thank you for reaching out to us.

The EndOfDayPricingExtractionRequest extraction doesn't support the start date and end date fields.

You can try the PriceHistoryExtractionRequest extraction. 

{
  "ExtractionRequest": {
    "@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.PriceHistoryExtractionRequest",
    "ContentFieldNames":[
         "RIC",
         "Security Description",
         "Trade Date",
         "Universal Close Price",
         "Base Currency Code"
      ],
    "IdentifierList": {
      "@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",  
      "InstrumentIdentifiers": [
            { "Identifier":"USF=", "IdentifierType":"Ric" },
            { "Identifier":"USFFTARGET=", "IdentifierType":"Ric" },
            { "Identifier":"ECBDF=ECBF", "IdentifierType":"Ric" },
            { "Identifier":"SARON.S", "IdentifierType":"Ric" },
            { "Identifier":"SONIAOSR=", "IdentifierType":"Ric" },
            { "Identifier":"EUROND=", "IdentifierType":"Ric" },
            { "Identifier":"CORRA=", "IdentifierType":"Ric" },
            { "Identifier":"AUDOND=", "IdentifierType":"Ric" },
            { "Identifier":"JPONMU=RR", "IdentifierType":"Ric" }
         ],
      "ValidationOptions": { "AllowHistoricalInstruments": true },
      "UseUserPreferencesForValidationOptions": false
    },
    "Condition": {
      "AdjustedPrices": true,
      "QueryStartDate": "2023-05-24",
      "QueryEndDate": "2023-05-31"
    }
  }
}

To see the list of all avaible for each extraction request, please refer to the REST API Reference Tree.

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.

rahul.deshmukh avatar image rahul.deshmukh

Thanks for the reply. Its working. Does EndOfDayPricingExtractionRequest and PriceHistoryExtractionRequest are same ? Also the does the field Trade Date are same as Universal Close Price Date ?

Upvote
Jirapongse avatar image
87.8k ●294 ●53 ●79

@rahul.deshmukh

They are different templates so they are not the same.

  • EOD Pricing reports provide initial and validated end of day prices for all exchange‐traded instruments from the real‐time network. Non‐exchange‐traded instruments are sourced from our Evaluated Pricing Service, as well as from various contributors
  • Price History & Single Price History reports provide historical pricing from as far back as 1980

The PriceHistoryExtractionRequest extraction doesn't have the "Universal Close Price Date" field so I used the "Trade Date" field instead. You can contact the DataScope Select support team directly via MyRefinitiv for more information.

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.

rahul.deshmukh avatar image rahul.deshmukh
ok thanks for the information @Jirapongse

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.