Subject: Re: Chart: timing with Nas100 RS screen
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,