Hey, I am new to Portfolio123, wondering if anyone can help with something I am trying to do, would like to look at all the historical Quarters of all the stocks in the S&P, and find the ones that the earnings were at least 20% less than the previous quarter and the previous quarter was 20% less than the one before it, (for example Q1 100 Q2 80 Q3 64), and then assuming $100 was put into each of these stocks, what would the portfolio be worth 1 year later? (The theory is, that the market over reacts to the drop in earnings and will climb back up)
And the same the opposite, if a company's earnings went up at least 20% for 2 consecutive quarters (for example Q1 100 Q2 120 Q3 144) assuming $100 was put into a short position in every company that had this at any time in the past 20 years, what percent up or down would it be a year later?
Thanks in advance
In other news, is there a way to add a dollar volume rule in a screen?
mediandailytot(200) is the median daily dollar volume over the past 200 days. You can also use avgdailytot(200) or whatever lookback period you prefer.
Here is a screen that might be what you are looking for. I tried to encode what you suggested.
Hint: if you also select the top 10 stocks according to Core: Sentiment there is additional gains particularly in down markets.
1 Like
An alternate understanding of the question yields:
EBITDA(0, QTR) <= EBITDA(1, QTR) * 0.80
EBITDA(1, QTR) <= EBITDA(2, QTR) * 0.80
For the growth side flip to >= and 1.20
Universe is the S&P 500 and the Rolling Backtest for a one year holding period as a start.
Cheers,
Rich
2 Likes
Thanks!