title: How to get peak price of a stock after a particular date in Google Spreadsheet?
body: <p>I'm trying to create an automated Google Spreadsheet to track my positions. There's a column which needs to display peak price of a stock after I have added it in my portfolio. Say I added a stock on 3rd November, I need to know what's the highest price stock reached after 3rd November. And that column keeps updating itself as and when that stock touches new highs.</p>
  
  <p><a href="https://i.stack.imgur.com/eyoqj.jpg" rel="nofollow noreferrer">EDIT: I am including a screenshot. </a> </p>
  
  <p>In the screenshot attached above you can see column F2 will update itself by taking live stock price from Google Finance. </p>
  
  <p>For F2 I used <code>=GOOGLEFINANCE(B2,"price")</code></p>
  
  <p>Now in column E2, I want highest price displayed in F2 in since the date of addition of stock. Suppose on November 20th stock touched high of Rs. 200 and then came down to 180. F2 would display price as 180 but E2 should display price as 200(which is the peak price).</p>
  
  <p>I tried using few codes but none of them worked. I am listing the few ones I tried.</p>
  
  <pre><code>=GOOGLEFINANCE(B2,"high","11/03/2017")
  =(GOOGLEFINANCE(B2,"high","11/03/2017","12/31/2018"))
  =max(GOOGLEFINANCE(B2,"price","11/03/2017")) 
  =max(GOOGLEFINANCE(B2,"price","11/03/2017","12/31/2018"))
  </code></pre>
  
  <p>I even tried referencing date with column A2. But that also didn't work.
  Referencing Date with Column A2 is a priority, since that will enable me to drag and add another stocks without the need to edit the formula everytime. </p>