Discover Refinitiv
MyRefinitiv Refinitiv Perspectives Careers
Created with Sketch.
All APIs Questions & Answers  Register |  Login
Ask a question
  • Questions
  • Tags
  • Badges
  • Unanswered
Search:
  • Home /
  • TRTH /
avatar image
Question by sushant2 · Nov 04, 2018 at 07:25 AM · tickhistoryv2intraday extractiondecimal places

5 Decimal Places data for EUR/USD

Hi Everyone,

We are using the tickhistoryv2 datascope platform and trying to download historical data for the RIC EUR=

The issue we are facing is that the data downloaded for fields like Open, High, Close, etc, is only upto 4 decimal places, while we require data for upto 5 decimal places. Can anyone confirm if it is possible to get the data for upto 5 decimal places either through the GUI or the API ? I have tried searching in the community for some answers but so far I have got conflicting answers regarding this.

Also is there any other RIC I can use that has 5 decimal places of data for a minimum of 12 years.

Any help would be greatly appreciated.

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.

2 Replies

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by Christiaan Meihsl · Nov 05, 2018 at 05:58 AM

@sushant2,

EUR= is published with only 4 decimal places, if you look in Eikon you see that trading units mentions 4DP:

That is why the API does not deliver more.

EUR=W is the offshore composite spot rate, which comes from many contributors (if you have Eikon you can see them using 0#EUR=:

The issue is that most of these contributor Open Access RICs will not deliver data if you make an Elektron Time Series request.

So what can you use ?

1) Elektron Time Series request and EUR=W (result: between 4 and 5 decimals):

EUR=W,EUR=W,1.1606,1.1628,1.156,,,,,2018/10/01
EUR=W,EUR=W,1.15779,1.15801,1.1502,,,,,2018/10/02
EUR=W,EUR=W,1.1546,1.15935,1.1462,,,,,2018/10/03
EUR=W,EUR=W,1.1475,1.15419,1.146,,,,,2018/10/04
EUR=W,EUR=W,1.1512,1.1549,1.14816,,,,,2018/10/05
EUR=W,EUR=W,1.15181,1.1534,1.1456,,,,,2018/10/08

2) Tick History Intraday Summary (i.e. 1h bars) and EUR=ASAN (Asian Pacific Bank spot rate) or EUR=MDMB (Moscow Business World Bank spot rate). Only these two will deliver 6 decimals, as you can see in this comparison of 1 hour bars for the 4 RICs we discussed:

#RIC,Alias Underlying RIC,Domain,Date-Time,GMT Offset,Type,Open,High,Low,Last,Volume,No. Trades,Open Bid,High Bid,Low Bid,Close Bid,No. Bids,Open Ask,High Ask,Low Ask,Close Ask,No. Asks
EUR=,,Market Price,2018-10-30T11:00:00.000000000Z,+0,Intraday 1Hour,,,,,,,1.1357,1.1359,1.1341,1.1347,7635,1.1358,1.1361,1.1346,1.1348,7635
EUR=ASAN,,Market Price,2018-10-30T11:00:00.000000000Z,+0,Intraday 1Hour,,,,,,,1.135735,1.135845,1.134525,1.134625,551,1.137465,1.137465,1.137465,1.137465,0
EUR=MDMB,,Market Price,2018-10-30T11:00:00.000000000Z,+0,Intraday 1Hour,,,,,,,1.135725,1.135835,1.134525,1.134645,520,1.135815,1.135925,1.134615,1.134715,526
EUR=W,,Market Price,2018-10-30T11:00:00.000000000Z,+0,Intraday 1Hour,,,,,,,1.1355,1.1359,1.134,1.1347,7596,1.1359,1.1363,1.13459,1.1348,7596

Note that for these 2 RICs to deliver data you must set validation to Allow Open Access Instruments:

"ValidationOptions": { "AllowOpenAccessInstruments": true },
"UseUserPreferencesForValidationOptions": false

eur.png (34.3 KiB)
0eur.png (62.0 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.

avatar image
REFINITIV
Answer by veerapath.rungruengrayubkul · Nov 05, 2018 at 05:21 AM

Hi @sushant2

In this case, the 4 decimal places is likely limited by content of this RIC, not API, since I am able to get more than 4 decimal places for <EUR=W> RIC. You may need to contact Content support team to provide alternative RICs.

Bid,Ask,High,Low,Instrument ID,Last,Volume,Trade Date
1.057653,1.057825,1.06333,1.0557,EUR=W,,,2017/02/14
1.06,1.0601,1.060875,1.0518,EUR=W,,,2017/02/15
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 >
10 People are following this question.

Related Questions

Download market depth day by day

How to download venue by detail files in .gz format for TRTH v2 API?

How to construct the JSON requestBody for the request: GetValidContentFieldTypes

Which template type to use for retrieving Equity Spot Index for a date range or a day?

TRTH Historical Criteria search

  • 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