For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

PilOop avatar image
25 5 4 5

SP1500 displays only 1291 lines

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)
eikoneikon-data-apipythonworkspaceworkspace-data-apirefinitiv-dataplatform-eikondatastream-api
sp1500.png (160.4 KiB)
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Zhenya Kovalyov avatar image
4.6k 26 7 22

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

10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

PilOop avatar image
25 5 4 5

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.

10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.