FX rate via Excel: can it be the same as via Eikon desktop ?
Hi
I understand that when querying data from Excel the FX rate is set to a spot FX rate by end of the year, whereas the FX rate used with Eikon Desktop is the average of the year.
is there an option to select the type of FX computation ?
or what is the recommendation set of formula ?
Best regards
Christophe
Tagged:
0
Best Answer
-
Put an answer from the ticket here as a reference
When the values are converted to USD, there may be a discrepancy between the two platforms because Excel uses the FX rate by end of year, whereas desktop uses the average of the year. Unfortunately, there is no way to change the setting of the FX rate for TR.TotalRevenue. This would have to be manually calculated using a separate formula.
Sample:
=TR("078890.KQ,"TR.TotalRevenue(Scale=6 Period=FY2011)/AVG(TR.PriceClose(Curn=KRW Frq=D SDate=2011-01-01 EDate=2011-12-31)/TR.PriceClose(Curn=USD Frq=D SDate=2011-01-01 EDate=2011-12-31))","")
Where we take the total revenue in local currency with: TR.TotalRevenue(Scale=6 Period=FY2011)
And then convert it using the average fx rate: AVG(TR.PriceClose(Curn=KRW Frq=D SDate=2011-01-01 EDate=2011-12-31)/TR.PriceClose(Curn=USD Frq=D SDate=2011-01-01 EDate=2011-12-31))
Please find this version in the attached file. For 0751.HK, the same logic is applied while taking into consideration the different period end date of March 31 instead of Dec 31 for early periods until 2018.
Alternatively, we have the Refinitiv Company Fundamentals (RCF) as our newly developed source for fundamentals. When using this source, you will find that the Total Revenue ,through datatype: TR.F.TOTRevenue, matches that of the desktop. You may still retrieve the values from TR.TotalRevenue as sourced from Refinitiv Financials (RF) by using the FX Conversion Rate function. I have included the screenshots on how this can be activated and applied in the second tab of the attachment.0
Answers
-
This forum is more for programming-type queries, rather than content queries. I would recommend you to contact the Eikon support team directly via MyRefinitiv.
However, I've raised ticket number 11065693 on your behalf for this query, the content specialist team is going to contact you soon to assist on this.
0
Categories
- All Categories
- 6 AHS
- 37 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 中文论坛