Upgrade from Eikon -> Workspace. Learn about programming differences.

For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
21 0 0 1

Can you please help with the correct codes?

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)'],



eikon-data-api#technology#contentpython api
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

@irene.upo

Hi,

Thank you for your participation in the forum.

Are any of the replies below satisfactory in resolving your query?

If yes please click the 'Accept' text next to the most appropriate reply. This will guide all community members who have a similar question.

Otherwise please post again offering further insight into your question.

Thanks,

AHS

Upvotes
Accepted
21 0 0 1

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)


icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvotes
78.9k 250 52 74

@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.

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.