CF_CURR and TR.CompanyReportCurrency

aquilesjlp300

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

chavalit-jintamalit

Hi @aquilesjlp300

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

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

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).