How to get the fund “预期收益率” and “股息” via Eikon API?
9
●1 ●1 ●6
How to get the fund YIELD RATE and DIVIDEND info via Eikon API?
Hi,
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 most appropriate reply. This will guide all community members who have a similar question.
Otherwise please post again offering further insight into your question.
Thanks,
AHS
Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.
Thanks,
AHS
14.2k
●30 ●5 ●10
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")
14.2k
●30 ●5 ●10
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
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 ?
