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
- 6 AHS
- 39 Alpha
- 161 App Studio
- 4 Block Chain
- 4 Bot Platform
- 16 Connected Risk APIs
- 47 Data Fusion
- 30 Data Model Discovery
- 608 Datastream
- 1.3K DSS
- 577 Eikon COM
- 4.9K Eikon Data APIs
- 7 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- Trading API
- 2.7K Elektron
- 1.3K EMA
- 236 ETA
- 519 WebSocket API
- 33 FX Venues
- 10 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 20 Messenger Bot
- 2 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 59 Open Calais
- 264 Open PermID
- 39 Entity Search
- 2 Org ID
- PAM
- PAM - Logging
- 8.4K Private Comments
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 20 RDMS
- 1.4K Refinitiv Data Platform
- 367 Refinitiv Data Platform Libraries
- 3 Refinitiv Due Diligence
- LSEG Due Diligence Portal API
- 3 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.1K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 10 World-Check Customer Risk Screener
- 990 World-Check One
- 44 World-Check One Zero Footprint
- 45 Side by Side Integration API
- Test Space
- 3 Thomson One Smart
- 1.2K TR Internal
- Global Hackathon 2015
- 2 Specialists Who Code
- 10 TR Knowledge Graph
- 150 Transactions
- 142 REDI API
- 1.7K TREP APIs
- 4 CAT
- 21 DACS Station
- 117 Open DACS
- 1.1K RFA
- 103 UPA
- 172 TREP Infrastructure
- 224 TRKD
- 886 TRTH
- 5 Velocity Analytics
- 5 Wealth Management Web Services
- 59 Workspace SDK
- 9 Element Framework
- 5 Grid
- 13 World-Check Data File
- Yield Book Analytics
- 46 中文论坛