No. of Recommendations: 3
to clarify, do you mean ^IXIC needs to be 4% above its 325-day SMA to pass the timing test?
No, the opposite. And not 325 days. 52 weeks.
(BTW, I hate it when people say days -- never clear if it means market days or calendar days. In GTR1 it means market days, in google sheets it means calendar days. Weeks is unambiguous.)
Here is the formula: =if(C6>0%,"BUY",if(C6<-4%,"SELL","No action"))
C6 is: =A6/B6 -1 Which is the percentage of current price vs the average of the closing prices of the last 52 weeks.
A6 is =googlefinance(".ixic")
B6 is the average of =GOOGLEFINANCE(".ixic", "price", today()-365, today(), "WEEKLY")
That is, the average of the last 52 weeks of IXIC,
