Hello , How to get S&P500 all stock by eikon python API ? thank you.

Question

question

ethan.hayashi

18 ●2 ●0 ●5

Hello , How to get S&P500 all stock by phthon API ? thank you.

Mar 26, 2019 at 01:59 AM

10 |1500

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

Answer 1 · 2019-03-26T04:10:46Z

marcin.bunkowski

3.8k ●4 ●4 ●6

You can retrieve index RIC constituents along with their names using the syntax

ek.get_data("0#.SPX","TR.COMMONNAME")

Mar 26, 2019 at 04:10 AM

10 |1500

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

ethan.hayashi Mar 27, 2019 at 01:01 AM

Thank you~ It is worked.

Answer 2 · 2019-03-27T07:53:49Z

Zhenya Kovalyov

4.6k ●26 ●7 ●22

@ethan.lin, another way is to query the fundamental database for index constituents (current or historical):

ek.get_data('.SPX', 'TR.IndexConstituentRIC')

Mar 27, 2019 at 07:53 AM

10 |1500

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

ethan.hayashi Mar 31, 2019 at 10:28 PM

Thank you~ It is worked too.