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
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
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)
Oh wow, thanks so much! Thats actually awesome of you
The bankrupt tickers end in Q. This is why we need string manipulation functions.