Hi Team,
Do we have an option to adjust decimal places in DSS API?
Upon checking in DSS GUI, we do have an option to change the decimal places in report template for fields (please see attached image).
I want to know if it is also possible to have the same option in DSS API?
For example, I want the values of this API Request to provide only whole numbers (without decimal) for the given RIC using Price History Template.
{
"ExtractionRequest": {
"@odata .type": "#DataScope.Select.Api.Extractions.ExtractionRequests.PriceHistoryExtractionRequest",
"ContentFieldNames": [
"Low Price",
"Open Interest",
"Settlement Price",
"Open Price",
"High Price",
"Accumulated Volume Unscaled",
"Trade Date",
"Universal Close Price"
],
"IdentifierList": {
"@odata .type": "#DataScope.Select.Api.Extractions.ExtractionRequests.InstrumentIdentifierList","InstrumentIdentifiers": [
{ "Identifier": "TIIN.NS", "IdentifierType": "Ric" }
],
"ValidationOptions" :
{
"AllowOpenAccessInstruments":true
}
},
"Condition": {
"AdjustedPrices": true,
"QueryStartDate": "2025-07-11T00:00:00.000Z",
"QueryEndDate": "2025-07-15T00:00:00.000Z"
}
}
}
Response:
{
"@odata .context": "https://selectapi.datascope.refinitiv.com/RestApi/v1/$metadata#DataScope.Select.Api.Extractions.ExtractionRequests.ExtractionResult",
"Contents": [
{
"IdentifierType": "Ric",
"Identifier": "TIIN.NS",
"Low Price": 22.367608,
"Open Interest": null,
"Settlement Price": null,
"Open Price": 22.74672,
"High Price": 22.936276,
"Accumulated Volume Unscaled": 386081.158075,
"Trade Date": "2025-07-11",
"Universal Close Price": 22.557164
},
{
"IdentifierType": "Ric",
"Identifier": "TIIN.NS",
"Low Price": 22.206485,
"Open Interest": null,
"Settlement Price": null,
"Open Price": 22.557164,
"High Price": 22.74672,
"Accumulated Volume Unscaled": 402367.638059,
"Trade Date": "2025-07-14",
"Universal Close Price": 22.301263
},
{
"IdentifierType": "Ric",
"Identifier": "TIIN.NS",
"Low Price": 22.348652,
"Open Interest": null,
"Settlement Price": null,
"Open Price": 22.405519,
"High Price": 22.670898,
"Accumulated Volume Unscaled": 283064.635253,
"Trade Date": "2025-07-15",
"Universal Close Price": 22.57612
}
],
"Notes": [
"Extraction Services Version 18.3.1.48082 (0d5e6bbb8e4a), Built Jan 10 2025 19:43:09\r\nProcessing started at 10/13/2025 22:53:32.\r\nUser ID: 9036089\r\nExtraction ID: 2000001021948943\r\nCorrelation ID: CiD/9036089/AAAAAA.0994f9bdbcab6735/RA\r\nSchedule: 0x0994f9bdbcbb6735 (ID = 0x0000000000000000)\r\nInput List (1 items): (ID = 0x0994f9bdbcbb6735) Created: 10/13/2025 22:53:32 Last Modified: 10/13/2025 22:53:32\r\nReport Template (14 fields): _OnD_0x0994f9bdbcbb6735 (ID = 0x0994f9bdbccb6735) Created: 10/13/2025 22:53:30 Last Modified: 10/13/2025 22:53:30\r\nSchedule dispatched via message queue (0x0994f9bdbcbb6735)\r\nSchedule Time: 10/13/2025 22:53:32\r\nTimeseries Date Range: 07/11/2025 to 07/15/2025\r\nProcessing completed successfully at 10/13/2025 22:53:33, taking 0.803 Secs.\r\nExtraction finished at 10/13/2025 22:53:33 UTC, with servers: xc74jaduq02, ETS (0.7 secs), QSDHA1 (0.0 secs), QSHC09 (0.0 secs)\r\nUsage Summary for User 9036089, Client 65507, Template Type Price History\r\nBase Usage\r\n Instrument Instrument Terms Price\r\n Count Type Subtype Source Source\r\n------- ----------------------------------- ---------------------------- -------------- ----------------------------------------\r\n 1 Equities N/A N/A\r\n-------\r\n 1 Total instrument charged.\r\n 0 Instruments with no reported data.\r\n=======\r\n 1 Instrument in the input list.\r\nNo Evaluated Pricing Service complex usage to report -- 1 Instrument in the input list had no reported data.\r\nWriting RIC maintenance report.\r\n",
"Identifier,IdentType,Source,RIC,RecordDate,MaintType,OldValue,NewValue,Factor,FactorType\r\n"
]
}
Regards,
Joshua
