Custom Price List updated with Currency fluctuations

I want to update a price list each day with the correct price.  The base price is in USD and I want a list to be updated each evening with correct price from the NS Canadian dollar exchange rate.  I do not want to do an export/import process but a suite script.  Is this possible and how would we go about setting up the script.

It would look something like this (bad form js) function ????
  {
  //only execute when run from the scheduler
    if ( type != 'scheduled' && type != 'skipped' ) return;
 
  var priceUS = nlapilastpurchaseprice;
  var exchangeCAD = nlapiExchangeRate(USD, CAD, Today );
  var priceCAD = priceUS * exchangeCAD;