FX rate via Excel: can it be the same as via Eikon desktop ?

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

Find more posts tagged with

rate-match

Accepted answers

raksina.samasiri

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.

All comments

raksina.samasiri

hi @christophe.dumont

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.

raksina.samasiri

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.

EXPLORE OUR SITES