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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials

question

Upvotes
Accepted
15 0 2 6

Could you please help , how to get General value 6 and General Value 7 columns for CADISC=, USFFTARGET=, CABANK= RIC's using New History Pricing Report?

We are extracting data using New Pricing History report for CADISC=, USFFTARGET=, CABANK= RIC's and not able to find the columns names General Value6 and General value7.Could you please help us to get those column in report.

dss-rest-apidssdatascope-select#contentdss-gui
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.

Upvotes
Accepted
55.7k 144 45 65

@RB5NBVICDORSupport

Sorry for the issue you are facing, let me see if I can help you in resolving this.

I checked and found that the "General Value6" and "General Value7" are available in the Intraday Pricing report template.

 {
            "Code": "IDP.General Value6",
            "Name": "General Value6",
            "Description": "Generic field populated with market- or issue-specific data. The content in this field depends on the instrument type and the market.",
            "FormatType": "Number",
            "FieldGroup": " "
        },
        {
            "Code": "IDP.General Value6 Text",
            "Name": "General Value6 Text",
            "Description": "Generic six-character text fields each describing the value in General Value6.",
            "FormatType": "Text",
            "FieldGroup": " "
        },
        {
            "Code": "IDP.General Value7",
            "Name": "General Value7",
            "Description": "Generic field populated with market- or issue-specific data. The content in this field depends on the instrument type and the market.",
            "FormatType": "Number",
            "FieldGroup": " "
        },
        {
            "Code": "IDP.General Value7 Text",
            "Name": "General Value7 Text",
            "Description": "Generic six-character text fields each describing the value in General Value7.",
            "FormatType": "Text",
            "FieldGroup": " "
        },
 

You can refer to the Refinitiv DataScope Select Data Content Guide for a list of fields available in each report template.

The request looks like this:

{
    "ExtractionRequest": {
        "@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.IntradayPricingExtractionRequest",
        "ContentFieldNames": [
            "RIC",
            "General Value6",
            "General Value6 Text",
            "General Value7",
            "General Value7 Text"           

        ],
        "IdentifierList": {
            "@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
            "InstrumentIdentifiers": [
                {
                    "Identifier": "CADISC=",
                    "IdentifierType": "Ric"
                },
                {
                    "Identifier": "USFFTARGET=",
                    "IdentifierType": "Ric"
                },
                {
                    "Identifier": "CABANK=",
                    "IdentifierType": "Ric"
                }
            ],
            "ValidationOptions": {
                "AllowOpenAccessInstruments": true
            },
            "UseUserPreferencesForValidationOptions": false
        },
        "Condition": {
            "ScalableCurrency": false,
            "OnlyNonEmbargoedData": false
        }
    }
}

The output is:

1667370355616.png

I hope this will help.


1667370355616.png (95.9 KiB)
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.

Upvotes
15 0 2 6

Yes using Intraday Pricing report we can get those General Value6 and General Value7 columns. I am looking for those columns in New History Pricing report also. Is it possible to get those columns in New History Pricing report also?

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.

@RB5NBVICDORSupport

Currently, the History Pricing report doesn't have those fields. It could be an enhancement request to add those fields to the History Pricing report.

Please contact the Datascope Select support team directly via MyRefinitv to discuss this requirement with the Product team.