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

ethan.hayashi

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

marcin.bunkowski

Hi @ethan.lin

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

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

ethan.hayashi

Thank you~ It is worked.

Zhenya Kovalyov

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

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

ethan.hayashi

Thank you~ It is worked too.