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-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpythondata
icon clock
10 |1500

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

1 Answer

Upvotes
Accepted
39.2k 75 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 5.0 MiB each and 10.0 MiB total.

Click below to post an Idea Post Idea