Welcome, Guest

Index membership
(1 viewing) (1) Guest
  • Page:
  • 1

TOPIC: Index membership

Index membership 2 months, 4 weeks ago #2747

  • amyers14
  • OFFLINE
  • Fresh Boarder
  • Posts: 7
  • Karma: 1
I was trying to create a screen that includes only the S&P 500 Index members. There are two different versions, one labeled S+P 500 and the other being the total return version. However, when I try either one, I don't get 500 stocks (actually, I think right now it should return 513 or something like that). For the first one (S+P 500) I get TWO stocks and for the TR version I get 352 stocks. What gives? Why can I not get all 500+?
Alan

Re: Index membership 2 months, 4 weeks ago #2748

  • admin
  • OFFLINE
  • Administrator
  • Posts: 282
  • Karma: 17
The issue is that most companies in the S+P 500 are components of multiple indexes. The index membership variable codes them as one string, separated by commas. You can use the advanced screen:

(indexmembership LIKE "%S+P 500%" AND (indexmembership) IS NOT NULL)

That will return 525 results (some S+P 500 companies have multiple share classes). To limit an existing screen's results to S+P 500 constituents, you would convert your basic screen to an advanced screen (by clicking the Advanced Screen tab) and then add:

AND (indexmembership LIKE "%S+P 500%" AND (indexmembership) IS NOT NULL)

to the end.

Re: Index membership 2 months, 4 weeks ago #2749

  • amyers14
  • OFFLINE
  • Fresh Boarder
  • Posts: 7
  • Karma: 1
THANKS! That is very helpful. Not intuitive but helpful!
Alan
  • Page:
  • 1
Time to create page: 0.11 seconds