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
    107,06000%11.7.2012
    106,39000%12.7.2012
    106,63000%13.7.2012
    106,85000%16.7.2012
    106,96000%17.7.2012
    107,37000%18.7.2012
    108,37000%19.7.2012
    109,15000%20.7.2012
    109,12000%23.7.2012
    107,17000%24.7.2012
    107,32000%25.7.2012
    106,98000%26.7.2012
    107,34000%27.7.2012
    108,59000%30.7.2012
    109,58000%31.7.2012
    107,91000%1.8.2012
    107,97000%2.8.2012
    107,63000%3.8.2012
    108,17000%6.8.2012
    108,90000%7.8.2012
    109,24000%8.8.2012
    109,78000%9.8.2012
    109,79000%10.8.2012
    110,08000%13.8.2012
    110,44000%14.8.2012
    110,06000%15.8.2012
    109,87000%16.8.2012
    109,98000%17.8.2012
    109,98000%20.8.2012
    109,60000%21.8.2012
    108,92000%22.8.2012
    108,67000%23.8.2012
    108,67000%24.8.2012
    108,18000%27.8.2012
    107,97000%28.8.2012
    107,66000%29.8.2012
    106,68000%30.8.2012
    106,32000%31.8.2012
    105,99000%3.9.2012
    105,99000%5.9.2012
    104,93000%6.9.2012
    105,99000%7.9.2012
    105,97000%10.9.2012
    105,65000%11.9.2012
    105,68000%12.9.2012
    105,26000%13.9.2012
    106,20000%14.9.2012
    106,88000%18.9.2012
    106,77000%20.9.2012
    106,29000%26.9.2012
    106,20000%28.9.2012
    105,91000%1.10.2012
    106,09000%2.10.2012
    105,95000%3.10.2012
    105,40000%4.10.2012
    105,58000%5.10.2012
    105,16000%8.10.2012
    105,45000%9.10.2012
    105,36000%10.10.2012
    105,53000%11.10.2012
    105,56000%12.10.2012
    105,24000%15.10.2012
    104,96000%16.10.2012
    104,80000%17.10.2012
    105,25000%18.10.2012
    105,40000%19.10.2012
    105,26000%22.10.2012
    105,45000%23.10.2012
    104,61000%24.10.2012
    104,57000%25.10.2012
    104,77000%26.10.2012
    104,68000%29.10.2012
    104,26000%30.10.2012
    104,29000%31.10.2012
    104,40000%1.11.2012
    105,28000%2.11.2012
    105,47000%5.11.2012
    105,34000%6.11.2012
    104,69000%8.11.2012
    103,86000%9.11.2012
    103,92000%12.11.2012
    103,54000%13.11.2012
    103,12000%14.11.2012
    102,04000%15.11.2012
    102,19000%16.11.2012
    102,42000%20.11.2012
    102,77000%21.11.2012
    102,67000%23.11.2012
    102,49000%26.11.2012
    102,16000%27.11.2012
    102,11000%29.11.2012
    102,11000%30.11.2012
    102,08000%3.12.2012
    102,01000%4.12.2012
    102,25000%5.12.2012
    103,89000%7.12.2012
    104,31000%10.12.2012
    104,46000%11.12.2012
    104,54000%12.12.2012
    104,13000%13.12.2012
    104,08000%14.12.2012
    104,13000%17.12.2012
    103,60000%18.12.2012
    103,67000%19.12.2012
    103,96000%20.12.2012
    104,23000%21.12.2012
    103,86000%31.12.2012
    104,50000%2.1.2013
    105,96000%3.1.2013
    106,88000%4.1.2013
    106,35000%7.1.2013
    105,02000%8.1.2013
    105,12000%9.1.2013
    104,31000%14.1.2013
    104,52000%16.1.2013
    104,36000%18.1.2013
    104,66000%22.1.2013
    104,96000%23.1.2013
    104,80000%24.1.2013
    104,09000%25.1.2013
    103,97000%28.1.2013
    103,58000%29.1.2013
    103,60000%30.1.2013
    102,84000%31.1.2013
    102,73000%1.2.2013
    103,04000%4.2.2013
    102,34000%5.2.2013
    101,90000%6.2.2013
    101,45000%7.2.2013
    101,84000%8.2.2013
    102,20000%11.2.2013
    101,89000%12.2.2013
    101,55000%13.2.2013
    102,37000%14.2.2013
    102,42000%15.2.2013
    102,31000%18.2.2013
    101,97000%19.2.2013
    101,53000%21.2.2013
    101,00000%22.2.2013
    101,57000%25.2.2013
    99,66000%26.2.2013
    99,67000%27.2.2013
    100,17000%28.2.2013
    100,10000%4.3.2013
    99,69000%5.3.2013
    100,53000%6.3.2013
    100,93000%7.3.2013
    101,35000%8.3.2013
    101,96000%11.3.2013
    101,39000%12.3.2013
    100,40000%13.3.2013
    100,77000%14.3.2013
    100,77000%14.3.2013
    100,34000%15.3.2013
    100,25000%18.3.2013
    99,61000%19.3.2013
    99,97000%20.3.2013
    99,90000%21.3.2013
    99,53000%22.3.2013
    99,29000%25.3.2013
    99,85000%26.3.2013
    99,85000%27.3.2013
    100,37000%28.3.2013
    99,88000%2.4.2013
    99,79000%3.4.2013
    99,41000%4.4.2013
    98,38000%5.4.2013
    98,12000%8.4.2013
    98,43000%9.4.2013
    98,41000%10.4.2013
    99,12000%11.4.2013
    98,69000%12.4.2013
    98,04000%15.4.2013
    97,27000%16.4.2013
    97,22000%17.4.2013
    96,94000%18.4.2013
    97,30000%19.4.2013
    97,61000%22.4.2013
    97,24000%23.4.2013
    98,23000%24.4.2013
    98,73000%25.4.2013
    99,24000%26.4.2013
    98,66000%29.4.2013
    98,66000%30.4.2013
    98,99000%2.5.2013
    99,44000%3.5.2013
    100,05000%6.5.2013
    100,31000%7.5.2013
    100,97000%8.5.2013
    101,35000%10.5.2013
    100,83000%13.5.2013
    101,17000%15.5.2013
    101,33000%16.5.2013
    101,21000%17.5.2013
    102,34000%20.5.2013
    102,00000%21.5.2013
    100,98000%23.5.2013
    100,12000%24.5.2013
    100,07000%27.5.2013
    100,51000%28.5.2013
    100,66000%29.5.2013
    99,06000%30.5.2013
    98,47000%3.6.2013
    97,68000%5.6.2013
    96,95000%6.6.2013
    96,16000%7.6.2013
    96,51000%10.6.2013
    95,75000%11.6.2013
    96,51000%12.6.2013
    94,49000%13.6.2013
    94,91000%14.6.2013
    95,33000%17.6.2013
    94,68000%18.6.2013
    92,83000%24.6.2013
    92,03000%25.6.2013
    92,74000%26.6.2013
    93,40000%27.6.2013
    93,83000%28.6.2013
    93,86000%1.7.2013
    93,75000%2.7.2013
    93,75000%3.7.2013
    93,61000%4.7.2013
    94,18000%5.7.2013
    94,10000%8.7.2013
    94,00000%9.7.2013
    94,00000%10.7.2013
    94,30000%11.7.2013
    94,59000%12.7.2013
    94,82000%15.7.2013
    95,41000%16.7.2013
    95,48000%17.7.2013
    95,94000%18.7.2013
    95,76000%19.7.2013
    95,58000%22.7.2013
    96,05000%23.7.2013
    95,83000%24.7.2013
    95,46000%25.7.2013
    95,38000%29.7.2013
    95,35000%30.7.2013
    95,13000%31.7.2013
    95,16000%1.8.2013
    95,48000%2.8.2013
    95,52000%5.8.2013
    94,55000%7.8.2013
    95,50000%12.8.2013
    95,39000%16.8.2013
    95,39000%19.8.2013
    94,76000%20.8.2013
    94,53000%21.8.2013
    94,49000%22.8.2013
    94,62000%23.8.2013
    94,72000%26.8.2013
    94,91000%27.8.2013
    94,53000%28.8.2013
    94,85000%29.8.2013
    94,95000%30.8.2013
    95,31000%2.9.2013
    95,52000%3.9.2013
    95,76000%5.9.2013
    96,09000%6.9.2013
    96,64000%9.9.2013
    97,21000%10.9.2013
    97,44000%12.9.2013
    97,41000%13.9.2013
    97,55000%16.9.2013
    98,01000%17.9.2013
    97,95000%18.9.2013
    98,11000%19.9.2013
    98,52000%20.9.2013
    97,92000%23.9.2013
    97,98000%24.9.2013
    98,27000%25.9.2013
    97,97000%26.9.2013
    98,01000%27.9.2013
    97,63000%30.9.2013
    97,08000%1.10.2013
    97,73000%2.10.2013
    97,71000%3.10.2013
    97,55000%4.10.2013
    97,48000%7.10.2013
    97,94000%8.10.2013
    97,58000%9.10.2013
    97,56000%10.10.2013
    98,36000%11.10.2013
    98,71000%16.10.2013
    98,55000%17.10.2013
    98,43000%18.10.2013
    99,06000%21.10.2013
    98,83000%22.10.2013
    98,40000%23.10.2013
    97,26000%25.10.2013
    97,36000%28.10.2013
    97,69000%29.10.2013
    98,40000%30.10.2013
    98,59000%31.10.2013
    99,02000%4.11.2013
    99,00000%5.11.2013
    98,21000%6.11.2013
    98,38000%11.11.2013
    98,05000%12.11.2013
    97,26000%13.11.2013
    97,51000%14.11.2013
    98,40000%15.11.2013
    99,36000%18.11.2013
    99,43000%20.11.2013
    99,39000%21.11.2013
    99,12000%22.11.2013
    99,14000%25.11.2013
    98,72000%26.11.2013
    98,70000%27.11.2013
    98,54000%28.11.2013
    98,54000%29.11.2013
    99,02000%2.12.2013
    99,02000%3.12.2013
    98,04000%4.12.2013
    97,89000%5.12.2013
    97,87000%9.12.2013
    97,90000%10.12.2013
    97,84000%11.12.2013
    97,10000%12.12.2013
    97,76000%13.12.2013
    97,60000%16.12.2013
    97,56000%17.12.2013
    97,65000%18.12.2013
    97,92000%19.12.2013
    97,86000%20.12.2013
    97,64000%23.12.2013
    97,42000%27.12.2013
    97,79000%31.12.2013
    98,08000%2.1.2014
    97,48000%3.1.2014
    97,09000%7.1.2014
    97,36000%8.1.2014
    97,11000%9.1.2014
    96,70000%10.1.2014
    96,98000%13.1.2014
    96,88000%14.1.2014
    97,07000%15.1.2014
    97,08000%16.1.2014
    97,01000%17.1.2014
    96,94000%20.1.2014
    97,15000%21.1.2014
    97,29000%22.1.2014
    96,91000%23.1.2014
    96,16000%24.1.2014
    95,76000%27.1.2014
    95,82000%28.1.2014
    96,01000%29.1.2014
    95,92000%30.1.2014
    96,16000%31.1.2014
    96,29000%3.2.2014
    95,53000%4.2.2014
    95,81000%5.2.2014
    95,88000%6.2.2014
    96,06000%7.2.2014
    96,12000%10.2.2014
    96,20000%11.2.2014
    96,59000%12.2.2014
    96,49000%13.2.2014
    96,49000%14.2.2014
    96,81000%17.2.2014
    96,75000%18.2.2014
    96,64000%19.2.2014
    96,47000%20.2.2014
    96,65000%21.2.2014
    96,52000%24.2.2014
    96,41000%25.2.2014
    96,45000%26.2.2014
    96,86000%27.2.2014
    96,89000%28.2.2014
    95,64000%3.3.2014
    95,99000%4.3.2014
    96,20000%5.3.2014
    96,38000%6.3.2014
    96,10000%7.3.2014
    95,45000%10.3.2014
    95,50000%11.3.2014
    95,24000%12.3.2014
    95,13000%13.3.2014
    94,94000%14.3.2014
    94,99000%17.3.2014
    95,12000%18.3.2014
    95,21000%19.3.2014
    95,09000%20.3.2014
    95,08000%21.3.2014
    95,38000%24.3.2014
    95,34000%25.3.2014
    95,66000%26.3.2014
    95,74000%27.3.2014
    96,17000%28.3.2014
    96,14000%31.3.2014
    96,31000%1.4.2014
    96,33000%2.4.2014
    96,45000%3.4.2014
    96,40000%4.4.2014
    96,43000%7.4.2014
    96,71000%8.4.2014
    96,38000%11.4.2014
    96,52000%14.4.2014
    96,45000%15.4.2014
    96,13000%16.4.2014
    96,35000%17.4.2014
    96,52000%22.4.2014
    96,26000%23.4.2014
    96,17000%24.4.2014
    95,92000%25.4.2014
    95,76000%28.4.2014
    95,80000%29.4.2014
    95,92000%30.4.2014
    95,90000%2.5.2014
    95,94000%5.5.2014
    96,00000%6.5.2014
    96,11000%8.5.2014
    96,91000%12.5.2014
    97,18000%13.5.2014
    97,50000%14.5.2014
    97,86000%16.5.2014
    97,77000%19.5.2014
    97,89000%20.5.2014
    97,97000%21.5.2014
    98,33000%22.5.2014
    98,39000%23.5.2014
    98,44000%26.5.2014
    98,25000%27.5.2014
    98,29000%28.5.2014
    98,36000%30.5.2014
    98,04000%2.6.2014
    98,34000%3.6.2014
    98,21000%4.6.2014
    98,20000%5.6.2014
    98,22000%6.6.2014
    98,74000%9.6.2014
    99,22000%10.6.2014
    99,61000%11.6.2014
    99,49000%13.6.2014
    99,53000%16.6.2014
    99,35000%17.6.2014
    99,21000%18.6.2014
    99,28000%19.6.2014
    99,02000%23.6.2014
    99,08000%26.6.2014
    99,19000%27.6.2014
    98,99000%30.6.2014
    98,94000%1.7.2014
    99,29000%2.7.2014
    99,40000%3.7.2014
    99,55000%4.7.2014
    99,59000%7.7.2014
    99,65000%8.7.2014
    99,17000%9.7.2014
    99,37000%10.7.2014
    99,29000%11.7.2014
    99,35000%14.7.2014
    99,30000%15.7.2014
    99,70000%16.7.2014
    99,58000%17.7.2014
    99,08000%18.7.2014
    99,51000%21.7.2014
    99,90000%22.7.2014
    100,40000%23.7.2014
    100,58000%24.7.2014
    100,72000%25.7.2014
    101,08000%28.7.2014
    101,12000%29.7.2014
    101,11000%30.7.2014
    101,04000%31.7.2014
    100,37000%1.8.2014
    100,54000%4.8.2014
    100,52000%5.8.2014
    100,32000%6.8.2014
    100,04000%7.8.2014
    99,96000%8.8.2014
    100,39000%11.8.2014
    100,77000%12.8.2014
    100,81000%13.8.2014
    100,92000%14.8.2014
    101,34000%15.8.2014
    101,47000%18.8.2014
    101,96000%19.8.2014
    102,28000%20.8.2014
    102,38000%21.8.2014
    102,45000%22.8.2014
    102,70000%25.8.2014
    102,97000%26.8.2014
    103,04000%27.8.2014
    102,75000%28.8.2014
    102,63000%29.8.2014
    102,73000%1.9.2014
    102,71000%2.9.2014
    103,72000%3.9.2014
    104,44000%4.9.2014
    104,98000%5.9.2014
    105,21000%8.9.2014
    105,12000%9.9.2014
    103,87000%10.9.2014
    103,56000%11.9.2014
    103,49000%12.9.2014
    102,55000%15.9.2014
    102,18000%16.9.2014
    102,70000%18.9.2014
    102,84000%19.9.2014
    102,10000%22.9.2014
    102,10000%23.9.2014
    101,84000%24.9.2014
    102,37000%25.9.2014
    101,56000%26.9.2014
    101,78000%29.9.2014
    100,77000%30.9.2014
    100,83000%1.10.2014
    100,32000%2.10.2014
    100,54000%3.10.2014
    101,32000%6.10.2014
    101,79000%7.10.2014
    101,47000%8.10.2014
    101,35000%9.10.2014
    101,02000%10.10.2014
    100,52000%13.10.2014
    100,95000%14.10.2014
    101,19000%15.10.2014
    100,11000%16.10.2014
    99,76000%17.10.2014
    100,45000%20.10.2014
    99,81000%21.10.2014
    100,33000%22.10.2014
    100,28000%23.10.2014
    99,88000%24.10.2014
    100,15000%27.10.2014
    100,00000%28.10.2014
    100,74000%29.10.2014
    101,12000%30.10.2014
    102,37000%31.10.2014
    102,78000%3.11.2014
    102,46000%4.11.2014
    102,23000%5.11.2014
    102,19000%6.11.2014
    101,65000%7.11.2014
    101,95000%10.11.2014
    102,36000%11.11.2014
    102,03000%12.11.2014
    102,28000%13.11.2014
    101,77000%14.11.2014
    101,19000%17.11.2014
    100,93000%18.11.2014
    100,78000%19.11.2014
    101,07000%20.11.2014
    101,34000%21.11.2014
    103,49000%24.11.2014
    103,08000%25.11.2014
    102,91000%26.11.2014
    102,74000%27.11.2014
    102,78000%28.11.2014
    101,32000%1.12.2014
    101,36000%2.12.2014
    101,36000%2.12.2014
    100,96000%3.12.2014
    102,21000%4.12.2014
    101,74000%5.12.2014
    102,28000%8.12.2014
    100,11000%9.12.2014
    100,21000%10.12.2014
    99,44000%11.12.2014
    99,25000%12.12.2014
    98,72000%15.12.2014
    97,84000%16.12.2014
    97,85000%17.12.2014
    98,87000%18.12.2014
    99,62000%19.12.2014
    100,36000%22.12.2014
    100,49000%23.12.2014
    100,88000%29.12.2014
    100,40000%30.12.2014
    100,76000%31.12.2014
    101,27000%2.1.2015
    101,21000%5.1.2015
    101,36000%7.1.2015
    102,14000%8.1.2015
    102,03000%9.1.2015
    102,83000%12.1.2015
    102,15000%13.1.2015
    102,24000%14.1.2015
    102,80000%15.1.2015
    102,94000%16.1.2015
    102,99000%19.1.2015
    103,27000%20.1.2015
    103,90000%21.1.2015
    104,58000%22.1.2015
    106,66000%23.1.2015
    106,16000%27.1.2015
    105,86000%28.1.2015
    104,94000%29.1.2015
    104,23000%30.1.2015
    103,66000%2.2.2015
    104,23000%3.2.2015
    104,19000%4.2.2015
    104,19000%5.2.2015
    104,35000%6.2.2015
    104,36000%9.2.2015
    104,60000%10.2.2015
    104,29000%11.2.2015
    104,30000%12.2.2015
    104,74000%13.2.2015
    105,29000%16.2.2015
    105,57000%17.2.2015
    105,54000%18.2.2015
    105,33000%19.2.2015
    105,64000%20.2.2015
    105,51000%23.2.2015
    105,41000%24.2.2015
    104,81000%25.2.2015
    105,09000%26.2.2015
    105,71000%27.2.2015
    106,05000%2.3.2015
    105,20000%3.3.2015
    104,85000%4.3.2015
    104,80000%5.3.2015
    105,04000%6.3.2015
    105,37000%9.3.2015
    104,81000%10.3.2015
    104,82000%11.3.2015
    105,39000%12.3.2015
    105,62000%13.3.2015
    106,52000%16.3.2015
    106,99000%17.3.2015
    108,01000%18.3.2015
    108,91000%19.3.2015
    108,80000%20.3.2015
    108,72000%23.3.2015
    107,61000%24.3.2015
    107,86000%25.3.2015
    107,06000%26.3.2015
    107,57000%27.3.2015
    108,16000%30.3.2015
    108,96000%31.3.2015
    109,33000%1.4.2015
    109,89000%2.4.2015
    109,83000%7.4.2015
    111,43000%8.4.2015
    114,16000%9.4.2015
    115,55000%10.4.2015
    117,17000%13.4.2015
    116,61000%14.4.2015
    116,62000%15.4.2015
    117,35000%16.4.2015
    114,31000%20.4.2015
    116,20000%21.4.2015
    116,43000%22.4.2015
    116,95000%23.4.2015
    115,81000%24.4.2015
    116,87000%27.4.2015
    116,41000%28.4.2015
    115,82000%29.4.2015
    114,16000%30.4.2015
    113,61000%4.5.2015
    113,03000%5.5.2015
    112,33000%6.5.2015
    110,57000%7.5.2015
    112,15000%8.5.2015
    112,99000%11.5.2015
    112,44000%12.5.2015
    111,64000%13.5.2015
    111,35000%15.5.2015
    111,24000%18.5.2015
    112,41000%19.5.2015
    112,69000%20.5.2015
    112,22000%21.5.2015
    112,98000%22.5.2015
    113,61000%25.5.2015
    115,07000%26.5.2015
    113,97000%27.5.2015
    112,51000%28.5.2015
    112,44000%29.5.2015
    112,40000%1.6.2015
    112,06000%2.6.2015
    111,43000%3.6.2015
    110,65000%4.6.2015
    109,67000%5.6.2015
    110,82000%8.6.2015
    108,87000%10.6.2015
    109,49000%11.6.2015
    109,96000%12.6.2015
    109,40000%15.6.2015
    108,44000%16.6.2015
    109,35000%17.6.2015
    108,72000%18.6.2015
    109,35000%22.6.2015
    110,39000%23.6.2015
    110,64000%24.6.2015
    110,40000%25.6.2015
    109,67000%26.6.2015
    109,11000%29.6.2015
    108,62000%30.6.2015
    108,89000%1.7.2015
    109,03000%2.7.2015
    108,82000%3.7.2015
    107,83000%6.7.2015
    107,04000%7.7.2015
    104,81000%8.7.2015
    105,69000%9.7.2015
    106,34000%10.7.2015
    106,69000%13.7.2015
    107,54000%14.7.2015
    107,25000%15.7.2015
    107,52000%16.7.2015
    108,31000%17.7.2015
    108,37000%20.7.2015
    108,49000%21.7.2015
    107,75000%22.7.2015
    107,73000%23.7.2015
    107,02000%24.7.2015
    105,61000%27.7.2015
    105,22000%28.7.2015
    105,17000%29.7.2015
    105,15000%30.7.2015
    105,06000%31.7.2015
    104,74000%3.8.2015
    104,70000%4.8.2015
    105,15000%5.8.2015
    104,92000%6.8.2015
    105,01000%7.8.2015
    104,69000%10.8.2015
    105,11000%11.8.2015
    103,37000%12.8.2015
    103,69000%13.8.2015
    103,33000%14.8.2015
    103,49000%17.8.2015
    103,18000%18.8.2015
    102,96000%19.8.2015
    102,03000%20.8.2015
    101,10000%21.8.2015
    99,44000%24.8.2015
    98,90000%25.8.2015
    99,31000%26.8.2015
    99,87000%27.8.2015
    100,47000%28.8.2015
    100,45000%31.8.2015
    100,02000%1.9.2015
    99,17000%2.9.2015
    99,52000%3.9.2015
    99,71000%4.9.2015
    99,37000%7.9.2015
    99,48000%8.9.2015
    100,21000%9.9.2015
    99,87000%10.9.2015
    99,61000%11.9.2015
    99,37000%14.9.2015
    99,72000%15.9.2015
    100,22000%16.9.2015
    100,28000%17.9.2015
    99,96000%18.9.2015
    99,77000%21.9.2015
    100,17000%22.9.2015
    99,54000%23.9.2015
    99,11000%24.9.2015
    99,42000%25.9.2015
    99,41000%28.9.2015
    98,55000%29.9.2015
    99,11000%30.9.2015
    99,38000%1.10.2015
    99,67000%2.10.2015
    100,03000%5.10.2015
    100,30000%6.10.2015
    100,82000%7.10.2015
    101,09000%8.10.2015
    101,46000%9.10.2015
    101,54000%12.10.2015
    101,16000%13.10.2015
    100,60000%14.10.2015
    100,92000%15.10.2015
    101,48000%16.10.2015
    101,50000%19.10.2015
    101,47000%20.10.2015
    101,31000%21.10.2015
    100,94000%22.10.2015
    102,23000%23.10.2015
    102,59000%26.10.2015
    102,55000%27.10.2015
    102,38000%28.10.2015
    102,84000%29.10.2015
    102,24000%30.10.2015
    102,19000%2.11.2015
    102,62000%3.11.2015
    103,72000%4.11.2015
    104,01000%5.11.2015
    103,67000%6.11.2015
    103,58000%9.11.2015
    103,00000%10.11.2015
    103,00000%11.11.2015
    103,65000%12.11.2015
    102,74000%13.11.2015
    102,17000%16.11.2015
    103,18000%17.11.2015
    103,12000%18.11.2015
    103,73000%19.11.2015
    104,14000%20.11.2015
    104,39000%23.11.2015
    104,29000%24.11.2015
    104,00000%25.11.2015
    104,02000%26.11.2015
    103,34000%27.11.2015
    103,40000%30.11.2015
    103,81000%1.12.2015
    103,69000%2.12.2015
    103,73000%3.12.2015
    102,29000%4.12.2015
    102,19000%7.12.2015
    101,71000%8.12.2015
    101,09000%10.12.2015
    100,89000%11.12.2015
    100,12000%14.12.2015
    100,00000%15.12.2015
    100,86000%16.12.2015
    101,32000%17.12.2015
    101,06000%18.12.2015
    100,73000%21.12.2015
    100,71000%22.12.2015
    101,16000%23.12.2015
    101,05000%28.12.2015
    100,89000%29.12.2015
    100,93000%30.12.2015
    100,82000%31.12.2015
    100,41000%4.1.2016
    100,12000%5.1.2016
    99,69000%7.1.2016
    99,33000%8.1.2016
    99,05000%11.1.2016
    98,83000%12.1.2016
    99,16000%13.1.2016
    98,90000%14.1.2016
    98,60000%15.1.2016
    98,18000%18.1.2016
    98,44000%19.1.2016
    98,94000%21.1.2016
    99,39000%22.1.2016
    99,63000%25.1.2016
    99,30000%26.1.2016
    99,41000%27.1.2016
    99,47000%28.1.2016
    99,64000%29.1.2016
    99,79000%1.2.2016
    99,54000%2.2.2016
    99,16000%3.2.2016
    99,14000%4.2.2016
    99,18000%5.2.2016
    99,12000%8.2.2016
    98,78000%10.2.2016
    98,63000%11.2.2016
    98,42000%12.2.2016
    98,75000%15.2.2016
    98,87000%16.2.2016
    98,93000%17.2.2016
    99,19000%19.2.2016
    99,32000%22.2.2016
    99,46000%23.2.2016
    99,30000%24.2.2016
    99,15000%25.2.2016
    99,26000%26.2.2016
    99,34000%29.2.2016
    99,65000%1.3.2016
    100,06000%2.3.2016
    100,13000%3.3.2016
    100,29000%4.3.2016
    100,50000%7.3.2016
    100,26000%8.3.2016
    100,19000%9.3.2016
    100,30000%10.3.2016
    100,16000%11.3.2016
    100,44000%14.3.2016
    100,36000%15.3.2016
    100,16000%16.3.2016
    100,20000%17.3.2016
    100,50000%18.3.2016
    100,67000%21.3.2016
    100,83000%22.3.2016
    100,86000%23.3.2016
    100,49000%24.3.2016
    100,40000%29.3.2016
    100,54000%30.3.2016
    100,54000%31.3.2016
    100,30000%1.4.2016
    100,32000%4.4.2016
    100,03000%5.4.2016
    99,95000%6.4.2016
    99,93000%7.4.2016
    99,97000%8.4.2016
    100,09000%11.4.2016
    100,22000%12.4.2016
    100,79000%13.4.2016
    101,37000%14.4.2016
    101,40000%15.4.2016
    101,09000%19.4.2016
    101,02000%20.4.2016
    101,50000%21.4.2016
    101,27000%22.4.2016
    100,92000%26.4.2016
    100,96000%27.4.2016
    100,91000%28.4.2016
    100,69000%29.4.2016
    100,60000%2.5.2016
    100,01000%3.5.2016
    99,76000%4.5.2016
    99,82000%6.5.2016
    99,88000%9.5.2016
    99,82000%10.5.2016
    99,94000%11.5.2016
    99,87000%12.5.2016
    99,79000%13.5.2016
    99,81000%16.5.2016
    100,00000%17.5.2016
    99,91000%18.5.2016
    99,84000%19.5.2016
    99,69000%23.5.2016
    99,63000%24.5.2016
    100,24000%25.5.2016
    100,15000%26.5.2016
    100,43000%27.5.2016
    100,77000%30.5.2016
    100,94000%31.5.2016
    100,72000%1.6.2016
    100,37000%2.6.2016
    100,58000%3.6.2016
    100,28000%6.6.2016
    100,61000%7.6.2016
    100,65000%9.6.2016
    100,56000%10.6.2016
    99,92000%13.6.2016
    99,90000%14.6.2016
    99,71000%16.6.2016
    99,91000%17.6.2016
    99,93000%20.6.2016
    100,12000%21.6.2016
    100,40000%22.6.2016
    100,22000%23.6.2016
    100,42000%27.6.2016
    100,21000%28.6.2016
    100,38000%29.6.2016
    100,68000%30.6.2016
    100,91000%1.7.2016
    101,03000%4.7.2016
    100,86000%5.7.2016
    100,72000%6.7.2016
    100,80000%7.7.2016
    100,73000%8.7.2016
    101,07000%11.7.2016
    101,26000%12.7.2016
    101,45000%13.7.2016
    101,45000%14.7.2016
    101,28000%15.7.2016
    101,41000%18.7.2016
    101,41000%19.7.2016
    101,53000%20.7.2016
    101,62000%21.7.2016
    101,51000%22.7.2016
    101,67000%25.7.2016
    101,56000%26.7.2016
    101,61000%27.7.2016
    101,44000%28.7.2016
    101,24000%29.7.2016
    101,27000%1.8.2016
    101,19000%2.8.2016
    100,93000%3.8.2016
    101,15000%4.8.2016
    101,37000%5.8.2016
    101,64000%8.8.2016
    101,73000%9.8.2016
    101,61000%10.8.2016
    101,77000%11.8.2016
    102,18000%12.8.2016
    102,44000%15.8.2016
    102,43000%16.8.2016
    102,30000%17.8.2016
    102,46000%18.8.2016
    102,36000%19.8.2016
    102,36000%22.8.2016
    102,21000%23.8.2016
    102,19000%24.8.2016
    102,16000%25.8.2016
    102,13000%26.8.2016
    102,35000%29.8.2016
    102,53000%30.8.2016
    102,57000%31.8.2016
    102,63000%1.9.2016
    102,66000%2.9.2016
    103,10000%5.9.2016
    103,29000%6.9.2016
    103,47000%7.9.2016
    103,51000%8.9.2016
    103,52000%9.9.2016
    102,73000%12.9.2016
    102,90000%13.9.2016
    102,62000%14.9.2016
    102,79000%15.9.2016
    102,86000%16.9.2016
    103,13000%19.9.2016
    103,02000%20.9.2016
    103,34000%21.9.2016
    103,49000%22.9.2016
    103,69000%23.9.2016
    103,24000%26.9.2016
    103,26000%27.9.2016
    103,42000%28.9.2016
    103,47000%29.9.2016
    103,16000%3.10.2016
    103,43000%4.10.2016
    103,38000%5.10.2016
    103,72000%6.10.2016
    103,85000%7.10.2016
    103,67000%10.10.2016
    103,74000%11.10.2016
    103,51000%12.10.2016
    103,37000%13.10.2016
    103,42000%14.10.2016
    103,33000%17.10.2016
    103,55000%18.10.2016
    103,71000%19.10.2016
    103,85000%20.10.2016
    103,99000%21.10.2016
    104,22000%24.10.2016
    104,25000%25.10.2016
    103,93000%26.10.2016
    103,59000%27.10.2016
    103,40000%28.10.2016
    103,38000%31.10.2016
    103,45000%1.11.2016
    102,74000%2.11.2016
    102,46000%3.11.2016
    102,32000%4.11.2016
    102,60000%7.11.2016
    102,71000%9.11.2016
    103,05000%10.11.2016
    102,38000%11.11.2016
    102,38000%14.11.2016
    102,23000%15.11.2016
    102,62000%16.11.2016
    102,57000%17.11.2016
    102,87000%18.11.2016
    102,79000%21.11.2016
    103,20000%22.11.2016
    103,12000%23.11.2016
    103,32000%24.11.2016
    103,34000%25.11.2016
    103,24000%28.11.2016
    103,36000%29.11.2016
    103,33000%30.11.2016
    103,53000%1.12.2016
    102,98000%5.12.2016
    102,98000%7.12.2016
    103,10000%8.12.2016
    103,45000%9.12.2016
    103,52000%12.12.2016
    103,19000%13.12.2016
    103,36000%14.12.2016
    103,25000%15.12.2016
    103,22000%16.12.2016
    102,98000%19.12.2016
    103,18000%21.12.2016
    102,88000%22.12.2016
    102,76000%23.12.2016
    102,77000%27.12.2016
    102,91000%28.12.2016
    102,97000%29.12.2016
    103,01000%30.12.2016
    102,95000%2.1.2017
    103,09000%3.1.2017
    103,25000%5.1.2017
    103,36000%9.1.2017
    103,57000%11.1.2017
    103,50000%12.1.2017
    103,52000%13.1.2017
    103,41000%16.1.2017
    103,44000%18.1.2017
    103,41000%19.1.2017
    103,33000%20.1.2017
    103,22000%23.1.2017
    103,37000%24.1.2017
    103,37000%25.1.2017
    103,66000%26.1.2017
    103,66000%27.1.2017
    103,66000%30.1.2017
    103,55000%31.1.2017
    103,44000%1.2.2017
    103,42000%2.2.2017
    103,44000%3.2.2017
    103,60000%6.2.2017
    103,75000%8.2.2017
    103,83000%9.2.2017
    104,07000%14.2.2017
    104,30000%15.2.2017
    104,35000%16.2.2017
    104,29000%20.2.2017
    104,31000%21.2.2017
    104,64000%22.2.2017
    104,57000%23.2.2017
    104,39000%24.2.2017
    104,28000%27.2.2017
    104,19000%28.2.2017
    104,24000%2.3.2017
    104,09000%3.3.2017
    104,06000%6.3.2017
    104,06000%7.3.2017
    104,12000%8.3.2017
    103,96000%9.3.2017
    103,85000%10.3.2017
    103,90000%13.3.2017
    104,09000%14.3.2017
    104,01000%15.3.2017
    104,16000%16.3.2017
    104,17000%17.3.2017
    104,22000%20.3.2017
    104,32000%21.3.2017
    103,99000%22.3.2017
    104,02000%23.3.2017
    104,07000%24.3.2017
    103,91000%27.3.2017
    103,99000%28.3.2017
    103,99000%30.3.2017
    104,29000%3.4.2017
    104,33000%5.4.2017
    104,30000%6.4.2017
    104,25000%7.4.2017
    104,33000%10.4.2017
    104,30000%11.4.2017
    104,23000%12.4.2017
    104,22000%13.4.2017
    104,21000%18.4.2017
    103,99000%19.4.2017
    103,98000%20.4.2017
    104,11000%21.4.2017
    104,00000%24.4.2017
    104,17000%25.4.2017
    104,20000%26.4.2017
    104,18000%27.4.2017
    104,23000%28.4.2017
    104,22000%2.5.2017
    104,28000%3.5.2017
    104,17000%4.5.2017
    103,91000%5.5.2017
    104,03000%8.5.2017
    104,28000%9.5.2017
    104,62000%11.5.2017
    104,70000%12.5.2017
    104,76000%15.5.2017
    104,66000%17.5.2017
    104,41000%18.5.2017
    104,16000%19.5.2017
    104,16000%22.5.2017
    104,28000%23.5.2017
    104,32000%24.5.2017
    104,40000%26.5.2017
    104,49000%29.5.2017
    104,55000%30.5.2017
    104,44000%31.5.2017
    104,27000%1.6.2017
    104,29000%2.6.2017
    104,27000%6.6.2017
    104,27000%7.6.2017
    104,37000%8.6.2017
    104,38000%12.6.2017
    104,37000%13.6.2017
    104,35000%14.6.2017
    104,26000%15.6.2017
    104,24000%16.6.2017
    104,28000%19.6.2017
    104,28000%20.6.2017
    104,36000%21.6.2017
    104,36000%22.6.2017
    104,38000%26.6.2017
    106,30000%27.6.2017
    106,59000%6.7.2017