Hello, for the date June 9th 2022, RIC EURSW=R, there is a mismatch between Workspace and Datascope Select API in "Days Maturity". In workspace (and bloomberg) it's 8 while from API it's 7.
@Reda_CHAKROUNE
Do you mean how to extract the "Maturity Date" field?
I found this field in the following report templates.
The request message looks like this:
{ "ExtractionRequest": { "@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.EndOfDayPricingExtractionRequest", "ContentFieldNames": [ "Maturity Date" ], "IdentifierList": { "@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.InstrumentIdentifierList", "InstrumentIdentifiers": [ { "Identifier": "EURSW=R", "IdentifierType": "Ric" } ] }, "Condition": null } }
The output is:
"Contents": [ { "IdentifierType": "Ric", "Identifier": "EURSW=R", "Maturity Date": "2026-03-20" } ],
You can refer to the LSEG DataScope Select Data Content Guide that provides definitions of all of the data fields available in LSEG DataScope Select.
The data in DSS is organized into various report templates, and it supports a wide range of them.
You can check the LSEG DataScope Select Data Content Guide or DSS Web UI for the available report templates.
For the request messages, you can refer to the following materials:
Thank you for reaching out to us.
Are you using the following request to extract data?
{ "ExtractionRequest": { "@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.PriceHistoryExtractionRequest", "ContentFieldNames": [ "Days Maturity", "Trade Date" ], "IdentifierList": { "@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.InstrumentIdentifierList", "InstrumentIdentifiers": [ { "Identifier": "EURSW=R", "IdentifierType": "Ric" } ], "ValidationOptions": null, "UseUserPreferencesForValidationOptions": false }, "Condition": { "QueryStartDate": "2022-06-08T00:00:00+01:00", "QueryEndDate": "2022-06-10T00:00:00+01:00" } } }
"Contents": [ { "IdentifierType": "Ric", "Identifier": "EURSW=R", "Days Maturity": 7, "Trade Date": "2022-06-08" }, { "IdentifierType": "Ric", "Identifier": "EURSW=R", "Days Maturity": 7, "Trade Date": "2022-06-09" }, { "IdentifierType": "Ric", "Identifier": "EURSW=R", "Days Maturity": 7, "Trade Date": "2022-06-10" } ],
To verify the data, please contact the Datascope Select support team directly via LSEG Support.
Hello, yes that is indeed the request I use. As you can see the output is 7, while it should be 8 for june 9th 2022. And this is just one example of mismatches I found for this RIC.
@Jirapongse
This forum is not intended for content‑related questions; it is meant for coding and programming logic inquiries.
To verify the data, please contact the Datascope Select support team directly via LSEG Support.
Ok thank you. I have another question, more programming oriented. Is there any way to import maturity/expiration dates? No field seems to be working.
Thank you
Thank you for showing me how it's done. I was missing the
"#DataScope.Select.Api.Extractions.ExtractionRequests.EndOfDayPricingExtractionRequest",
I used same for days maturity:
"#DataScope.Select.Api.Extractions.ExtractionRequests.PriceHistoryExtractionRequest",
How do you know
