String formatting of Universal Close Price over $1000
When we pull composite data for an instrument that has a price above $1000, we get a “Universal Close Price” of "\"1,000.0"\". Universal Close Price for other assets under $1000 are normal number values ("69.62" and "90.41").
Is this adjustable so
that we can get the Universal Close Price value back as a simple number (i.e. 1000.00) instead of the
formatted number string?
Best Answer
-
I was able to get feedback through another support stream and wanted to share the answer here.
For existing report templates, field format can be changed within Report Template as shown in below screenshot.
0
Answers
-
Could you please post the body of the request you are making, including the instrument that has a price > 1000$ ?
Are you using an on demand request, or a scheduled request ?
0 -
There is no request body. We have an instrument list setup in DSS along with a Composite report template it runs against at a scheduled time.
The specific instrument is CUSIP 023135106
0 -
An On Demand extraction request does not give you the option to specify field formatting.
A scheduled request that uses a predefined template can have specific field formatting. Here is the body of a request to create a template with a user defined field format for the Universal Close Price:
{
"@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ReportTemplates.EndOfDayPricingReportTemplate",
"ShowColumnHeaders": false,
"Name": "myEodTemplateName",
"Headers": [],
"Trailers": [],
"ContentFields": [
{ "FieldName": "Instrument ID" },
{
"FieldName": "Universal Close Price",
"Format": {
"@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ReportTemplates.ContentFieldNumberFormat",
"DecimalPlaces": 2,
"DecimalSeparator": "Period",
"IntegerPlaces": 10,
"NegativeSignPosition": "Before",
"ThousandSeparator": "None",
"UseLeadingZero": false,
"UseThousandSeparator": false,
"UseTrailingZero": false
}
}
],
"Condition": null
}To get rid of the thousands separator you can specify:
"ThousandSeparator": "None",
and/or
"UseThousandSeparator": false,
Does this help ?
0 -
@trey.g_deprecated_0, thank you for sharing. I was working in parallel on an answer based on the API, which I just posted before seeing your response.
0 -
Your response helps as well as if I am pulling information through the API, I will need to make sure that the thousands separator is excluded there as well.
0 -
Your response helps. We do pull some information through the API, and I will need to make sure that the thousands separator is excluded there as well.
0
Categories
- All Categories
- 3 Polls
- 6 AHS
- 36 Alpha
- 166 App Studio
- 6 Block Chain
- 4 Bot Platform
- 18 Connected Risk APIs
- 47 Data Fusion
- 34 Data Model Discovery
- 690 Datastream
- 1.4K DSS
- 629 Eikon COM
- 5.2K Eikon Data APIs
- 11 Electronic Trading
- 1 Generic FIX
- 7 Local Bank Node API
- 3 Trading API
- 2.9K Elektron
- 1.4K EMA
- 255 ETA
- 559 WebSocket API
- 39 FX Venues
- 15 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 25 Messenger Bot
- 3 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 60 Open Calais
- 279 Open PermID
- 45 Entity Search
- 2 Org ID
- 1 PAM
- PAM - Logging
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 23 RDMS
- 2K Refinitiv Data Platform
- 716 Refinitiv Data Platform Libraries
- 4 LSEG Due Diligence
- LSEG Due Diligence Portal API
- 4 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.2K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 12 World-Check Customer Risk Screener
- 1K World-Check One
- 46 World-Check One Zero Footprint
- 45 Side by Side Integration API
- 2 Test Space
- 3 Thomson One Smart
- 10 TR Knowledge Graph
- 151 Transactions
- 143 REDI API
- 1.8K TREP APIs
- 4 CAT
- 27 DACS Station
- 121 Open DACS
- 1.1K RFA
- 106 UPA
- 194 TREP Infrastructure
- 229 TRKD
- 918 TRTH
- 5 Velocity Analytics
- 9 Wealth Management Web Services
- 95 Workspace SDK
- 11 Element Framework
- 5 Grid
- 19 World-Check Data File
- 1 Yield Book Analytics
- 48 中文论坛