Posts

Showing posts with the label Trading

NSE / BSE Stock Portfolio

 

GOOGLEFINANCE : Function Usage to create Googlesheet Stock Protfolio

Image
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 ( ) ) , , ) Date Open High Low Close Volume 1-Feb 133.75 135.38 9-May 134.14 106239823 2-Feb 135.73 136.31 13-May 134.99 83305367