Untitled

function loadmarkethistory(priceIDs,regionID){
  if (typeof regionID == 'undefined'){
    regionID=10000002;
  }
  if (typeof priceIDs == 'undefined'){
    throw 'Need a list of typeids';
  }

  var prices = new Array();
  var dirtyTypeIds = new Array();
  var cleanTypeIds = new Array();
  var url="https://www.mokaam.dk/API/market/items?regionid="+regionID+"&typeid="
  
  priceIDs.forEach (function (row) {
    row.forEach ( function (cell) {
     if (typeof(cell) === 'number' ) {
        dirtyTypeIds.push(cell);
      }
    });
  });
  cleanTypeIds = dirtyTypeIds.filter(function(v,i,a) {
    return a.indexOf(v)===i;
  });
  
  prices.push([ 'TypeID',
                'Last updated',
                'Vol. yesterday',
                'Median vol. last week',
                'Median vol. last month',
                'Median vol. last quarter',
                'Median vol. last year',
                'Avg. price yesterday',
                'Median avg. price last week',
                'Median avg. price last month',
                'Median avg. price last quarter',
                'Median avg. price last year',
                'Order count yesterday',
                'Order count last week',
                'Order count last month',
                'Order count last quarter',
                'Order count last year',
                'Size yesterday',
                'Median size last week',
                'Median size last month',
                'Median size last quarter',
                'Median size last year',
                'Highest price yesterday',
                'Median highest price last week',
                'Median highest price last month',
                'Median highest price last quarter',
                'Median highest price last year',
                'Highest price yesterday',
                'Higest price last week',
                'Highest price last month',
                'Highest price last quarter',
                'Highest price last year',
                'Lowest price yesterday',
                'Median lowest price last week',
                'Median lowest price last month',
                'Median lowest price last quarter',
                'Median lowest price last year',
                'Lowest price yesterday',
                'Lowest price last week',
                'Lowest price last month',
                'Lowest price last quarter',
                'Lowest price last year',
                'Spread yesterday',
                'Median spread last week',
                'Median spread last month',
                'Median spread last quarter',
                'Median spread last year',
                'VWAP last week',
                'VWAP last month',
                'VWAP last quarter',
                'VWAP last year',
                '52 week low',
                '52 week high',
                'Std dev week',
                'Std dev month',
                'Std dev quarter',
                'Std dev year'])
                
  var parameters = {method : "get", payload : ""};
  
  var o,j,temparray,chunk = 100;
  for (o=0,j=cleanTypeIds.length; o < j; o+=chunk) {
    temparray = cleanTypeIds.slice(o,o+chunk);
    Utilities.sleep(100);
    var types=temparray.join(",").replace(/,$/,'')
    var jsonFeed = UrlFetchApp.fetch(url+types, parameters).getContentText();
    var json = JSON.parse(jsonFeed);
    if(json) {
      for(i in json) {
        var price=[parseInt(i),
                   json[i].last_data,
                   parseFloat(json[i].vol_yesterday),
                   parseFloat(json[i].vol_week),
                   parseFloat(json[i].vol_month),
                   parseFloat(json[i].vol_quarter),
                   parseFloat(json[i].vol_year),
                   parseFloat(json[i].avg_price_yesterday),
                   parseFloat(json[i].avg_price_week),
                   parseFloat(json[i].avg_price_month),
                   parseFloat(json[i].avg_price_quarter),
                   parseFloat(json[i].avg_price_year),
                   parseFloat(json[i].order_count_yesterday),
                   parseFloat(json[i].order_count_week),
                   parseFloat(json[i].order_count_month),
                   parseFloat(json[i].order_count_quarter),
                   parseFloat(json[i].order_count_year),
                   parseFloat(json[i].size_yesterday),
                   parseFloat(json[i].size_week),
                   parseFloat(json[i].size_month),
                   parseFloat(json[i].size_quarter),
                   parseFloat(json[i].size_year),
                   parseFloat(json[i].high_yesterday),
                   parseFloat(json[i].high_week),
                   parseFloat(json[i].high_month),
                   parseFloat(json[i].high_quarter),
                   parseFloat(json[i].high_year),
                   parseFloat(json[i].ab_high_yesterday),
                   parseFloat(json[i].ab_high_week),
                   parseFloat(json[i].ab_high_month),
                   parseFloat(json[i].ab_high_quarter),
                   parseFloat(json[i].ab_high_year),
                   parseFloat(json[i].low_yesterday),
                   parseFloat(json[i].low_week),
                   parseFloat(json[i].low_month),
                   parseFloat(json[i].low_quarter),
                   parseFloat(json[i].low_year),
                   parseFloat(json[i].ab_low_yesterday),
                   parseFloat(json[i].ab_low_week),
                   parseFloat(json[i].ab_low_month),
                   parseFloat(json[i].ab_low_quarter),
                   parseFloat(json[i].ab_low_year),
                   parseFloat(json[i].spread_yesterday),
                   parseFloat(json[i].spread_week),
                   parseFloat(json[i].spread_month),
                   parseFloat(json[i].spread_quarter),
                   parseFloat(json[i].spread_year),
                   parseFloat(json[i].vwap_week),
                   parseFloat(json[i].vwap_month),
                   parseFloat(json[i].vwap_quarter),
                   parseFloat(json[i].vwap_year),
                   parseFloat(json[i]._52w_low),
                   parseFloat(json[i]._52w_high),
                   parseFloat(json[i].std_dev_week),
                   parseFloat(json[i].std_dev_month),
                   parseFloat(json[i].std_dev_quarter),
                   parseFloat(json[i].std_dev_year)];
        prices.push(price);
      }
    }
  }
  return prices;
}