GSheet Script for daily valuation

dailyValuation.gs

function plotDailyValuation() {
  //read the counter (#) in cell A1 of History, number in cell is the row of column to input data
  var counter = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("History").getRange("D2");
  
  // record DATE in cell A#
  var date = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("History").getRange("A"+counter.getValue());
  date.setValue(new Date(new Date().getFullYear(),new Date().getMonth(), new Date().getDate()));
  
  //read portfolio value in "Portfolio Sheet"
  var portfolioValue = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Portfolio").getRange("H18");
  var value = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("History").getRange("B"+counter.getValue());
  value.setValue(portfolioValue.getValue());
  
  //+1 to the counter in cell A1
  counter.setValue(counter.getValue() + 1);
}