Hi all, im hoping you can help me.
I need help creating abit of python that will take a list of ISIN codes from an excel sheet and pull all the 'Total expense ratios' for each
Thanks in advance for the help
Upgrade from Eikon -> Workspace. Learn about programming differences.
For a deeper look into our Eikon Data API, look into:
Overview | Quickstart | Documentation | Downloads | Tutorials | Articles
Hi all, im hoping you can help me.
I need help creating abit of python that will take a list of ISIN codes from an excel sheet and pull all the 'Total expense ratios' for each
Thanks in advance for the help
Hello @peter.akester ,
Thank you for your participation in the forum.
Is the reply below satisfactory in resolving your query?
If yes, please click the 'Accept' text next to the 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
Hi @peter.akester ,
Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.
Thanks,
AHS
Hi @peter.akester ,
You can retrieve the total expense ratios for given ISINs from Eikon API. The code below does that:
isin_list = ['GB00B5B71Q71, LU1883854199, IE0030308773'] df, err = ek.get_data(isin_list, 'TR.LipperRICCode, TR.FundName, TR.FundTERDate, TR.FundTER') df
Here is the output:
You can read the isin_list directly from excel or define in the code as in the example below. If you want other fields other than total expense ratio, you may find available ones from Data Item Browser of Workspace. See below a screenshot:
Hope this is helpful, please let me know if you have any further questions
Thanks, for this! Would it be possible to get the Expense ratio values monthly? @haykaz.aramyan