New Members: Be sure to confirm your email address by clicking on the link that was sent to your email inbox. You will not be able to post messages until you click that link.

Scan for Ultra and Inverse ETFs

Abuelo
Abuelo ✭
in Scanning
How can I build a scan to find all US Inverse and Ultra ETFs in SC database?

Thanks

Comments

  • markd
    markd mod
    edited January 2017
    I think you want to use the 'name contains' feature.

    I've included a few of the key words I could think of. Maybe you can add others.

    [country is US]

    and [group is ETF]

    and

    [
    [name contains "Ultra"]

    or

    [name contains "Inverse"]

    or

    [name contains "2x"]

    or

    [name contains "3x"]

    ]
  • Abuelo
    Abuelo ✭
    Thanks MarkD .... that seems to do it .... found 238 .... thats at least a very good start ....
  • Abuelo
    Abuelo ✭
    markD .... while your solution seems to do the job users may find this to be an easier way .... dawned on me this morning while shaving :smile: .... SCAN = "[Group is ETF] and [Group is not ETFNOUI] and [country is US]" .... ran scan this morning .... found 260 Inverse & Leveraged ETFs .... FWIW
  • markd
    markd mod
    edited January 2017
    @Abuelo Terrific! A much cleaner approach. I forgot there was a ETFNOUI group. Now that I'm retired, I don't shave as often...

Categories