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 dimitrakopoulos · Jun 08, 2020 at 03:16 PM · datascope selectbondspricespercentage

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.farberov · 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.farberov · 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.farberov · 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

Cash flow bond structure using Datascope Select API

Convert or map TICKER to RIC using the DSS API

Do I have any contract restriction to receive the following message? I'm trying to extract Market Depth from US Stock equities.

Requesting details on Datascope market and trade data extracts

Block Trades fields in DataScope only available for certain Exchanges?

  • 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