Standardized Fundamentals are Appearing in Company profile but not appearing in Screener & in Exce

Noraiz
Noraiz Newcomer
edited April 30 in Eikon COM

I have access to Refinitiv Workspace via my academic account. I can view financials (e.g., Revenue from Business Activities - Total) from company profiles such as RVSB.O.

However, when I attempt to retrieve the same standardized fundamental fields using the Screener tool or Excel Add-in formulas, the values do not appear. I have checked the formula multiple times, but there is no value appearing. Moreover, there other companies also and with them there are multiple fields being null, even though data is available. I checked manually.

Tagged:

Answers

  • Jirapongse
    Jirapongse ✭✭✭✭✭

    @Noraiz

    Thank you for reaching out to us.

    I checked and found the field name for Revenue from Business Activities - Total is TR.F.TOTREVENUE.

    You can use this field in the Screener to retrieve its values. For example:

    =@TR("SCREEN(U(IN(Equity(active,public,primary))/*UNV:Public*/), IN(TR.ExchangeCountryCode,""US""), IN(TR.TRBCBusinessSectorCode,""5510""), CURN=USD)","TR.CommonName;TR.F.TotRevenue(Period=FY0);TR.ExchangeCountry;TR.TRBCBusinessSector","curn"&"=USD RH=In CH=Fd")

    If you are still unable to retrieve data, please contact the helpdesk team directly via MyAccount to verify what the problem is.

Categories