How would you go about screening out all stocks that are in bankruptcy?

Manage
1

Im trying to come up with the formula to make all companies with the ticker ending in Q false, any idea how I would go about it without finding every company thats bankrupt and labelling it false?

Thanks :slight_smile:

2

Not sure you can do it on P123 but it’s a cinch in Excel. See attached.

Copy all tickers with the result “OK” and put them in an Exclude List.

P123_Screen_252512_20210502Q.csv (700 KB)

3

Oh wow, thanks so much! Thats actually awesome of you

4

The bankrupt tickers end in Q. This is why we need string manipulation functions.