Workspace Python API does not return interim dates for some RICs

IoannisG
IoannisG Newcomer

When running the following commands in Codebook:

import refinitiv.data as dl

dl.open_session()

df=dl.get_data(['MMM.N', 'APO.N', 'IFC.TO', 'JPM.N', 'PGR.N', 'WRB.N', 'KKR.N'], ['TR.CompanyName', 'AVAIL(TR.Revenue(Period=FQ0).date,TR.Revenue(Period=FI0).date)'], parameters={'NULL':'Blank'})

,dates are not returned for some companies (see screenshot).

Why is this and how can it be corrected?

Best Answer

  • Jirapongse
    Jirapongse ✭✭✭✭✭
    Answer ✓

    @IoannisG

    Thank you for reaching out to us.

    You need to contact the helpdesk team via MyAccount to verify which fields can be used to retrieve the revenue's date.

    I found the TR.F.TotRevenue field.

    df=rd.get_data(
        ['MMM.N', 'APO.N', 'IFC.TO', 'JPM.N', 'PGR.N', 'WRB.N', 'KKR.N'], 
        ['TR.CompanyName', 
         'TR.Revenue(Period=FQ0).date',
         'TR.Revenue(Period=FI0).date',
         'TR.F.TotRevenue(Period=FQ0).date',
         'TR.F.TotRevenue(Period=FI0).date'], 
        parameters={'NULL':'Blank'})
    df
    image.png

    Please contact the helpdesk team to confirm if this TR.F.TotRevenue field is correct.

Welcome!

It looks like you're new here. Sign in or register to get started.

Welcome!

It looks like you're new here. Sign in or register to get started.