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

anchu

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

Find more posts tagged with

funds

eikon-data-api

#technology

Accepted answers

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")

All comments

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

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

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")

EXPLORE OUR SITES