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 /

For a deeper look into our DataScope Select REST API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials

avatar image
Question by dimitrakopoulos · Jun 08, 2020 at 03:16 PM · dss-rest-apidatascope-selectdsspricingbonds

Convention of Pricing (Percentages)

While placing the service call { {protocol}}{ {host}}{ {api}}Extractions/ExtractWithNotes with the following body:

{
  "ExtractionRequest": {
    "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.PriceHistoryExtractionRequest",
    "ContentFieldNames": [
      "Trade Date",
      "Universal Close Price",
      "Currency Code",
      "Exchange Code"
    ],
    "IdentifierList": {
      "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",  
      "InstrumentIdentifiers": [
          { "Identifier": "US212616010=RRPS", "IdentifierType": "Ric"}
      ]
      },
    "Condition": {
      "AdjustedPrices": false,
      "QueryStartDate": "1980-01-01T00:00:00.000Z",
      "QueryEndDate": "2020-03-12T00:00:00.000Z"
    }
  }
}

, the data returned is in percentage form (e.g. 100.4325, 99.125 etc.) - this of course makes sense since the specific Ric is a Bond (ISIN USU0242AAD47 to be precise). Is there any attribute we could request back in the ContectFieldNames node that would indicate the returned price is a percentage? We are looking into converting the data to nominal prices (i.e. 1.004325, 0.99125 etc.) hence we would need an identifier that would help us distinguish whether we should divide by 100.00 or not.

People who like this

0 Show 0
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.

4 Replies

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by zoya faberov · Jun 09, 2020 at 07:55 PM

Hello @dimitrakopoulos,

To me, it seems, this will work, and will save you an extra search request.

I would either test it on all different types of instruments on your requirements list, to confirm that the granularity of Asset Type is always sufficient for this purpose,

Or, as a customer, you can confirm if this will be sufficient with Refinitiv content experts, by opening a support case on Refinitiv Content Helpdesk online, or over the phone, dialing your local Refinitiv Helpdesk number.

Comment

People who like this

0 Show 0 · 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
Answer by zoya faberov · Jun 08, 2020 at 08:36 PM

Hello @dimitrakopoulos,

Don't think there is such as you describe, but instead you may be able to know when it's a percentage by running a search that returns InstrumentType.

For example

{
                {protocol}}{
                {host}}{
                {api}}Search/InstrumentSearch
{
  "SearchRequest": {
    "InstrumentTypeGroups": [
      "CollatetizedMortgageObligations",
      "Commodities",
      "Equities",
      "FuturesAndOptions",
      "GovCorp",
      "MortgageBackedSecurities",
      "Money",
      "Municipals",
      "Funds"
    ],
    "IdentifierType": "Ric",
    "Identifier": "US10YT=RRPS,JPY=,IBM.N, INVALID.RIC",
    "PreferredIdentifierType": "Ric"
  }
}

Results in

{
    "@odata.context": "https://hosted.datascopeapi.reuters.com/RestApi/v1/$metadata#Collection(ThomsonReuters.Dss.Api.Content.ValidatedInstrument)",
    "value": [
        {
            "Identifier": "IBM.N",
            "IdentifierType": "Ric",
            "Source": "NYS",
            "Key": "VjF8MHgwMDAzZGQwMDEzNzlkNDYwfDB4MDAwM2RjMDA0YTAyNGZkOHxOWVN8RVFRVXxFUVRZfE9EU0h8RXx8SUJNLk58MDA3Nw",
            "Description": "INTERNATIONAL BUSINESS MACHINES ORD",
            "InstrumentType": "EquityQuote",
            "Status": "Valid"
        },
        {
            "Identifier": "JPY=",
            "IdentifierType": "Ric",
            "Source": "RCT",
            "Key": "VjF8MHgwMDEwMGIwMDAzMGE5MDEyfDB4MDAwM2RjMDAzNDcyZjc2ZXxSQ1R8TU5RVXxNT05ZfE1PTll8WXx8SlBZPXwwMTQz",
            "Description": "US Dollar/Japanese Yen FX Spot Rate",
            "InstrumentType": "MoneyMarketQuote",
            "Status": "Valid"
        },
        {
            "Identifier": "US10YT=RRPS",
            "IdentifierType": "Ric",
            "Source": "EJV",
            "Key": "VjF8MHgwMDEwMmM4ZmU4ODQyMWZlfDB4MDAxMDJjNjYzNmFlMjFlM3xFSlZ8R0NCRHxHT1ZUfEdCTkR8R3xOfFVTMTBZVD1SUlBTfEdPUlA",
            "Description": "UST    0.625 05/15/30",
            "InstrumentType": "GovCorpBond",
            "Status": "Valid"
        }
    ]
}


Comment

People who like this

0 Show 0 · 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
Answer by zoya faberov · Jun 08, 2020 at 08:51 PM

To see the complete reference on any DSS Request API request, refer to REST API Reference Tree

and for additional clarification from Refinitiv content experts, as a customer, use Refinitiv Content Helpdesk to open a support case in product=DSS by "I need help finding content".

Comment

People who like this

0 Show 0 · 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
Answer by dimitrakopoulos · Jun 09, 2020 at 06:51 AM

Thank you for your quick answer! Would it be an option to also use the "Asset Type" attribute delivered by the { {protocol}}{ {host}}{ {api}}Extractions/ExtractWithNotes call? Is this a sort of identifier that could be used to distinguish between percentage prices and normal prices?


screenshot-2020-06-09-at-083443.png (266.8 KiB)
Comment

People who like this

0 Show 0 · 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.

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 >
12 People are following this question.

Related Questions

Details of Matured Bond

How soon does current day data arrive?

Intraday request frequency

I am unable to download EOD data for 11 exchanges -> NMQ, NSQ,NYQ,TFF,BTQ,VTX,ICA,ASQ,PCQ,FKA,NAQ.

DSS SOAP Extract from SAP

  • Copyright
  • Cookie Policy
  • Privacy Statement
  • Terms of Use
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Alpha
  • App Studio
  • Block Chain
  • Bot Platform
  • Connected Risk APIs
  • DSS
  • Data Fusion
  • Data Model Discovery
  • Datastream
  • Eikon COM
  • Eikon Data APIs
  • Electronic Trading
    • Generic FIX
    • Local Bank Node API
    • Trading API
  • Elektron
    • EMA
    • ETA
    • WebSocket API
  • Intelligent Tagging
  • Legal One
  • Messenger Bot
  • Messenger Side by Side
  • ONESOURCE
    • Indirect Tax
  • Open Calais
  • Open PermID
    • Entity Search
  • Org ID
  • PAM
    • PAM - Logging
  • ProView
  • ProView Internal
  • Product Insight
  • Project Tracking
  • RDMS
  • 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
  • TRKD
  • TRTH
  • Thomson One Smart
  • Transactions
    • REDI API
  • Velocity Analytics
  • Wealth Management Web Services
  • Workspace SDK
    • Element Framework
    • Grid
  • World-Check Data File
  • 中文论坛
  • Explore
  • Tags
  • Questions
  • Badges