Pulling Lipper fund holdings for a large list of RIC instruments using Eikon API (python)

Hello, I need to pull Lipper fud holdings for a list of more than 4000 RIC Instrument. I am using the code copied below, but i get Expected timeout error.

Is it possible to pull these data with only one code?

df0, err = ek.get_data(RIC_list0, ['TR.FundHoldingRIC','TR.FundHoldingName',

'TR.FundLatestFilingDate','TR.FundNumberOfShares',

'TR.FundNumberOfSharesChanged','TR.FundPercentageOfFundAssets'],

{'Endnum':'5000'})

df0

Find more posts tagged with

python

funds

lipper

eikon-data-api

#technology

Accepted answers

bob.lee

Hi @RamadanEA , I am not sure if I understand your need for "with only one code". If you mean you want pull the data fund by fund, yes, you just need to replace the RIC_list0 in your code by the RIC string of the fund (e.g.: 'LP60000012') one by one.

Hence, you loop the list of RICs in your original RIC_list0, and call the ek.get_data one RIC code at a time in the loop and process the data fund by fund.

All comments

bob.lee

Hence, you loop the list of RICs in your original RIC_list0, and call the ek.get_data one RIC code at a time in the loop and process the data fund by fund.

RamadanEA

hi @bob.lee Thank you so much for your reply. I am beginner to coding and still have not been better in looping. Would you please how to write the code as you explained.

The code I posted worked after I tried rerunning it several time, but I am really interested to see how to use for loop in this case. I have tried to do it, but I could not.

Your help would be appreciated!

Thank you!

Ebtehal

EXPLORE OUR SITES