Conditional Screening Rule

Research
1

Hi I'm looking if there is workaround for this formula :

I want to exclude tickers who just reported their quarterly earning x weeks ago, except for the tickers who have higher close price after quarter earning report than 1 week before the quarter earning report

it looks like this :

exclude weeksintoq<5 except close(weekstoq=0)<close(weeksintoq=0)

2

This should work: WeeksIntoQ >= 5 or Close(DaysSince(LatestNewsDate)-2) > Close(DaysSince(LatestNewsDate)+5)

3

Hi Yuval thanks for you reply. I tried to check the formula using ShowVar to make sure the result is correct, however I found the close price mostly weeks away from the LatestNewsDate price

I use these in the screener:
ShowVar(@LND, LatestNewsDate)
ShowVar(@CloseLND, Close(DaysSince(LatestNewsDate)))

some ticker I tried and the results :
INTT (showing 02-24 close price instead of 03-07)
LINC (showing 02-06 close price instead of 02-24)
ELMD (showing 01-17 close price instead of 02-11)
PMTS (showing 02-19 close price instead of 03-04)

I use yahoo finance history price for reference
https://finance.yahoo.com/quote/PMTS/history/

4

I apologize. It should be BarsSince, not DaysSince.

1 Like
5

Thanks again, Yuval. It worked perfectly :slight_smile: