Welcome, Guest

index membership
(1 viewing) (1) Guest
  • Page:
  • 1
  • 2

TOPIC: index membership

Re: index membership 7 months, 3 weeks ago #2764

  • amyers14
  • OFFLINE
  • Fresh Boarder
  • Posts: 15
  • Karma: 1
Of course! Here it is:

(indexmembership LIKE "%S+P 500%" AND (indexmembership) IS NOT NULL) OR (indexmembership LIKE "%S+P 400 Mid Cap%" AND (indexmembership) IS NOT NULL) OR (indexmembership LIKE "%S+P 600 Small Cap%" AND (indexmembership) IS NOT NULL) AND (industry != "Banks" AND (industry) IS NOT NULL)
Alan

Re: index membership 7 months, 3 weeks ago #2765

  • admin
  • OFFLINE
  • Administrator
  • Posts: 294
  • Karma: 18
You need to add an open parenthesis to the beginning of the index membership section, and a close parenthesis to the end. Then, add the industry code. The advanced screen below should work:

((indexmembership LIKE "%S+P 500%" AND (indexmembership) IS NOT NULL) OR (indexmembership LIKE "%S+P 400 Mid Cap%" AND (indexmembership) IS NOT NULL) OR (indexmembership LIKE "%S+P 600 Small Cap%" AND (indexmembership) IS NOT NULL)) AND (industry != "Banks" AND (industry) IS NOT NULL)
  • Page:
  • 1
  • 2
Time to create page: 0.08 seconds