title: Google Sheets - Button to update Row
body: <p>I am not a big fan of some of the Stock Broker’s GUI, so I am attempting at tracking some of my assets on a Google Sheet.</p>
  
  <p><strong>How can I create Manual (click a button) or Automatic triggers, based off of a certain date, to edit a cell's value or add a new entry into a new cell?</strong></p>
  
  <p>Example Triggers: </p>
  
  <pre><code>1) Increment currently owned shares on the Dividend Payout Date.
  2) Nightly/Weekly new entries for Profit/Loss for a company/set of companies.
  </code></pre>
  
  <p>Sample Sudo Logic:</p>
  
  <ol>
  <li>When TODAY() == 2/2/2018(any variable date saved in a cell), update cell [current shares] with reinvested_shares + current_shares. </li>
  <li>Create a new entry in next available cell with profit/loss for the day. New entry would be static and never changing. This could be a button to manually trigger or automatic.</li>
  </ol>
  
  <p>Since you won't have the spreadsheet that contains the cell information, any sample template (with comments) would be highly appreciated. </p>