Could you please help , how to get General value 6 and General Value 7 columns for CADISC=, USFFT...

RB5NBVICDORSupport

...ARGET=, 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.

Jirapongse

@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:

I hope this will help.

RB5NBVICDORSupport

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?

Jirapongse

https://community.developers.refinitiv.com/discussion/comment/99211#Comment_99211

RB5NBVICDORSupport

Nov 2, 2022

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?

@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.