Removing Delisted Stocks and/or ETFs from a Scan

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

This topic contains 6 replies, has 7 voices, and was last updated by Avatar Steven 1 month, 3 weeks ago.

Viewing 7 posts - 1 through 7 (of 7 total)
  • Author
    Posts
  • #48423
    Avatar
    Mathew
    • 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
    Darren
    Darren
    • Topics: 36
    • Replies: 211
    • Posts: 247

    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
    Avatar
    Michael
    • Topics: 0
    • Replies: 1
    • Posts: 1

    Last bar

    How do you set the date range to Last Bar? 

    Mine has everything but 

    #51563
    Matthew
    Matthew
    • Topics: 4
    • Replies: 137
    • Posts: 141

    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
    Avatar
    Jonathan
    • Topics: 21
    • Replies: 25
    • Posts: 46

    God Yes!

    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
    Avatar
    Rhiannon
    • Topics: 4
    • Replies: 2
    • Posts: 6

    What about watch lists?

    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
    Avatar
    Steven
    • Topics: 2
    • Replies: 8
    • Posts: 10

    Look for a closing price

    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