Scan for Ultra and Inverse ETFs

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"]

    ]
  • Thanks MarkD .... that seems to do it .... found 238 .... thats at least a very good start ....
  • 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...