Discover Refinitiv
MyRefinitiv Refinitiv Perspectives Careers
Created with Sketch.
All APIs Questions & Answers  Register |  Login
Ask a question
  • Questions
  • Tags
  • Badges
  • Unanswered
Search:
  • Home /
  • DSS /
avatar image
Question by trey.g · Dec 28, 2018 at 08:16 AM · jsoncompositeuniversal close priceformatting

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?

People who like this

0 Show 2
Comment
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

avatar image
REFINITIV
Christiaan Meihsl ♦♦ · Dec 28, 2018 at 08:35 AM 0
Share

@5c51420f-25d5-4998-b87c-84fcfa4c5225,

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 ?

avatar image
trey.g Christiaan Meihsl ♦♦ · Dec 28, 2018 at 08:40 AM 0
Share

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

2 Replies

  • Sort: 
avatar image
Best Answer
Answer by trey.g · Dec 28, 2018 at 08:46 AM

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.


universal-close-price-1.jpg (35.0 KiB)
universal-close-price-2.jpg (80.1 KiB)
Comment
Christiaan Meihsl

People who like this

1 Show 2 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

avatar image
REFINITIV
Christiaan Meihsl ♦♦ · Dec 28, 2018 at 09:22 AM 0
Share

@5c51420f-25d5-4998-b87c-84fcfa4c5225, thank you for sharing. I was working in parallel on an answer based on the API, which I just posted before seeing your response.

avatar image
trey.g Christiaan Meihsl ♦♦ · Dec 28, 2018 at 10:29 AM 0
Share

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.

avatar image
REFINITIV
Answer by Christiaan Meihsl · Dec 28, 2018 at 09:21 AM

@5c51420f-25d5-4998-b87c-84fcfa4c5225,

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 ?

Comment
trey.g

People who like this

1 Show 1 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

avatar image
trey.g · Dec 28, 2018 at 10:30 AM 0
Share

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.

Watch this question

Add to watch list
Add to your watch list to receive emailed updates for this question. Too many emails? Change your settings >
10 People are following this question.

Related Questions

Why when pulling data using the RIC the values are correct but it is showing Null when using the ISIN?

Calling the API for specific ccy pairs

Timezone London - How to make sure its correct

Generating custom solutions reports with FTP/SFTP

Some Instruments not returning correct data for Composite Extraction

  • Feedback
  • Copyright
  • Cookie Policy
  • Privacy Statement
  • Terms of Use
  • Careers
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Alpha
  • App Studio
  • Block Chain
  • Bot Platform
  • Calais
  • Connected Risk APIs
  • DSS
  • Data Fusion
  • Data Model Discovery
  • Datastream
  • Eikon COM
  • Eikon Data APIs
  • Elektron
    • EMA
    • ETA
    • WebSocket API
  • Legal One
  • Messenger Bot
  • Messenger Side by Side
  • ONESOURCE
    • Indirect Tax
  • Open PermID
    • Entity Search
  • Org ID
  • PAM
    • PAM - Logging
  • ProView
  • ProView Internal
  • Product Insight
  • Project Tracking
  • Refinitiv Data Platform
    • Refinitiv Data Platform Libraries
  • Rose's Space
  • Screening
    • Qual-ID API
    • Screening Deployed
    • Screening Online
    • World-Check One
    • World-Check One Zero Footprint
  • Side by Side Integration API
  • TR Knowledge Graph
  • TREP APIs
    • CAT
    • DACS Station
    • Open DACS
    • RFA
    • UPA
  • TREP Infrastructure
  • TRIT
  • TRKD
  • TRTH
  • Thomson One Smart
  • Transactions
    • REDI API
  • Velocity Analytics
  • Wealth Management Web Services
  • World-Check Data File
  • Explore
  • Tags
  • Questions
  • Badges