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 · Dec 05, 2019 at 04:47 PM · datascope selectcurrencyscaling

DSS - Currency Scaling in POST { {protocol}}{ {host}}{ {api}}Extractions/ExtractWithNotes

We are trying to extract historical data for currency cross-rates using the service POST { {protocol}}{ {host}}{ {api}}Extractions/ExtractWithNotes. Let us assumer for example we are looking for the historical data for IDR/EUR (i.e. Ric: IDREUR=R). In this case our call to the service layer looks as follows:


{
  "ExtractionRequest": {
    "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.TimeSeriesExtractionRequest",
    "ContentFieldNames": [
      "Trade Date",
      "Universal Close Price",
      "Currency Code"          
    ],
    "IdentifierList": {
      "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",  
      "InstrumentIdentifiers": [
{ "Identifier": "IDREUR=R", "IdentifierType": "Ric"}
      ]
    },
    "Condition":
        "LastPriceOnly": false,
        "StartDate": "2019-12-01T00:00:00.000Z",
        "EndDate": "2019-12-04T00:00:00.000Z"
    }
  }
}

We noticed that the currency rates returned by the above call are scaled (i.e. there is a factor of 10'000). For example according to DSS data EUR/IDR (EURIDR=R) on 2019-12-02 was 15640.72 while IDR/EUR (IDREUR=R) on the same date was 0.6386. This indicates there is a 10000 scaling factor applied to IDR/EUR on the prices returned by the service.


Is it possible to pass a parameter in the above service call to return the data without any scaling?

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.

1 Reply

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by veerapath.rungruengrayubkul · Dec 06, 2019 at 10:05 AM

Hi @dimitrakopoulos

I cannot find this option for TimeSeriesExtractionRequest. You are able to get the scaling factor of this RIC in the "FXIR Scaling Factor" of the TermAndConditionExtractionRequest. Below is the sample of results.

        {
            "IdentifierType": "Ric",
            "Identifier": "IDREUR=R",
            "FXIR Scaling Factor": 10000
        }

According to Release note for DSS version 13.2, the TimeSeries Pricing will removed, you may need to use PriceHistoryExtractionRequest instead.

As announced in PCN 10897, the legacy Timeseries Pricing and Single Historical Price reports will be removed from the DataScope Select historical pricing offering and replaced with the newer Price History and Single Price History reports as of 28 February 2020. 
Comment

People who like this

0 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
dimitrakopoulos · Dec 06, 2019 at 12:13 PM 0
Share

Thank you very much for the feedback - 100% clear and understood :)

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

Related Questions

Does Datascope Select support JWT (JSON Web Token) payload encryption and decryption

is there any guide to construct a RIC with data we have like ticker,exp date , price etc ?

Extract sovereign and provincial bonds Argentina API Rest

We are new to Datascope Select and we need to retrieve CDOR rate details template from Datascope select. Could please help me how to create to extract CDOR rate details in datascope select from URL or Through Rest API C# sample ?

How to get traditional and simplified chinese names for a stock in DSS?

  • 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