title: In google sheets, how do you use googlefinance to get the high price of a stock in a date range?
body: <p>I wrote the following formula, and it only returns the high of the starting date and not the high of the entire date range:  =INDEX(GoogleFinance(C7,"high", A7,B7,"DAILY"),2,2)</p>
  
  <p>where C7 is the google sheet cell that contains the stock symbol and A7 contains the starting date and B7 contains the ending date.</p>