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

Best Answer

  • 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'})