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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials

question

Upvotes
Accepted
1 0 0 1

SingleHistoricalPriceExtractionRequest Code Sample

Looking for a sample that uses this API.

dss-rest-apidatascope-selectdss
icon clock
10 |1500

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

@v-gehend

Do you have any specific programming language that you are looking for the code sample (such as C# or plain JSON request-response)?

1 Answer

Upvote
Accepted
38.1k 71 35 53

@v-gehend

If you are using C#, you can download the C# Example Application from https://developers.refinitiv.com/en/api-catalog/datascope-select/datascope-select-rest-api/download.

The sample for SingleHistoricalPriceExtractionRequest is under On Demand Extractions -> Create: Single Historical Price (Pricing Data) without Notes.

The snippet code is:

var ExtractionsContext = new ExtractionsContext(new Uri("https://hosted.datascopeapi.reuters.com/RestApi/v1/"), "<your user id>", "<your password>");

var availableFields = ExtractionsContext.GetValidContentFieldTypes(ReportTemplateTypes.TimeseriesPricing);

//Create a new end of day report template
var extractionRequest = new SingleHistoricalPriceExtractionRequest
{
    IdentifierList = InstrumentIdentifierList.Create(
        new[] { new InstrumentIdentifier { Identifier = "IBM.N", IdentifierType = IdentifierType.Ric } }, null, false),
    ContentFieldNames = new[] {
        "Close Price", "Bid Price", "Ask Price", "Trade Date", "CUSIP", "RIC", "Security Description",
        "Alternate Close Price", "Low Price", "High Price", "Mid Price", "Open Price", "Instrument ID"},
    Condition = new SingleHistoricalPriceCondition
    {
        LookBackPeriod = LookbackType.OneMonth,
        PriceDate = DateTime.UtcNow
    }
};

//Output
if (!extractedRows.Any())
    Debug.WriteLine("No rows returned");
else
{
    foreach (var row in extractedRows)
        Console.WriteLine(
            row.Identifier + " (" + row.IdentifierType + ") " +
            String.Join(", ", row.DynamicProperties.Select(dp => dp.Key + "=" + dp.Value)));
}
icon clock
10 |1500

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

Click below to post an Idea Post Idea