Can you please help with the correct codes?

irene.upo
irene.upo
in Eikon Data APIs

Please help mofidy the following codes:

The client is looking for the formula : And code returned the future dividends estimate by analysts, but I need this for each month in the next fiscal year (NTM) period, not only last value of 2024 (2024-12-31).

dados, err = ek.get_data(
instruments =
['MILS3.SA','PRIO3.SA','ARZZ3.SA','ENAT3.SA','MGLU3.SA'],
fields = ['TR.TotalDividendsSmartEst(SDate=0M).periodenddate','TR.TotalDividendsSmartEst(SDate=0M)', 'TR.TotalDividendsMean(SDate=0M)',
'TR.F.LEVEREDFOCF(SDate=0M)'],



Tagged:

Best Answer

  • irene.upo
    irene.upo
    Answer ✓

    import refinitiv.data as rd

    rd.open_session()

    df = rd.get_data(

    universe = [

    'PRIO3.SA',

    'ENAT3.SA',

    'MGLU3.SA',

    'MILS3.SA',

    'ARZZ3.SA'

    ],

    fields = [

    'TR.TotalDividendsSmartEst(Frq=FY,SDate=0,Period=FY1,EDate=-1)',

    'TR.TotalDividendsSmartEst(SDate=0,EDate=-1,Frq=FY,Period=FY1)',

    'TR.TotalDividendsMean(SDate=0,EDate=-1,Frq=FY,Period=FY1)',

    'TR.F.LeveredFOCF(SDate=0,EDate=-1,Frq=FY,Period=FY1)'

    ]

    )


    display(df)


Answers

  • Jirapongse
    Jirapongse

    @irene.upo

    Thank you for reaching out to us.

    You need to contact the Eikon Excel support team direclty via MyRefinitiv and ask for the =TR formula which can be used to get the requried data.

    After that, you can apply the same TR parameters to the get_data method.

Categories