Workspace Python API does not return interim dates for some RICs

IoannisG
IoannisG Newcomer
edited January 22 in Refinitiv Data Platform Libraries

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
Tagged:

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.

Categories