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.
For a deeper look into our DataScope Select REST API, look into:
Overview | Quickstart | Documentation | Downloads | Tutorials
15
●0 ●6 ●8
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?
Hello @RB5NBVICDORSupport
Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?
If so please can you click the 'Accept' text next to the appropriate reply? This will guide all community members who have a similar question.
Thanks,
AHS
Hi,
Please be informed that a reply has been verified as correct in answering the question, and marked as such.
Thanks,
AHS
79.2k
●251 ●52 ●74
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.
15
●0 ●6 ●8
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?
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.
