title: Copy data from one sheet, add current date to each new row, and paste
body: <p>I've done some reading but my limited knowledge on scripts is making things difficult. I want to:</p>
  
  <ol>
  <li>Copy a variable number of rows data range, known colums, from one sheet titled 'Download' </li>
  <li>Paste that data in a new sheet titled 'Trade History' from Column B</li>
  <li>In the new sheet, add today's date formatted (DD/MM/YYYY) in a new column A for each record copied</li>
  </ol>
  
  <p><a href="https://i.stack.imgur.com/eE0Zy.png" rel="nofollow noreferrer">The data in worksheet 'Download' uses IMPORTHTML</a></p>
  
  <p><a href="https://i.stack.imgur.com/7TsV1.png" rel="nofollow noreferrer">The data copied from <code>Download</code> to store a historical record needs a <code>date</code> in Column A</a></p>
  
  <p>I've managed to get 1 and 2 working, but can't work out the 3rd. See current script below.</p>
  
  <pre><code>function recordHistory() {
  var ss = SpreadsheetApp.getActive(),
  sheet = ss.getSheetByName('Trade_History');
  var source = sheet.getRange("a2:E2000");
    ss.getSheetByName('Download').getRange('A2:E5000').copyTo(sheet.getRange(sheet.getLastRow()+1, 2))
    }
  </code></pre>