#! /usr/bin/gawk -f
# Last edited on 2015-06-02 12:31:54 by stolfilocal

BEGIN { 
  if (SpU == "") { arg_error(("must define {SpU")); }
  SpN_LO = 99999999.99; 
  SpN_HI = 0.00; 
  VNOT = 0; 
  VSEK = 0; 
  NTr = 0;
} 

/[:]/ { 
  SpN_TR = $2;
  VNOT_TR = $3;
  NTr++;
  VSEK += VNOT_TR*SpN_TR; 
  VNOT += VNOT_TR;
  if (SpN_TR < SpN_LO) { SpN_LO = SpN_TR; }
  if (SpN_TR > SpN_HI) { SpN_HI = SpN_TR; }
} 

END { 
  VBTC = VNOT/200;
  SpN = VSEK/VNOT;
  UpB = SpN*200/SpU;
  printf "Date ! NTr ! SpN_LO ! SpN_HI ! VNOT ! VBTC ! VSEK ! SpN ! SpU ! UpB ! OBS\n"; 
  printf "     | %d | %.2f | %.2f | %d | %.3f | %.2f | %.5f | %.2f | %.2f | \n", NTr, SpN_LO, SpN_HI, VNOT, VBTC, VSEK, SpN, SpU, UpB; 
}