db_conn->execute_queries("GetUserAuth", 1, array($username, $pass)); if ($user) { $_SESSION['sessionId'] = $username . $pass . date("zY"); // set session identifier $_SESSION['userData'] = $user; } } function get_user($para) { global $global_config; $user = $this->db_conn->execute_queries("GetUserAuth", 1, array($this->user_dn, $this->pass)); ///$user = $this->db_conn->execute_queries("GetUserAuth", 1, array("nordea", "jhgfdsa")); return $user; } function is_logged_in($para) { ///$logged_in = $this->db_conn->execute_queries("GetUserAuth", 1, array($para, "jhgfdsa")); $logged_in = $this->db_conn->execute_queries("GetUserAuth", 1, array($this->user_dn, $this->pass)); return $logged_in; } function local_info() { $this->user_dn = $this->page_get_para('user', ""); $this->pass = $this->page_get_para('pass', ""); session_start(); $user = $this->db_conn->execute_queries("GetUserAuth", 1, array($this->user_dn, $this->pass)); if ($user != NULL) { $_SESSION['sessionId'] = $this->user_dn .$this->pass .date("zY"); // set session identifier $_SESSION['userData'] = $user; $this->msg .= "Login successful.
"; //$_SESSION['cur_user_name'] = $global_config['site']['title']." admin"; //return true; } if ($this->is_admin) { if ($this->page_get_para('submit', "") == "Upload" && isset($_FILES['upfile'])) { //print_r( $this->parse_file($_FILES['upfile'])); $this->msg = $this->save_uploads(true); //print_r( $this->msg); //exit; } else if ($this->page_get_para('submit', "") == "GroupUpload" && isset($_FILES['upfile'])){ $this->msg = $this->save_uploads(false); } } else { //$this->msg .= "Not logged in"; $this->msg .= ""; } } function page_init(/*$backcolor="white", */$url=null, $second=0){ $this->page_testSession(); //$this->page_info(); //$this->local_info(); if ($this->is_admin) { if ($this->page_get_para('submit', "") == "Upload" && isset($_FILES['upfile'])) { //print_r( $this->parse_file($_FILES['upfile'])); $this->msg = $this->save_uploads(true); //print_r( $this->msg); //exit; } else if ($this->page_get_para('submit', "") == "GroupUpload" && isset($_FILES['upfile'])){ $this->msg = $this->save_uploads(false); } } else { //$this->msg .= "Not logged in"; $this->msg .= ""; } } function page_show(/*$backcolor="white", */$url=null, $second=0){ $this->page_testSession(); $this->page_info(); $this->local_info(); echo $this->page_begin(/*$backcolor,*/$url, $second).$this->getForm().$this->page_end(); } function getFormColorshki(){ $html = "
\n". " \n". " \n". " \n". " \n". "\n". "
\n"; if ($this->msg != "") { if (count($this->msg) > 1) { $html .= "".$this->msg[0]."
"; unset($this->msg[0]); $html .= ""; /*if (count($this->savedIssues) > 0) { generatePerfCharts($this->db_conn, $this->savedIssues); } */ } else { // there's an error and let's just display that $html .= $this->msg; } } return $html; } function getForm(){ $html = "
\n". "\n". " \n". " \n". " \n". " \n". " \n". " \n". "
\n". " Admin Login
Username:
Password:
\n". " \n". " \n". "
\n". "
\n"; if ($this->msg != "") { if (count($this->msg) > 1) { $html .= "".$this->msg[0]."
"; unset($this->msg[0]); $html .= ""; /*if (count($this->savedIssues) > 0) { generatePerfCharts($this->db_conn, $this->savedIssues); } */ } else { // there's an error and let's just display that $html .= $this->msg; } } return $html; } function save_uploads($calc, $filename='upfile'){ if(isset($_FILES[$filename])) { $uploaddir = $this->writableDir; $uploadFileName = $uploaddir .date("ymd-His")."-".$_FILES[$filename]['name']; $success = move_uploaded_file($_FILES[$filename]['tmp_name'], $uploadFileName); if ($success){ return array_merge($this->parse_File($uploadFileName, $calc), array("Uploaded ". $_FILES[$filename]['name'] ." succesfully.\n")); } else { return "
  • Error uploading file
  • \n"; } } return "
  • Generic error
  • "; } function parse_File($file, $calc){ $usr = ($_SESSION['userData']->USR_BROKER_ID==""?$_SERVER['HTTP_USER_AGENT']:$_SESSION['userData']->USR_BROKER_ID); $handle = @fopen($file, "r"); $count = 0; $msg = array(); $this->savedIssues = array(); if ($handle) { while (!feof($handle)) { $items = preg_split("/\t/", trim(fgets($handle, 4096))); if (count($items) > 0 && substr($items[0], 0, 1) == "#") { // comment line continue; } if (count($items) > 2 && $items[0] != "") { // Make sure the current user is the broker of the issues to be updated $issue = $this->db_conn->execute_queries("GetIssueByISIN", 0, $items[0]); if ($line = mysql_fetch_object($issue)) { if ($line->ISSUE_BROKER_ID != $usr && // update only own issues $_SESSION['userData']->USR_IS_SUPERADMIN != 1) { $msg[] = "Error: You can only update your own issues, ISIN ".$line->ISSUE_ISIN.". Line skipped."; continue; } } $msg[] = $this->save_Quote($items[0], $items[1], strtotime(trim($items[2]))); if (count($items) > 3){ // issue data is also included in this data entry if (count($items) == 9) { $msg[] = $this->save_Issue($items[3], $items[4], $items[5], $items[0], $items[6], $items[7], rtrim($items[8])); } elseif (count($items) == 12){ $msg[] = $this->save_Issue( $items[3], $items[4], $items[5], $items[0], $items[6], $items[7], trim($items[8]), $items[9], $items[10], rtrim($items[11])); } elseif (count($items) == 13){ // with risk category $msg[] = $this->save_Issue( $items[3], $items[4], $items[5], $items[0], $items[6], $items[7], trim($items[8]), $items[9], $items[10], $items[11], rtrim($items[12])); } elseif (count($items) == 14){ // with loan number $msg[] = $this->save_Issue( $items[3], $items[4], $items[5], $items[0], $items[6], $items[7], trim($items[8]), $items[9], $items[10], $items[11], rtrim($items[12]), rtrim($items[13])); } elseif (count($items) == 16){ $msg[] = $this->save_Issue( $items[3], $items[4], $items[5], $items[0], $items[6], $items[7], trim($items[8]), $items[9], $items[10], $items[11], $items[12], $items[13], rtrim($items[14]), rtrim($items[15])); } else { $msg[] = "Error: The data file is missing information, please check your file format."; } } if (substr_count($msg[count($msg) - 1], "Error:") == 0) { // if the line didn't contain errors $count++; if(!in_array($items[0], $this->savedIssues)) $this->savedIssues[] = $items[0]; } } } fclose($handle); if ($calc){ foreach($this->savedIssues as $isin){ $this->calculate_Issue($isin); } //generatePerfCharts($this->db_conn, $this->savedIssues); } } $msg = array_merge(array($count." records were updated"), $msg); return $msg; } function calculate_Issue($isin){ $latestQuote = $this->db_conn->execute_queries("LatestQuote", 0, array('isin'=>$isin)); if ($line = mysql_fetch_object($latestQuote)) { $calculatedValues = $this->db_conn->execute_queries("CalcualteIssue", 0, array('isin' => $isin, 'price' => $line->ISSUE_DATA_CLOSE, 'latestDate' => date('Y-m-d', strtotime($line->ISSUE_DATA_DATE)))); if ($line2 = mysql_fetch_object($calculatedValues)) { $this->db_conn->execute_queries("UpdateCalculation", -1, array( 'STR_P' => round($line2->STR_P, 6), 'MRT_P' => round($line2->MRT_P, 6), 'YTD_P' => round($line2->YTD_P, 6), 'HYRT_P' => round($line2->HYRT_P, 6), 'VOLA' => is_null($line2->VOLA)?0:round($line2->VOLA,6), 'STR' => round($line2->STR, 6), 'MRT' => round($line2->MRT, 6), 'YTD' => round($line2->YTD, 6), 'HYRT' => round($line2->HYRT, 6), 'LATEST_QUOTE' => round($line->ISSUE_DATA_CLOSE, 6), 'LATEST_QUOTE_DATE' => date('Y-m-d', strtotime($line->ISSUE_DATA_DATE)), 'ISSUE_ISIN' => $isin )); } mysql_free_result($calculatedValues); } mysql_free_result($latestQuote); } function save_Issue($issuename, $issuedate, $maturitydate, $isin, $issuer, $issue_type='PUBLIC', $currency, $subStart = null, $subEnd = null, $product='BOND', $riskcate=1, $loan='', $gCoupon='', $pCoupon='' ) { $issueExist = $this->db_conn->execute_queries("GetIssueByISIN", 0, $isin); $issuerRow = $this->db_conn->execute_queries("FindIssuer", 0, strtolower($issuer)); $msg = ""; $issuerId = 0; // Sanity checks if (strtotime($issuedate) == "") { return "Error: issue date \"".$issuedate."\" is invalid. Skipped line."; } if (strtotime($maturitydate) == "") { return "Error: maturity date \"".$maturitydate."\" is invalid. Skipped line."; } if (strtotime($subStart) == "") { $subStart = $this->dateUnknown; } if (strtotime($subEnd) == "") { $subEnd = $this->dateUnknown; } if ($line = mysql_fetch_object($issuerRow)) { $issuerId = $line->ISSUER_ID; } else { // XZ if the issuer is not found, then add a new issuer $this->db_conn->execute_queries("InsertIssuer", -1, $issuer); $issuerRow = $this->db_conn->execute_queries("FindIssuer", 0, strtolower($issuer)); $line = mysql_fetch_object($issuerRow); $issuerId = $line->ISSUER_ID; //return "Error: issuer name \"".$issuer."\" can not be found in database. Skipped line."; } if (strlen($currency) > 3) { return "Error: currency \"".$currency."\" is invalid. Skipped line."; } // quick fix that the Nordea spirit is not upto date to have the risk category field if(is_numeric($riskcate) && $riskcate> 10){ $loan = $riskcate; $riskcate = 1; } if(!is_numeric($riskcate)){ $loan = $riskcate; $riskcate = 1; } $para = array( 'issuename' => charset_decode_utf_8($issuename), 'issuedate' => date('Y-m-d', strtotime($issuedate)), 'maturitydate' => date('Y-m-d', strtotime($maturitydate)), 'broker_id' => ($_SESSION['userData']->USR_BROKER_ID == ""?$_SERVER['HTTP_USER_AGENT']:$_SESSION['userData']->USR_BROKER_ID), 'issuer_id' => $issuerId, 'currency' => $currency, 'issue_type' => $issue_type, 'isin' => $isin, 'sub_start' => date('Y-m-d', strtotime($subStart)), 'sub_end' => date('Y-m-d', strtotime($subEnd)), 'product' => $product, 'gCoupon' => $gCoupon, 'pCoupon' => $pCoupon, 'loan_number' => $loan, 'risk_cate' => $riskcate); if (mysql_num_rows($issueExist) == 1) { // updating a issue $this->db_conn->execute_queries("UpdateIssue", -1, $para); $msg = "Updated issue ".$isin; } else { // inserting a new issue $this->db_conn->execute_queries("InsertIssue", -1, $para); $msg = "Inserted a new issue ".$isin; } mysql_free_result($issueExist); mysql_free_result($issuerRow); return $msg; } function save_Quote($isin, $quote, $date){ $quote = str_replace(",", ".", $quote); $quoteDb = $this->db_conn->execute_queries("SelectAQuote", 0, array('isin'=>$isin, 'date'=>date('Y-m-d', $date))); $msg = ""; $id = 0; if (mysql_num_rows($quoteDb) == 0){ $this->db_conn->execute_queries("InsertQuote", -1, array('isin'=>$isin, 'quote'=>$quote, 'date'=>date('Y-m-d', $date))); $msg .= "Inserted quote for ".$isin." with date ".date('Y-m-d', $date); } else { while ($line = mysql_fetch_object($quoteDb)){ $id = $line->ISSUE_DATA_ID; //$msg .= $line->ISSUE_DATA_ID; } $this->db_conn->execute_queries("UpdateQuote", -1, array('isin'=>$isin, 'quote'=>$quote, 'date'=>date('Y-m-d', $date), 'id'=>$id)); $msg .= "Updated quote for ".$isin." with date ".date('Y-m-d', $date); } mysql_free_result($quoteDb); return $msg; } } ?>
    PriceDate
    102,00000%2.2.2015
    106,90000%10.4.2015
    107,36000%13.4.2015
    107,41000%14.4.2015
    107,82000%15.4.2015
    108,05000%16.4.2015
    107,38000%20.4.2015
    107,72000%21.4.2015
    107,89000%22.4.2015
    106,89000%23.4.2015
    106,52000%24.4.2015
    106,42000%27.4.2015
    106,90000%28.4.2015
    106,41000%29.4.2015
    105,05000%30.4.2015
    105,08000%4.5.2015
    105,08000%5.5.2015
    104,15000%6.5.2015
    103,22000%7.5.2015
    103,95000%8.5.2015
    104,29000%11.5.2015
    103,97000%12.5.2015
    103,56000%13.5.2015
    103,88000%15.5.2015
    103,70000%18.5.2015
    103,99000%19.5.2015
    104,20000%20.5.2015
    104,38000%21.5.2015
    104,45000%22.5.2015
    104,10000%25.5.2015
    103,90000%26.5.2015
    103,83000%27.5.2015
    103,86000%28.5.2015
    103,77000%29.5.2015
    103,33000%1.6.2015
    103,65000%2.6.2015
    103,26000%3.6.2015
    102,41000%4.6.2015
    102,11000%5.6.2015
    101,86000%8.6.2015
    101,09000%10.6.2015
    101,49000%11.6.2015
    101,54000%12.6.2015
    101,09000%15.6.2015
    100,68000%16.6.2015
    101,34000%17.6.2015
    100,78000%18.6.2015
    100,90000%22.6.2015
    100,95000%23.6.2015
    101,20000%24.6.2015
    101,26000%25.6.2015
    101,14000%26.6.2015
    99,83000%29.6.2015
    100,19000%30.6.2015
    99,88000%1.7.2015
    99,81000%2.7.2015
    99,50000%3.7.2015
    99,02000%6.7.2015
    99,05000%7.7.2015
    98,63000%8.7.2015
    98,72000%9.7.2015
    99,77000%10.7.2015
    99,49000%13.7.2015
    100,08000%14.7.2015
    100,29000%15.7.2015
    100,43000%16.7.2015
    100,72000%17.7.2015
    101,38000%20.7.2015
    101,92000%21.7.2015
    100,62000%22.7.2015
    100,78000%23.7.2015
    100,31000%24.7.2015
    99,97000%27.7.2015
    99,80000%28.7.2015
    99,75000%29.7.2015
    100,16000%30.7.2015
    100,08000%31.7.2015
    99,99000%3.8.2015
    100,15000%4.8.2015
    100,33000%5.8.2015
    100,07000%6.8.2015
    100,06000%7.8.2015
    100,32000%10.8.2015
    100,24000%11.8.2015
    99,50000%12.8.2015
    99,84000%13.8.2015
    99,72000%14.8.2015
    99,89000%17.8.2015
    99,67000%18.8.2015
    99,36000%19.8.2015
    98,90000%20.8.2015
    98,19000%21.8.2015
    97,17000%24.8.2015
    97,25000%25.8.2015
    96,81000%26.8.2015
    97,80000%27.8.2015
    98,07000%28.8.2015
    97,92000%31.8.2015
    97,43000%1.9.2015
    96,93000%2.9.2015
    97,18000%3.9.2015
    97,38000%4.9.2015
    97,37000%7.9.2015
    97,41000%8.9.2015
    98,20000%9.9.2015
    97,42000%10.9.2015
    97,40000%11.9.2015
    97,34000%14.9.2015
    97,20000%15.9.2015
    97,24000%16.9.2015
    97,22000%17.9.2015
    96,98000%18.9.2015
    97,12000%21.9.2015
    97,13000%22.9.2015
    96,63000%23.9.2015
    96,55000%24.9.2015
    96,22000%25.9.2015
    95,79000%28.9.2015
    95,26000%29.9.2015
    95,95000%30.9.2015
    96,04000%1.10.2015
    96,25000%2.10.2015
    96,74000%5.10.2015
    96,83000%6.10.2015
    97,12000%7.10.2015
    97,29000%8.10.2015
    97,60000%9.10.2015
    97,94000%12.10.2015
    97,52000%13.10.2015
    97,25000%14.10.2015
    97,71000%15.10.2015
    97,52000%16.10.2015
    97,23000%19.10.2015
    97,36000%20.10.2015
    97,15000%21.10.2015
    96,92000%22.10.2015
    97,91000%23.10.2015
    98,07000%26.10.2015
    97,97000%27.10.2015
    97,88000%28.10.2015
    98,00000%29.10.2015
    97,84000%30.10.2015
    97,69000%2.11.2015
    98,03000%3.11.2015
    98,33000%4.11.2015
    98,71000%5.11.2015
    98,75000%6.11.2015
    98,89000%9.11.2015
    98,76000%10.11.2015
    98,79000%11.11.2015
    98,96000%12.11.2015
    98,46000%13.11.2015
    98,39000%16.11.2015
    99,42000%17.11.2015
    99,32000%18.11.2015
    99,89000%19.11.2015
    99,82000%20.11.2015
    100,16000%23.11.2015
    100,33000%24.11.2015
    100,06000%25.11.2015
    100,56000%26.11.2015
    100,64000%27.11.2015
    100,70000%30.11.2015
    101,25000%1.12.2015
    101,45000%2.12.2015
    101,27000%3.12.2015
    100,14000%4.12.2015
    100,04000%7.12.2015
    99,95000%8.12.2015
    98,88000%10.12.2015
    99,35000%11.12.2015
    98,70000%14.12.2015
    98,05000%15.12.2015
    98,36000%16.12.2015
    98,90000%17.12.2015
    98,65000%18.12.2015
    98,33000%21.12.2015
    98,27000%22.12.2015
    98,40000%23.12.2015
    98,98000%28.12.2015
    98,59000%29.12.2015
    98,72000%30.12.2015
    98,63000%31.12.2015
    97,92000%4.1.2016
    98,06000%5.1.2016
    97,05000%7.1.2016
    97,42000%8.1.2016
    97,31000%11.1.2016
    97,43000%12.1.2016
    97,98000%13.1.2016
    97,54000%14.1.2016
    97,09000%15.1.2016
    96,83000%18.1.2016
    96,87000%19.1.2016
    96,78000%21.1.2016
    97,68000%22.1.2016
    97,62000%25.1.2016
    97,17000%26.1.2016
    98,11000%27.1.2016
    98,08000%28.1.2016
    98,25000%29.1.2016
    98,67000%1.2.2016
    98,38000%2.2.2016
    97,99000%3.2.2016
    98,28000%4.2.2016
    98,20000%5.2.2016
    98,15000%8.2.2016
    96,98000%10.2.2016
    97,04000%11.2.2016
    97,08000%12.2.2016
    97,65000%15.2.2016
    98,00000%16.2.2016
    97,87000%17.2.2016
    98,27000%19.2.2016
    98,50000%22.2.2016
    98,54000%23.2.2016
    98,15000%24.2.2016
    98,13000%25.2.2016
    98,35000%26.2.2016
    98,37000%29.2.2016
    98,68000%1.3.2016
    99,31000%2.3.2016
    99,02000%3.3.2016
    99,32000%4.3.2016
    99,19000%7.3.2016
    99,16000%8.3.2016
    99,20000%9.3.2016
    99,13000%10.3.2016
    99,07000%11.3.2016
    99,50000%14.3.2016
    99,35000%15.3.2016
    99,68000%16.3.2016
    99,82000%17.3.2016
    100,16000%18.3.2016
    100,07000%21.3.2016
    100,08000%22.3.2016
    100,46000%23.3.2016
    100,02000%24.3.2016
    100,03000%29.3.2016
    100,30000%30.3.2016
    100,12000%31.3.2016
    99,66000%1.4.2016
    99,73000%4.4.2016
    99,67000%5.4.2016
    99,62000%6.4.2016
    99,76000%7.4.2016
    99,81000%8.4.2016
    100,11000%11.4.2016
    100,16000%12.4.2016
    100,54000%13.4.2016
    100,73000%14.4.2016
    100,77000%15.4.2016
    101,08000%19.4.2016
    101,30000%20.4.2016
    101,45000%21.4.2016
    100,63000%22.4.2016
    100,49000%26.4.2016
    100,06000%27.4.2016
    100,00000%28.4.2016
    100,19000%29.4.2016
    100,17000%2.5.2016
    100,02000%3.5.2016
    99,87000%4.5.2016
    99,77000%6.5.2016
    99,99000%9.5.2016
    100,16000%10.5.2016
    100,21000%11.5.2016
    100,34000%12.5.2016
    99,97000%13.5.2016
    100,07000%16.5.2016
    100,33000%17.5.2016
    100,24000%18.5.2016
    100,06000%19.5.2016
    100,28000%23.5.2016
    100,09000%24.5.2016
    100,56000%25.5.2016
    100,71000%26.5.2016
    100,91000%27.5.2016
    101,02000%30.5.2016
    100,86000%31.5.2016
    100,95000%1.6.2016
    100,88000%2.6.2016
    101,07000%3.6.2016
    101,16000%6.6.2016
    101,55000%7.6.2016
    101,86000%9.6.2016
    101,58000%10.6.2016
    100,89000%13.6.2016
    100,46000%14.6.2016
    100,37000%16.6.2016
    100,51000%17.6.2016
    101,16000%20.6.2016
    100,55000%21.6.2016
    100,83000%22.6.2016
    100,94000%23.6.2016
    100,14000%27.6.2016
    100,06000%28.6.2016
    100,11000%29.6.2016
    100,35000%30.6.2016
    100,77000%1.7.2016
    101,47000%4.7.2016
    100,86000%5.7.2016
    100,67000%6.7.2016
    100,80000%7.7.2016
    100,84000%8.7.2016
    101,61000%11.7.2016
    102,78000%12.7.2016
    102,87000%13.7.2016
    103,11000%14.7.2016
    102,55000%15.7.2016
    102,78000%18.7.2016
    102,78000%19.7.2016
    102,70000%20.7.2016
    103,13000%21.7.2016
    102,75000%22.7.2016
    103,26000%25.7.2016
    103,36000%26.7.2016
    103,46000%27.7.2016
    103,44000%28.7.2016
    103,28000%29.7.2016
    103,33000%1.8.2016
    102,79000%2.8.2016
    102,64000%3.8.2016
    102,74000%4.8.2016
    103,20000%5.8.2016
    103,40000%8.8.2016
    103,56000%9.8.2016
    103,86000%10.8.2016
    103,98000%11.8.2016
    104,36000%12.8.2016
    103,96000%15.8.2016
    103,83000%16.8.2016
    103,50000%17.8.2016
    103,35000%18.8.2016
    103,48000%19.8.2016
    103,24000%22.8.2016
    103,45000%23.8.2016
    103,61000%24.8.2016
    103,47000%25.8.2016
    103,68000%26.8.2016
    104,00000%29.8.2016
    104,11000%30.8.2016
    103,73000%31.8.2016
    103,71000%1.9.2016
    103,77000%2.9.2016
    104,41000%5.9.2016
    104,28000%6.9.2016
    104,48000%7.9.2016
    104,63000%8.9.2016
    104,38000%9.9.2016
    103,35000%12.9.2016
    103,79000%13.9.2016
    103,38000%14.9.2016
    103,38000%15.9.2016
    103,50000%16.9.2016
    103,63000%19.9.2016
    103,65000%20.9.2016
    103,96000%21.9.2016
    104,21000%22.9.2016
    104,59000%23.9.2016
    104,50000%26.9.2016
    104,46000%27.9.2016
    104,46000%28.9.2016
    104,65000%29.9.2016
    104,68000%3.10.2016
    105,01000%4.10.2016
    104,81000%5.10.2016
    104,79000%6.10.2016
    104,60000%7.10.2016
    104,51000%10.10.2016
    104,48000%11.10.2016
    104,40000%12.10.2016
    104,09000%13.10.2016
    104,21000%14.10.2016
    104,18000%17.10.2016
    104,33000%18.10.2016
    104,11000%19.10.2016
    104,21000%20.10.2016
    104,16000%21.10.2016
    104,22000%24.10.2016
    103,98000%25.10.2016
    104,16000%26.10.2016
    103,80000%27.10.2016
    103,64000%28.10.2016
    103,58000%31.10.2016
    103,73000%1.11.2016
    103,15000%2.11.2016
    102,93000%3.11.2016
    102,71000%4.11.2016
    103,05000%7.11.2016
    102,90000%9.11.2016
    104,39000%10.11.2016
    103,95000%11.11.2016
    103,74000%14.11.2016
    103,01000%15.11.2016
    103,69000%16.11.2016
    103,38000%17.11.2016
    103,74000%18.11.2016
    104,01000%21.11.2016
    104,31000%22.11.2016
    104,47000%23.11.2016
    104,74000%24.11.2016
    104,78000%25.11.2016
    104,85000%28.11.2016
    104,35000%29.11.2016
    104,44000%30.11.2016
    104,54000%1.12.2016
    104,54000%5.12.2016
    105,35000%8.12.2016
    105,38000%9.12.2016
    105,52000%12.12.2016
    105,64000%13.12.2016
    105,74000%14.12.2016
    105,63000%15.12.2016
    105,48000%16.12.2016
    105,20000%19.12.2016
    105,91000%21.12.2016
    105,93000%22.12.2016
    105,69000%23.12.2016
    106,31000%27.12.2016
    106,24000%28.12.2016
    106,23000%29.12.2016
    106,12000%30.12.2016
    106,24000%2.1.2017
    106,79000%3.1.2017
    106,52000%5.1.2017
    106,36000%9.1.2017
    106,01000%11.1.2017
    106,05000%12.1.2017
    106,07000%13.1.2017
    106,13000%16.1.2017
    105,97000%18.1.2017
    106,52000%19.1.2017
    106,62000%20.1.2017
    106,75000%23.1.2017
    106,79000%24.1.2017
    106,79000%25.1.2017
    107,58000%26.1.2017
    107,41000%27.1.2017
    107,15000%30.1.2017
    106,56000%31.1.2017
    106,78000%1.2.2017
    106,92000%2.2.2017
    106,63000%3.2.2017
    106,53000%6.2.2017
    106,45000%8.2.2017
    105,97000%9.2.2017
    106,49000%14.2.2017
    106,77000%15.2.2017
    107,03000%16.2.2017
    106,92000%20.2.2017
    106,72000%21.2.2017
    107,08000%22.2.2017
    107,03000%23.2.2017
    106,97000%24.2.2017
    106,75000%27.2.2017
    106,40000%28.2.2017
    107,21000%2.3.2017
    107,15000%3.3.2017
    107,08000%6.3.2017
    106,95000%7.3.2017
    107,18000%8.3.2017
    106,82000%9.3.2017
    106,80000%10.3.2017
    106,69000%13.3.2017
    106,80000%14.3.2017
    106,92000%15.3.2017
    107,47000%16.3.2017
    107,20000%17.3.2017
    107,82000%20.3.2017
    108,03000%21.3.2017
    106,99000%22.3.2017
    107,52000%23.3.2017
    107,68000%24.3.2017
    107,52000%27.3.2017
    107,62000%28.3.2017
    107,62000%30.3.2017
    107,71000%3.4.2017
    108,04000%5.4.2017
    107,99000%6.4.2017
    107,90000%7.4.2017
    108,20000%10.4.2017
    108,39000%11.4.2017
    108,75000%12.4.2017
    109,03000%13.4.2017
    109,74000%18.4.2017
    109,18000%19.4.2017
    109,00000%20.4.2017
    109,63000%21.4.2017
    110,26000%24.4.2017
    110,68000%25.4.2017
    110,74000%26.4.2017
    111,66000%27.4.2017
    111,21000%28.4.2017
    111,64000%2.5.2017
    111,53000%3.5.2017
    111,32000%4.5.2017
    110,99000%5.5.2017
    111,29000%8.5.2017
    111,32000%9.5.2017
    111,19000%11.5.2017
    110,73000%12.5.2017
    110,90000%15.5.2017
    110,51000%17.5.2017
    109,70000%18.5.2017
    109,90000%19.5.2017
    109,90000%22.5.2017
    110,63000%23.5.2017
    111,01000%24.5.2017
    111,36000%26.5.2017
    111,29000%29.5.2017
    111,36000%30.5.2017
    111,20000%31.5.2017
    110,88000%1.6.2017
    111,49000%2.6.2017
    111,07000%6.6.2017
    111,20000%7.6.2017
    111,60000%8.6.2017
    111,96000%12.6.2017
    112,08000%13.6.2017
    113,09000%14.6.2017
    112,08000%15.6.2017
    111,61000%16.6.2017
    113,15000%19.6.2017
    113,15000%20.6.2017
    112,20000%21.6.2017
    112,20000%22.6.2017
    111,95000%26.6.2017
    111,79000%27.6.2017
    110,76000%28.6.2017
    111,51000%29.6.2017
    109,90000%30.6.2017
    110,73000%3.7.2017
    110,91000%4.7.2017
    111,16000%5.7.2017
    111,62000%6.7.2017
    111,20000%7.7.2017
    111,58000%10.7.2017
    112,19000%11.7.2017
    113,13000%14.7.2017
    113,46000%17.7.2017
    113,46000%18.7.2017
    112,51000%20.7.2017
    111,92000%21.7.2017
    111,46000%24.7.2017
    110,68000%25.7.2017
    110,56000%26.7.2017
    111,23000%27.7.2017
    110,07000%28.7.2017
    110,08000%31.7.2017
    109,88000%1.8.2017
    110,24000%2.8.2017
    109,98000%3.8.2017
    110,04000%4.8.2017
    110,66000%7.8.2017
    110,95000%8.8.2017
    110,48000%22.8.2017
    110,22000%29.8.2017
    110,69000%30.8.2017
    111,33000%31.8.2017
    111,92000%1.9.2017
    111,39000%4.9.2017
    111,73000%5.9.2017
    111,73000%6.9.2017
    111,55000%7.9.2017
    111,52000%8.9.2017
    111,93000%11.9.2017
    112,50000%12.9.2017
    112,51000%13.9.2017
    112,36000%14.9.2017
    111,99000%15.9.2017
    112,14000%18.9.2017
    112,65000%19.9.2017
    112,64000%25.9.2017
    112,52000%26.9.2017
    112,61000%27.9.2017
    112,94000%28.9.2017
    113,06000%29.9.2017
    113,49000%2.10.2017
    113,45000%3.10.2017
    113,77000%4.10.2017
    114,25000%5.10.2017
    114,43000%6.10.2017
    114,03000%9.10.2017
    113,93000%10.10.2017
    114,15000%11.10.2017
    114,27000%12.10.2017
    114,24000%13.10.2017
    114,46000%16.10.2017
    114,57000%17.10.2017
    114,64000%18.10.2017
    114,68000%19.10.2017
    114,65000%20.10.2017
    115,01000%23.10.2017
    115,62000%24.10.2017
    114,38000%26.10.2017
    114,70000%27.10.2017
    114,71000%31.10.2017
    114,68000%1.11.2017