No. of Recommendations: 1
"Here is the formula: =if(C6>0%,"BUY",if(C6<-4%,"SELL","No action"))"
---
Thank you Ray - that formula was very helpful in groking the nested IFs!
I see the utility of using weeks rather than days to avoid confusion - but that raises a related question - for use in Google Sheets, should the formula indeed specify 365 days or something like 252 which is what I thought was the equivalent of 52 weeks in Google Sheet-speak?
"B6 is the average of =GOOGLEFINANCE(".ixic", "price", today()-365, today(), "WEEKLY")
That is, the average of the last 52 weeks of IXIC,"
Sorry if this is a dumb question.
