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.
Best Answer
-
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.
0
Answers
-
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"
}
]
}0 -
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".
0 -
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?
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
- 24 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
- 714 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 中文论坛