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
irene.upo avatar image
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.

2 Answers

· Write an Answer
Upvotes
Accepted
irene.upo avatar image
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
Jirapongse avatar image
83.1k ●281 ●53 ●77

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