Workspace Python API does not return interim dates for some RICs

IoannisG

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?

Codebook_Dates.JPG

Jirapongse

@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

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