question

Upvotes
Accepted
25 6 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-apipythonworkspacerefinitiv-dataplatform-eikonworkspace-data-apidatastream-api
sp1500.png (160.4 KiB)
icon clock
10 |1500

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

Upvotes
Accepted
4.6k 27 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

icon clock
10 |1500

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

Upvotes
25 6 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.

icon clock
10 |1500

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

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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