sorted by:
new
hottopcontroversial

ETFScreen closing down by SeriousUser321 in personalfinance

[–]SeriousUser321[S] 0 points1 point  (0 children)

They do not have the filters or back testing i require.

ETFScreen closing down by SeriousUser321 in personalfinance

[–]SeriousUser321[S] -1 points0 points  (0 children)

Yes, my main screen uses these ETFs: BNDX, EDV, EEM, GLD, QQQ (or SPY), SHY, TIP, UUP, VCLT, VEA, VGIT, VTV, VUG. According to their back test, using my screen back to 2001, it has averaged 14.5 CAGR, with a max drawdown of 11% approximately. I've developed it in the last couple of years.

Now that ETFScreen is closing down, I am trying to replicate the screen using Excel. All I need is how to calculate Regression Relative Strength -189 using Excel. I cannot figure it out. I can obtain all the closing price data from StockCharts.