function loadPrices() {

  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getSheetByName("Bazar");
  var datarange = sheet.getDataRange();

  var numRows = datarange.getNumRows();

  for (var i=2; i <= numRows; i++){
    var id = sheet.getRange(i, 2).getValue();
    var records = fetchRecords(id);

    Logger.log(records.sells.unit_price/10000+"uu");

    sheet.getRange(i, 3).setValue(records.buys.unit_price/10000);
    sheet.getRange(i, 4).setValue(records.sells.unit_price/10000);
  }
}

function fetchRecords(id) {
  if(id==null || id == "") id = 46736;
  var url = "https://api.guildwars2.com/v2/commerce/prices/"+id;
  var recordJSON = UrlFetchApp.fetch(url);
  return JSON.parse(recordJSON);
}