CF_CURR and TR.CompanyReportCurrency

aquilesjlp300 · September 2019

Is there any difference between CF_CURR and TR.CompanyReportCurrency when the input is a RIC or a QuoteID?

chavalit-jintamalit · September 2019

These 2 fields are from different database, please refer to this picture:

I believe that in this case, they carry the same information.

This forum is moderated by developer, It is advise to contact Refinitiv Content Helpdesk to get an authoritative answer on content related questions.

m.bunkowski · September 2019

https://community.developers.refinitiv.com/discussion/comment/48997#Comment_48997

Hi @aquilesjlp300

Just to add to @chavalit-jintamalit answer, CF_CURR is a real time field and displays the currency in which the particular RIC is quoted. The same company can be traded on different exchanges with different RIC codes and in different currencies, where TR.CompanyReportCurrency will be the main reporting currency for this company. See example below for Apple.

ek.get_data(['AAPL.OQ','AAPL.DE','AAPL.BN','AAPL.CN','AAPL.BIV'],['CF_LAST','CF_CURR','TR.CompanyReportCurrency'])

aquilesjlp300 · September 2019

https://community.developers.refinitiv.com/discussion/comment/49033#Comment_49033

Thanks @chavalit.jintamalit and @marcin.bunkowski for your helpful replies.

Basically TR.CompanyReportCurrency states the currency for the primary quote RIC of the company (I checked for TR.IsPrimaryQuote for all these companies the only one that returned "TRUE" was AAPL.OQ).

CF_CURR and TR.CompanyReportCurrency

Best Answer

Answers

Categories

EXPLORE OUR SITES

CF_CURR and TR.CompanyReportCurrency

Best Answer

Answers

Categories