New posts are disabled while we improve the user experience.

You can browse the site, or for urgent issues, raise a query at MyAccount.

question

Upvotes
Accepted
peter.akester avatar image
0 ●4 ●5 ●8

Pull 'Total expense ratio' from an excel sheet with a list of ISIN codes

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

eikon-data-apipythonpython apiexcel
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

2 Answers

· Write an Answer
Upvotes
Accepted
haykaz.aramyan avatar image
399 ●5 ●5 ●9

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:

1642069312665.png

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:

1642069273821.png

Hope this is helpful, please let me know if you have any further questions


1642069312665.png (15.3 KiB)
1642069273821.png (125.1 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvotes
peter.akester avatar image
0 ●4 ●5 ●8

Thanks, for this! Would it be possible to get the Expense ratio values monthly? @haykaz.aramyan

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.