Index | Recent Threads | Who's Online | Search

New Thread
This topic has been viewed 186 times and has 3 replies
LemmingRush
How would you go about screening out all stocks that are in bankruptcy?

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 :)

May 2, 2021 1:30:36 PM       
sthorson
Re: How would you go about screening out all stocks that are in bankruptcy?

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.

Attachment P123_Screen_252512_20210502Q.csv (717190 bytes) (Download count: 12)


May 2, 2021 5:40:41 PM       
LemmingRush
Re: How would you go about screening out all stocks that are in bankruptcy?

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

May 3, 2021 12:46:05 AM       
Chipper6
Re: How would you go about screening out all stocks that are in bankruptcy?

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

May 4, 2021 9:33:40 AM