How to get the fund YIELD RATE and DIVIDEND info via Eikon API?

anchu

How to get the fund “预期收益率” and “股息” via Eikon API?

raksina.samasiri

Hi @anchu ,

Thank you for your patience, the code below can be used.

df, err = ek.get_data(
    instruments = ['511880.SS'],
    fields = [
        'TR.FundExDate',
        'TR.FundRecordDate',
        'TR.FundPayDate',
        'TR.FundDiv',
        'TR.FundDivCurr',
        'TR.FundIncDistribution'
    ],
    parameters = {'SDate': '2017-01-01','EDate': '2023-07-10'}
)

display(df)

Regarding the <NA> in the Record Date field, you can raise a content ticket via MyRefinitiv as this field also return NULL on Eikon Excel as well.

=@RDP.Data("511880.SS","TR.FundExDate;TR.FundRecordDate;TR.FundPayDate;TR.FundDiv;TR.FundDivCurr;TR.FundIncDistribution","SDate=-6Y Edate=1Y CH=Fd RH=IN")

raksina.samasiri

Hi @anchu ,

Using Data Item Browser, you can search for the fields you're looking for.

For example, the projected yield has the field name 'TR.FundProjectedYield'

df, err = ek.get_data(['511880.SS'], ['TR.FundProjectedYield'])
df

Regarding the dividend, the code below can be used. As mentioned in the answer in this thread

df, err = ek.get_data('511880.SS',
            ["TR.DivExDate", "TR.DivRecordDate", "TR.DivPayDate","TR.DivUnadjustedGross", "TR.DivCurr"], 
            {'SDate':'2019-01-01','EDate':'2023-07-10', 'DateType':'ED'})
df

anchu

https://community.developers.refinitiv.com/discussion/comment/106900#Comment_106900

Thanks for your reply. For dividends, I want to get dividend distribution records for all time periods, but using the above code only gets one record. How can I get all records ?

anchu

All dividends for fund 511880.SS