Removing Delisted Stocks and/or ETFs from a Scan

Optuma Forums Optuma General Discussion Removing Delisted Stocks and/or ETFs from a Scan

Viewing 7 posts - 1 through 7 (of 7 total)
  • Author
    Posts
  • #48423
    AvatarMathew
    • Topics: 3
    • Replies: 2
    • Posts: 5

    Dear Matthew or Darren,

    How do you exclude delisted stocks and/or ETFs from a Scan when you choose the market/exchange?

    thanks,

    Mathew

     

     

    #48431
    DarrenDarren
    • Topics: 53
    • Replies: 398
    • Posts: 451

    Hi Mathew,

    If the date range of the scan is set to Last Bar then only active symbols will be included in the results. Alternatively add something like ‘and VOL()>0‘ to the end of the formula.

    #51547
    AvatarMichael
    • Topics: 0
    • Replies: 1
    • Posts: 1

    How do you set the date range to Last Bar? 

    Mine has everything but 

    #51563
    MatthewMatthew
    • Topics: 4
    • Replies: 255
    • Posts: 259

    Hi Mathew,

    In the scanning manager, Last Bar should be the second option from the top when looking at the Date Range drop down menu…

    Ex4

    #51603
    AvatarJonathan
    • Topics: 35
    • Replies: 54
    • Posts: 89

    i’d love to be able to select all shares for a watchlist, without having ANY delisted or ETFs in it.

     

    It is a big waste of time having to get rid of these delisted shares.

    #52351
    AvatarBen
    • Topics: 7
    • Replies: 6
    • Posts: 13

    Is there a way to do similar when creating watch lists?

    Was thinking of a search with some form of ‘not equals’ delisted.

    Any ideas?

    #52367
    AvatarSteven
    • Topics: 2
    • Replies: 8
    • Posts: 10

    I had the same problem. I added:

    ACTIVESTOCK = Close(Day()) >0

    to my filters. Works a treat.

Viewing 7 posts - 1 through 7 (of 7 total)
  • You must be logged in to reply to this topic.

Pin It on Pinterest

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close