I have a roth IRA that I am averaging into.
Currently I have my Costs Basis, Value, 52 week high/low of each holding in the portfolio. I also track the week to week movement of each stock. What I want to do is create a formula/visual aid to show which stocks are trending lower to their 52 week lows/52 week highs and returning a value of "BUY" OR "HOLD" respectively.
Would i just create an if statement that if the price is a certain distance from the 52 week low to return a "Buy" value?
Thanks!
Submitted June 17, 2019 at 10:13PM by kevingcp http://bit.ly/2MTKiYS
