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)
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.
