Upgrade from Eikon -> Workspace. Learn about programming differences.
For a deeper look into our Eikon Data API, look into:
Overview | Quickstart | Documentation | Downloads | Tutorials | Articles
When I query the SPSUPX (SP1500) it returns only 1291 lines; is this normal?
import eikon as ek import csv # Constituents SP1500
index = '.SPSUPX'
constituents, err = ek.get_data(index, fields= ['TR.IndexConstituentRIC','TR.IndexConstituentName'])
constituents.to_csv('SP1500.csv', sep=';', index=False)
Hi @k.garrec
Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query? If so please can you click the 'Accept' text next to the appropriate reply. This will guide all community members who have a similar question.
Thanks,
AHS
Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.
Thanks,
AHS
According to S&P, the number of constituents should be 1506. Since Eikon Excel is showing me the same amount that you reported, I suggest that you address this and any content related issues to your local Thomson Reuters Support Desk
Refer RIC<.SPSUP> instead of <.SPSUPX> since it makes no difference as it is been mirrored with, SPSUP. currently they have stopped updating .SPSUPX. Because it is the mirror Index of .SPSUP.
