Python code:
ek.get_data(['LP40201529','LP40193047','LP40195883','LP40196763'],fields = ['TR.TRESGScore','TR.CompanyName','TR.TickerSymbol','TR.FundDividendPayment','TR.DividendFrequency','TR.FundNAV.Date','TR.FundNAV'])
For a deeper look into our Eikon Data API, look into:
Overview | Quickstart | Documentation | Downloads | Tutorials | Articles
5
●0 ●2 ●0
How to get ESG score and Dividend payment frequency of Mutual Funds using Python Eikon API?
We need ESG scores of Mutual Funds and ETFs through the Python API. The below code works fine for stocks but throws 'NA' values for ETFs and Mutual funds but it is available in the Eikon Desktop App
Python code:
Python code:
13k
●32 ●12 ●18
Hi @BlackBird,
I believe that Eikon is calculating the ESG score from the score of the underlying constituents. At this time, Refinitiv's ESG coverage is about 80% of global market capitalization, and the funds that you have listed are not pre-calculated. However it is not too complicated to do it yourself. Begin by getting the fund holdings:
df,err = ek.get_data('LP40201529', ['TR.FundHoldingRIC'], {'Endnum':'5000'})
Now, in your application you can request the ESG score and dividend data for this list:
df2, err = ek.get_data(df['Holding RIC'].to_list(), fields=['TR.TRESGScore', 'CF_YIELD'])
and slice and analyze the content:
print('ESG coverage {}%'.format(df2['ESG Score'].count()/len(df2)*100))
>>> ESG coverage 86.76470588235294%
707
●2 ●1 ●1
@BlackBird Firstly, in Eikon API, mutual funds data are provided by Lipper and the API you should use should be under the “Lipper” section. Under Eikon Excel’s Formula Builder, you can find the “Lipper Funds” section. Hence, you should choose from fields starts with “TR.Fundxxxx”.
The following fields you asked for are available:
TR.FundDividendPayment
TR.FundExDividendDate
TR.FundProjectedYield
I am not sure your definition of yield, but if you only need to use the latest dividend and price to derive it, it seems possible. Yes, there is a type of yield (Projected Yield) already provided by the by the API. Its description is “Percentage of income earned as a proportion of total return performance over a one year period as of the latest month end.”
Below is the data for your sample funds:
Dividend Payment
Ex Dividend Date
Projected Yield
LP40201529
0.016303
2013-12-27
0
LP40193047
0.113
2020-09-24
0.721372
LP40195883
0.0573
2019-12-12
0.637634
LP40196763
0.053529
2019-12-19
0.749921
Notice: the first fund got the projected yield as 0% as it didn’t pay dividends in the latest one year period.
Funds’ ESG is not available in Eikon API, but available the newer RDP API and the Lipper LGDF feeds.
