Return to Revisions

With the following Google Apps Script you can grab the LIBOR value and added it to a new sheet. Goto the script editor:

and add this script:

function myCustomCalculation() {
  //set active spreadsheet
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  
  // flush the spreadsheet before using it  
  SpreadsheetApp.flush();

  // get both the sheets 
  var sh0 = ss.getSheets()[0], sh1 = ss.getSheets()[1];
  
  // get cell value from sheet[0]
  var cell = sh0.getRange("D2").getValues()[0];
  
  // add libor value to other sheet  
  sh1.appendRow([new Date(), cell]);
}

The clue to the story is to create a time based trigger:

and set the trigger to execute at 5-6 pm:

See the example file I´ve created: LIBOR. I've added an extra menu item, so that you can execute the script this way.