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.

m.bunkowski

Hi @ethan.hayashi

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

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

ethan.hayashi

https://community.developers.refinitiv.com/discussion/comment/40443#Comment_40443

Thank you~ It is worked.

Zhenya Kovalyov

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

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

ethan.hayashi

https://community.developers.refinitiv.com/discussion/comment/40529#Comment_40529

Thank you~ It is worked too.