Portfolio Visualizer

2801	AMF småbolag
18986	Six Gold Index
1933	Swedbank Ny Teknik
3323	Apple INC
19002	OMX Stockholm 30 Index

/**
* GS azPV v0.6
*/

function toPercent(val){
  return Math.round(val*10000)/100;
}

function azPV(id, chartResolution, max ) {
  
  var azPost_url = 'https://www.avanza.se/ab/component/highstockchart/getchart/orderbook';
  var cacheTime = 32400; // 32400s = 6 hours
  
  id = id || false;
  max = max || '1985'; // max to start with
  chartResolution = chartResolution || 'MONTH';
  
  // check if id was set
  if(!id) return 'Inget id definierat';
  
  // check if cached
  var cacheString = 'cache_' + id.toString() + max + chartResolution;
  var cache = CacheService.getScriptCache();
  var cacheData = cache.get(cacheString);
  
  var json = '{"orderbookId":%id%,"chartType":"AREA","widthOfPlotContainer":558,"chartResolution":"'+ chartResolution +'","navigator":false,"percentage":false,"volume":false,"owners":false,"timePeriod":"year","ta":[]}';
  
  // add id
  json = json.replace('%id%', id);
  
  // set max to rediculous number
  if( max ){
    var today = new Date().toJSON().slice(0,10);
    var rep = '"start":"'+ max +'-01-01","end":"'+ today +'"';
    json = json.replace('"timePeriod":"year"', rep);
  }
  
  // make the request
  var options = {
    'method' : 'post',
    'contentType': 'application/json',
    'payload' : json,
    'muteHttpExceptions': true
  };
  
  var response, data;
  
  if(cacheData != null) {
    data = cacheData;
  }
  else {
    response = UrlFetchApp.fetch(azPost_url, options);
    data = response.getContentText();
    cache.put(cacheString, data, cacheTime); // cache for 1 hour
  }
  
  var data = JSON.parse(data);
  var dataPoints = data.dataPoints;
  
  var rows = [],
      data, i=0, len = dataPoints.length;
  
  for (i; i<len; i++) {
    
    cur = dataPoints[i];
    var date = cur[0],
        nav = cur[1];
    
    var returns = 0;
    if( cur[1] != null ){
      returns = toPercent((nav/dataPoints[i-1][1])-1);
    }
    
    if( returns > 1000000 ) returns = 0;
    
    var jsdate = new Date(date),
        year = jsdate.getFullYear(),
        month = jsdate.getMonth() + 1, // jsdate = 0 based index
        day = jsdate.getDate();
    
    if( month < 10 ) { month = '0' + month; } // add leading zero
    if( day < 10 ) { day = '0' + day; } // add leading zero
    
    var ymd = year +'-'+ month;
    
    chartResolution == 'DAY' ? ymd += '-' + day : '';

    var csv = ymd + ',' + returns;
    
    if( nav ) {
      csv = csv + '%'; // add percentage
      rows.push([ymd, nav, returns, csv]);
    }
    
  } // end loop
  
  // set headers
  rows.unshift(['Datum','NAV', 'Avkastning','PV CSV-format']);
  
  return rows;
  
} // azPV()