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
  • #48423
    • 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?





    • 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.

    • Topics: 0
    • Replies: 1
    • Posts: 1

    How do you set the date range to Last Bar? 

    Mine has everything but 

    • 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…


    • 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.

    • 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?

    • 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.