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

What field to use for Dividend Payout Ratio value & dates in Eikon API?

I am trying to get Dividend Payout Ratio value & dates for a RIC. I am able to get the value but not date.
I am using following field to get the Dividend Payout Ratio value,
"TR.F.DivPayoutRatioPct(Period=FY0,Frq=D,SDate=2000-01-01)"

Can you help me with the field name to be used to get the date as well?

I am using Eikon Data API,

df, err = ek.get_data(
instruments = ['AAPL.O'],
fields = [
'TR.F.DivPayoutRatioPct(Period=FY0,Frq=FQ,SDate=2010-12-31,EDate=2020-10-26)',
]
)

Getting following output without date column,

Instrument Div Payout Ratio
0 AAPL.O NaN
1 AAPL.O NaN
2 AAPL.O NaN
3 AAPL.O 0.000000
4 AAPL.O 0.000000
5 AAPL.O 0.000000
6 AAPL.O 0.000000
7 AAPL.O 5.990463
8 AAPL.O 5.990463
9 AAPL.O 5.990463
10 AAPL.O 5.990463
11 AAPL.O 28.425628
12 AAPL.O 28.425628
13 AAPL.O 28.425628
14 AAPL.O 28.425628
15 AAPL.O 27.919514
16 AAPL.O 27.919514
17 AAPL.O 27.919514
18 AAPL.O 27.919514
19 AAPL.O 21.408773
20 AAPL.O 21.408773
21 AAPL.O 21.408773
22 AAPL.O 21.408773
23 AAPL.O 26.189069
24 AAPL.O 26.189069
25 AAPL.O 26.189069
26 AAPL.O 26.189069
27 AAPL.O 25.982917
28 AAPL.O 25.982917
29 AAPL.O 25.982917
30 AAPL.O 25.982917
31 AAPL.O 22.504956
32 AAPL.O 22.504956
33 AAPL.O 22.504956
34 AAPL.O 22.504956
35 AAPL.O 25.570074
36 AAPL.O 25.570074
37 AAPL.O 25.570074
38 AAPL.O 25.570074

eikoneikon-data-apipythonrefinitiv-dataplatform-eikonworkspaceworkspace-data-apidata
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.

@jeane.samson.refinitiv

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 reply that best answers your question. This will guide all community members who have a similar question. Otherwise please post again offering further insight into your question.

Thanks,

-AHS

@jeane.samson.refinitiv

Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.

Thanks,

-AHS

1 Answer

· Write an Answer
Upvotes
Accepted
39.4k 77 11 27

Add to the list of field the field name with ".date" qualifier:

ek.get_data('AAPL.O',['TR.F.DivPayoutRatioPct.date','TR.F.DivPayoutRatioPct'],
            {'SDate':'2010-12-31','EDate':'2020-10-26'})
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.