title: How to use TODAY() function with GOOGLEFINANCE() function in GoogleSheets
body: <p>I am trying to create a sheet with stock data from the current day and yesterday.</p>
  
  <p>Neither this:</p>
  
  <pre><code>=GOOGLEFINANCE(B2;"price";TODAY())
  </code></pre>
  
  <p>Nor this:</p>
  
  <pre><code>=GOOGLEFINANCE(B2;"price";DATE(YEAR(TODAY());MONTH(TODAY());DAY(TODAY())))
  </code></pre>
  
  <p>works.</p>
  
  <p>But this does:</p>
  
  <pre><code>=GOOGLEFINANCE(B2;"price";DATE(2020;1;17))
  </code></pre>
  
  <p>Can anyone help?</p>