Lower Bollinger band Value :
=average(query(sort(GoogleFinance("NASDAQ:AAPL","close", TODAY()-320, TODAY()),1,0),"select Col2 limit 20 "))-STDEV(query(sort(GoogleFinance("NASDAQ:AAPL","close", TODAY()-320, TODAY()),1,0),"select Col2 limit 20 "))*2
Upper Bollinger band Value :
=STDEV(query(sort(GoogleFinance("NASDAQ:AAPL","close", TODAY()-320, TODAY()),1,0),"select Col2 limit 20 "))*2+average(query(sort(GoogleFinance("NASDAQ:AAPL","close", TODAY()-320, TODAY()),1,0),"select Col2 limit 20 "))
All Values :
=INDEX(GoogleFinance("NASDAQ:AAPL","All",WORKDAY(TODAY(),-5),TODAY()),,)
=INDEX(GoogleFinance("NASDAQ:AAPL","All",WORKDAY(TODAY(),-5),TODAY()),2,)
=INDEX(GoogleFinance("NASDAQ:AAPL","All",WORKDAY(TODAY(),-5),TODAY()),,2)
50 day Simple moving average (50SMA)
% up or down within 45 days
** One can create MACD , RSI and Hekin Ashi with google sheet for multiple stocks.
Check next post..
No comments:
Post a comment