reporting standards for small decimal place currency

Hi,
I have tried extracting the exchange quotes for a list of countries using the python code below.
It seems like there is some inconsistency within reporting for some quotes of small currency.
i.e JPYEUR=R = 0.6660 and 0.0066 from refinitiv datasource and google respectively.
but are valid when currency rates are not small. i.e USDEUR.
0.94 and 0.94from refinitiv datasource and google respectively
I understand its a convention to normalise fx rate to prevent too many decimal places being reported.
However as I'm trying to calculate the cost of a good. Are there any methods that i could get the actual quote of a currency instead of normalised quote?
Many thanks.
import refinitiv.data as rd
rd.get_history(universe=sublist,fields=['BID'], interval="1D",start=datetime.now() - timedelta(days=365),end=datetime.now())
Best Answer
-
Hi @shouldcost, Our internal teams got back to me and we were able to find the field in question:
Please don't hesitate using DIB: https://developers.refinitiv.com/en/video-catalog/data-item-browser
0
Answers
-
Hi @shouldcost,
The reason why we show FX Spot rates in this manner is because of Forward rates when expressed in points. E.g.: if the JPYEUR=R rate is 0.6668 and the Forward point based quoted rate (FwdPBQRate) is 9, then convention dictates that we add the FwdPBQRate to the last digit of the quoted FX Spot rate (here the Forward 'normalized' rate is 0.6668 + 0.0009 = 0.6677). Note that this applies even when the FwdPBQRate is 'large', e.g.: 149, such that the Forward 'normalized' rate is 0.6668 + 0.0149 = 0.6817. You may also be interested in reading this thread too.
With that said, I don't know if there is a field for the 'peg' (which in this case is 100 (or 0.01)), and this forum is for API/tech questions, not content questions, so I asked your question on your behalf on my.refinitiv, number 12621013. You ought to be contacted about this ticket. If you are given an answer on my.refinitiv's forum, please do revert back to this Developer Community Q&A Forum to provide the answer for future users as reference, it would be very much appreciated.
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
- 25 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
- 716 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 中文论坛