eikon data api bulk data

Question

question

newuser

97 ●10 ●12 ●13

eikon data api bulk data

I tried to obtain constituent data but it only returns 10 records.

For example,

index_ric = "MCHI.OQ";

df, err = ek.get_data([index_ric],['TR.FundHoldingRIC','TR.FundHoldingName','TR.FundCountryOfDomicile','TR.FundPercentageOfFundAssets','TR.FundNumberOfShares','TR.FundNumberOfSharesChanged'])
df.columns=['INDEX_RIC','RIC','NAME','COUNTRY','PctWgt','SHARES','SHARES_CHANGE']

I expect about 300 names.

=TR("MCHI.OQ","TR.FundHoldingRIC;TR.FundHoldingName;TR.FundCountryOfDomicile;TR.FundPercentageOfFundAssets;TR.FundNumberOfShares;TR.FundNumberOfSharesChanged","StartNum=1 EndNum=1000 CH=Fd RH=IN",B2)

api data constituents

Mar 20, 2019 at 05:56 PM

10 |1500

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

pimchaya.wongrukun01 Mar 28, 2019 at 03:01 AM

Hello @dong.han

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 reply. This will guide all community members who have a similar question. Otherwise please post again offering further insight into your question.

Thanks,

AHS

Jirapongse Apr 05, 2019 at 12:41 AM

@dong.han

Hi,

Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.

Thanks,

AHS

Answer 1 · 2019-03-20T18:26:18Z

Alex Putkov.1

39.4k ●77 ●11 ●27

In =TR function you have StartNum and EndNum parameters, whereas in get_data method they're missing. Add these parameters and you'll get the full result.

ek.get_data('MCHI.OQ',
    ['TR.FundHoldingRIC','TR.FundHoldingName','TR.FundCountryOfDomicile',
     'TR.FundPercentageOfFundAssets','TR.FundNumberOfShares',
     'TR.FundNumberOfSharesChanged'],
    {'StartNum':'1', 'EndNum':'1000'})

Mar 20, 2019 at 06:26 PM

10 |1500

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

Answer 2 · 2019-03-21T07:50:41Z

newuser

97 ●10 ●12 ●13

thank you!

Mar 21, 2019 at 07:50 AM

10 |1500

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

Q&A Forum

question

eikon data api bulk data

2 Answers

Write an Answer

question

eikon data api bulk data

2 Answers

Write an Answer

Related Questions