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
    100,00000%26.5.2014
    93,55000%3.9.2014
    93,71000%4.9.2014
    94,07000%5.9.2014
    93,97000%8.9.2014
    93,95000%9.9.2014
    93,65000%10.9.2014
    93,70000%11.9.2014
    93,27000%12.9.2014
    92,53000%15.9.2014
    92,66000%16.9.2014
    92,90000%18.9.2014
    93,62000%19.9.2014
    92,38000%22.9.2014
    92,38000%23.9.2014
    91,25000%24.9.2014
    91,51000%25.9.2014
    90,86000%26.9.2014
    91,01000%29.9.2014
    90,47000%30.9.2014
    90,93000%1.10.2014
    89,64000%2.10.2014
    88,75000%3.10.2014
    88,76000%6.10.2014
    88,46000%7.10.2014
    87,73000%8.10.2014
    87,94000%9.10.2014
    87,24000%10.10.2014
    86,14000%13.10.2014
    86,16000%14.10.2014
    86,52000%15.10.2014
    85,65000%16.10.2014
    85,41000%17.10.2014
    86,03000%20.10.2014
    85,50000%21.10.2014
    86,67000%22.10.2014
    85,71000%23.10.2014
    86,26000%24.10.2014
    86,37000%27.10.2014
    86,30000%28.10.2014
    86,72000%29.10.2014
    87,04000%30.10.2014
    87,50000%31.10.2014
    87,59000%3.11.2014
    87,15000%4.11.2014
    87,21000%5.11.2014
    87,66000%6.11.2014
    88,43000%7.11.2014
    87,68000%10.11.2014
    88,07000%11.11.2014
    88,18000%12.11.2014
    87,64000%13.11.2014
    87,61000%14.11.2014
    87,17000%17.11.2014
    87,76000%18.11.2014
    87,95000%19.11.2014
    87,94000%20.11.2014
    88,12000%21.11.2014
    89,02000%24.11.2014
    88,74000%25.11.2014
    88,37000%26.11.2014
    88,20000%27.11.2014
    87,64000%28.11.2014
    87,43000%1.12.2014
    87,80000%2.12.2014
    87,80000%2.12.2014
    88,39000%3.12.2014
    88,45000%4.12.2014
    87,82000%5.12.2014
    88,15000%8.12.2014
    86,35000%9.12.2014
    86,38000%10.12.2014
    86,03000%11.12.2014
    85,87000%12.12.2014
    84,77000%15.12.2014
    83,97000%16.12.2014
    84,12000%17.12.2014
    85,30000%18.12.2014
    85,93000%19.12.2014
    86,29000%22.12.2014
    86,04000%23.12.2014
    86,20000%29.12.2014
    85,92000%30.12.2014
    85,81000%31.12.2014
    86,05000%2.1.2015
    85,32000%5.1.2015
    84,14000%7.1.2015
    84,86000%8.1.2015
    86,47000%9.1.2015
    85,22000%12.1.2015
    85,53000%13.1.2015
    85,85000%14.1.2015
    86,43000%15.1.2015
    86,54000%16.1.2015
    87,59000%19.1.2015
    88,12000%20.1.2015
    88,34000%21.1.2015
    88,69000%22.1.2015
    89,81000%23.1.2015
    90,69000%27.1.2015
    90,60000%28.1.2015
    89,28000%29.1.2015
    90,02000%30.1.2015
    89,88000%2.2.2015
    90,87000%3.2.2015
    91,28000%4.2.2015
    91,28000%5.2.2015
    91,05000%6.2.2015
    90,42000%9.2.2015
    90,47000%10.2.2015
    90,58000%11.2.2015
    90,57000%12.2.2015
    91,57000%13.2.2015
    91,69000%16.2.2015
    91,20000%17.2.2015
    92,25000%18.2.2015
    92,02000%19.2.2015
    92,24000%20.2.2015
    93,11000%23.2.2015
    92,87000%24.2.2015
    93,59000%25.2.2015
    93,83000%26.2.2015
    94,44000%27.2.2015
    94,27000%2.3.2015
    94,32000%3.3.2015
    94,07000%4.3.2015
    94,32000%5.3.2015
    94,63000%6.3.2015
    94,39000%9.3.2015
    94,34000%10.3.2015
    92,94000%11.3.2015
    93,63000%12.3.2015
    93,20000%13.3.2015
    93,14000%16.3.2015
    94,06000%17.3.2015
    93,60000%18.3.2015
    94,32000%19.3.2015
    94,45000%20.3.2015
    94,60000%23.3.2015
    94,46000%24.3.2015
    94,55000%25.3.2015
    93,65000%26.3.2015
    93,86000%27.3.2015
    93,93000%30.3.2015
    94,51000%31.3.2015
    93,71000%1.4.2015
    94,27000%2.4.2015
    94,66000%7.4.2015
    95,90000%8.4.2015
    95,61000%9.4.2015
    96,60000%10.4.2015
    96,93000%13.4.2015
    96,75000%14.4.2015
    96,64000%15.4.2015
    97,38000%16.4.2015
    95,76000%20.4.2015
    96,68000%21.4.2015
    97,09000%22.4.2015
    96,50000%23.4.2015
    96,47000%24.4.2015
    95,91000%27.4.2015
    97,47000%28.4.2015
    96,83000%29.4.2015
    95,03000%30.4.2015
    95,31000%4.5.2015
    95,37000%5.5.2015
    94,83000%6.5.2015
    93,67000%7.5.2015
    94,06000%8.5.2015
    95,44000%11.5.2015
    94,98000%12.5.2015
    94,33000%13.5.2015
    94,59000%15.5.2015
    93,96000%18.5.2015
    94,89000%19.5.2015
    94,75000%20.5.2015
    94,98000%21.5.2015
    95,36000%22.5.2015
    95,08000%25.5.2015
    95,02000%26.5.2015
    94,30000%27.5.2015
    94,40000%28.5.2015
    94,57000%29.5.2015
    93,44000%1.6.2015
    93,05000%2.6.2015
    92,33000%3.6.2015
    92,03000%4.6.2015
    91,30000%5.6.2015
    90,75000%8.6.2015
    90,03000%10.6.2015
    91,82000%11.6.2015
    92,05000%12.6.2015
    90,92000%15.6.2015
    90,21000%16.6.2015
    90,77000%17.6.2015
    89,98000%18.6.2015
    91,66000%22.6.2015
    92,37000%23.6.2015
    92,90000%24.6.2015
    92,42000%25.6.2015
    92,53000%26.6.2015
    90,54000%29.6.2015
    90,52000%30.6.2015
    90,23000%1.7.2015
    90,73000%2.7.2015
    90,54000%3.7.2015
    89,54000%6.7.2015
    89,70000%7.7.2015
    88,94000%8.7.2015
    89,10000%9.7.2015
    91,25000%10.7.2015
    92,15000%13.7.2015
    92,24000%14.7.2015
    92,52000%15.7.2015
    93,09000%16.7.2015
    93,50000%17.7.2015
    93,32000%20.7.2015
    93,50000%21.7.2015
    93,01000%22.7.2015
    92,78000%23.7.2015
    92,37000%24.7.2015
    91,65000%27.7.2015
    90,71000%28.7.2015
    91,41000%29.7.2015
    91,63000%30.7.2015
    91,57000%31.7.2015
    91,51000%3.8.2015
    91,51000%4.8.2015
    91,79000%5.8.2015
    91,79000%6.8.2015
    91,99000%7.8.2015
    91,87000%10.8.2015
    91,78000%11.8.2015
    89,52000%12.8.2015
    89,92000%13.8.2015
    89,31000%14.8.2015
    89,51000%17.8.2015
    89,00000%18.8.2015
    88,49000%19.8.2015
    87,35000%20.8.2015
    86,27000%21.8.2015
    83,93000%24.8.2015
    83,63000%25.8.2015
    83,55000%26.8.2015
    84,88000%27.8.2015
    85,75000%28.8.2015
    85,46000%31.8.2015
    85,03000%1.9.2015
    84,44000%2.9.2015
    84,71000%3.9.2015
    84,66000%4.9.2015
    84,64000%7.9.2015
    84,70000%8.9.2015
    85,58000%9.9.2015
    84,80000%10.9.2015
    84,56000%11.9.2015
    84,05000%14.9.2015
    84,12000%15.9.2015
    84,71000%16.9.2015
    84,75000%17.9.2015
    84,16000%18.9.2015
    83,59000%21.9.2015
    83,85000%22.9.2015
    82,69000%23.9.2015
    82,80000%24.9.2015
    82,92000%25.9.2015
    82,82000%28.9.2015
    81,94000%29.9.2015
    83,86000%30.9.2015
    84,68000%1.10.2015
    84,49000%2.10.2015
    85,18000%5.10.2015
    85,82000%6.10.2015
    86,82000%7.10.2015
    86,87000%8.10.2015
    87,77000%9.10.2015
    87,61000%12.10.2015
    87,14000%13.10.2015
    86,36000%14.10.2015
    86,86000%15.10.2015
    87,07000%16.10.2015
    87,35000%19.10.2015
    86,91000%20.10.2015
    86,49000%21.10.2015
    87,05000%22.10.2015
    88,65000%23.10.2015
    88,79000%26.10.2015
    88,81000%27.10.2015
    88,50000%28.10.2015
    89,10000%29.10.2015
    89,23000%30.10.2015
    88,57000%2.11.2015
    89,18000%3.11.2015
    89,90000%4.11.2015
    90,00000%5.11.2015
    90,23000%6.11.2015
    90,30000%9.11.2015
    89,57000%10.11.2015
    89,56000%11.11.2015
    88,37000%12.11.2015
    87,56000%13.11.2015
    87,24000%16.11.2015
    88,75000%17.11.2015
    88,56000%18.11.2015
    89,80000%19.11.2015
    89,86000%20.11.2015
    89,71000%23.11.2015
    89,32000%24.11.2015
    89,40000%25.11.2015
    90,22000%26.11.2015
    90,80000%27.11.2015
    90,57000%30.11.2015
    91,32000%1.12.2015
    90,64000%2.12.2015
    90,27000%3.12.2015
    88,23000%4.12.2015
    87,90000%7.12.2015
    87,64000%8.12.2015
    86,70000%10.12.2015
    86,52000%11.12.2015
    85,88000%14.12.2015
    85,84000%15.12.2015
    86,62000%16.12.2015
    87,49000%17.12.2015
    86,86000%18.12.2015
    86,35000%21.12.2015
    86,58000%22.12.2015
    87,05000%23.12.2015
    87,82000%28.12.2015
    87,71000%29.12.2015
    87,70000%30.12.2015
    87,26000%31.12.2015
    86,26000%4.1.2016
    86,48000%5.1.2016
    83,99000%7.1.2016
    84,55000%8.1.2016
    84,02000%11.1.2016
    84,10000%12.1.2016
    85,03000%13.1.2016
    84,29000%14.1.2016
    84,83000%15.1.2016
    84,11000%18.1.2016
    84,64000%19.1.2016
    83,14000%21.1.2016
    84,39000%22.1.2016
    84,60000%25.1.2016
    83,65000%26.1.2016
    84,53000%27.1.2016
    84,99000%28.1.2016
    85,57000%29.1.2016
    85,90000%1.2.2016
    85,35000%2.2.2016
    84,77000%3.2.2016
    84,72000%4.2.2016
    84,78000%5.2.2016
    84,71000%8.2.2016
    83,35000%10.2.2016
    82,93000%11.2.2016
    83,15000%12.2.2016
    84,04000%15.2.2016
    84,72000%16.2.2016
    84,53000%17.2.2016
    85,49000%19.2.2016
    85,66000%22.2.2016
    85,67000%23.2.2016
    85,11000%24.2.2016
    84,86000%25.2.2016
    85,73000%26.2.2016
    85,62000%29.2.2016
    86,15000%1.3.2016
    87,25000%2.3.2016
    87,14000%3.3.2016
    87,80000%4.3.2016
    87,79000%7.3.2016
    87,51000%8.3.2016
    87,55000%9.3.2016
    87,44000%10.3.2016
    87,24000%11.3.2016
    88,11000%14.3.2016
    87,79000%15.3.2016
    88,14000%16.3.2016
    88,73000%17.3.2016
    88,38000%18.3.2016
    87,79000%21.3.2016
    87,88000%22.3.2016
    88,47000%23.3.2016
    87,71000%24.3.2016
    87,76000%29.3.2016
    87,94000%30.3.2016
    87,69000%31.3.2016
    86,59000%1.4.2016
    86,31000%4.4.2016
    85,88000%5.4.2016
    85,99000%6.4.2016
    86,07000%7.4.2016
    86,35000%8.4.2016
    86,49000%11.4.2016
    86,80000%12.4.2016
    87,67000%13.4.2016
    87,87000%14.4.2016
    87,84000%15.4.2016
    88,29000%19.4.2016
    88,80000%20.4.2016
    89,49000%21.4.2016
    88,97000%22.4.2016
    88,71000%26.4.2016
    88,83000%27.4.2016
    88,59000%28.4.2016
    88,33000%29.4.2016
    87,85000%2.5.2016
    87,38000%3.5.2016
    86,56000%4.5.2016
    86,18000%6.5.2016
    86,52000%9.5.2016
    86,72000%10.5.2016
    86,77000%11.5.2016
    86,52000%12.5.2016
    86,17000%13.5.2016
    86,70000%16.5.2016
    87,40000%17.5.2016
    86,81000%18.5.2016
    86,56000%19.5.2016
    86,64000%23.5.2016
    86,59000%24.5.2016
    87,98000%25.5.2016
    88,53000%26.5.2016
    88,69000%27.5.2016
    88,87000%30.5.2016
    88,96000%31.5.2016
    88,27000%1.6.2016
    88,03000%2.6.2016
    88,18000%3.6.2016
    87,49000%6.6.2016
    88,12000%7.6.2016
    87,80000%9.6.2016
    87,17000%10.6.2016
    86,07000%13.6.2016
    85,51000%14.6.2016
    85,08000%16.6.2016
    85,68000%17.6.2016
    86,77000%20.6.2016
    87,45000%21.6.2016
    88,10000%22.6.2016
    88,12000%23.6.2016
    85,72000%27.6.2016
    85,67000%28.6.2016
    86,26000%29.6.2016
    86,68000%30.6.2016
    87,70000%1.7.2016
    88,39000%4.7.2016
    87,44000%5.7.2016
    86,82000%6.7.2016
    87,03000%7.7.2016
    86,77000%8.7.2016
    87,86000%11.7.2016
    87,95000%12.7.2016
    88,28000%13.7.2016
    88,70000%14.7.2016
    88,34000%15.7.2016
    88,47000%18.7.2016
    88,47000%19.7.2016
    88,02000%20.7.2016
    88,28000%21.7.2016
    87,83000%22.7.2016
    87,99000%25.7.2016
    87,94000%26.7.2016
    88,04000%27.7.2016
    88,04000%28.7.2016
    87,92000%29.7.2016
    88,18000%1.8.2016
    87,41000%2.8.2016
    87,32000%3.8.2016
    87,58000%4.8.2016
    88,16000%5.8.2016
    88,51000%8.8.2016
    88,44000%9.8.2016
    88,92000%10.8.2016
    89,09000%11.8.2016
    89,63000%12.8.2016
    89,45000%15.8.2016
    89,09000%16.8.2016
    89,10000%17.8.2016
    88,98000%18.8.2016
    89,25000%19.8.2016
    88,72000%22.8.2016
    88,77000%23.8.2016
    88,74000%24.8.2016
    88,63000%25.8.2016
    88,61000%26.8.2016
    88,95000%29.8.2016
    89,13000%30.8.2016
    89,25000%31.8.2016
    89,31000%1.9.2016
    89,04000%2.9.2016
    90,21000%5.9.2016
    90,13000%6.9.2016
    90,06000%7.9.2016
    90,27000%8.9.2016
    89,57000%9.9.2016
    88,14000%12.9.2016
    88,63000%13.9.2016
    87,87000%14.9.2016
    87,68000%15.9.2016
    87,81000%16.9.2016
    88,06000%19.9.2016
    88,28000%20.9.2016
    88,88000%21.9.2016
    89,01000%22.9.2016
    89,49000%23.9.2016
    89,08000%26.9.2016
    88,85000%27.9.2016
    88,98000%28.9.2016
    89,52000%29.9.2016
    89,63000%3.10.2016
    89,90000%4.10.2016
    90,32000%5.10.2016
    90,61000%6.10.2016
    90,02000%7.10.2016
    89,92000%10.10.2016
    90,52000%11.10.2016
    90,21000%12.10.2016
    89,13000%13.10.2016
    89,84000%14.10.2016
    89,78000%17.10.2016
    89,97000%18.10.2016
    90,10000%19.10.2016
    90,69000%20.10.2016
    90,56000%21.10.2016
    91,04000%24.10.2016
    90,85000%25.10.2016
    90,56000%26.10.2016
    90,37000%27.10.2016
    90,23000%28.10.2016
    90,67000%31.10.2016
    90,62000%1.11.2016
    89,38000%2.11.2016
    89,01000%3.11.2016
    88,64000%4.11.2016
    89,34000%7.11.2016
    88,99000%9.11.2016
    89,69000%10.11.2016
    88,95000%11.11.2016
    89,16000%14.11.2016
    89,26000%15.11.2016
    89,71000%16.11.2016
    89,13000%17.11.2016
    89,75000%18.11.2016
    89,64000%21.11.2016
    90,23000%22.11.2016
    89,96000%23.11.2016
    89,87000%24.11.2016
    89,72000%25.11.2016
    89,44000%28.11.2016
    89,10000%29.11.2016
    89,31000%30.11.2016
    89,57000%1.12.2016
    89,16000%5.12.2016
    90,63000%8.12.2016
    91,41000%9.12.2016
    91,86000%12.12.2016
    91,63000%13.12.2016
    92,02000%14.12.2016
    92,04000%15.12.2016
    92,47000%16.12.2016
    92,40000%19.12.2016
    92,88000%21.12.2016
    92,92000%22.12.2016
    93,09000%23.12.2016
    93,27000%27.12.2016
    93,21000%28.12.2016
    93,12000%29.12.2016
    93,15000%30.12.2016
    93,25000%2.1.2017
    93,95000%3.1.2017
    93,83000%5.1.2017
    93,84000%9.1.2017
    94,50000%11.1.2017
    93,78000%12.1.2017
    94,02000%13.1.2017
    93,76000%16.1.2017
    93,19000%18.1.2017
    93,00000%19.1.2017
    92,62000%20.1.2017
    91,99000%23.1.2017
    91,82000%24.1.2017
    91,82000%25.1.2017
    92,23000%26.1.2017
    92,77000%27.1.2017
    92,08000%30.1.2017
    91,44000%31.1.2017
    91,36000%1.2.2017
    90,91000%2.2.2017
    91,05000%3.2.2017
    91,35000%6.2.2017
    90,67000%8.2.2017
    91,11000%9.2.2017
    91,41000%14.2.2017
    91,47000%15.2.2017
    91,60000%16.2.2017
    91,71000%20.2.2017
    91,45000%21.2.2017
    92,22000%22.2.2017
    92,21000%23.2.2017
    92,27000%24.2.2017
    92,07000%27.2.2017
    91,92000%28.2.2017
    93,13000%2.3.2017
    92,84000%3.3.2017
    92,55000%6.3.2017
    92,64000%7.3.2017
    92,24000%8.3.2017
    91,75000%9.3.2017
    92,19000%10.3.2017
    92,23000%13.3.2017
    92,53000%14.3.2017
    92,42000%15.3.2017
    92,72000%16.3.2017
    92,69000%17.3.2017
    93,04000%20.3.2017
    93,32000%21.3.2017
    92,53000%22.3.2017
    92,45000%23.3.2017
    92,62000%24.3.2017
    92,35000%27.3.2017
    92,48000%28.3.2017
    92,48000%30.3.2017
    93,67000%3.4.2017
    93,24000%5.4.2017
    92,81000%6.4.2017
    93,31000%7.4.2017
    93,54000%10.4.2017
    93,22000%11.4.2017
    93,80000%12.4.2017
    92,80000%13.4.2017
    92,81000%18.4.2017
    91,62000%19.4.2017
    91,47000%20.4.2017
    91,50000%21.4.2017
    92,82000%24.4.2017
    93,23000%25.4.2017
    93,24000%26.4.2017
    93,37000%27.4.2017
    93,47000%28.4.2017
    93,68000%2.5.2017
    93,66000%3.5.2017
    93,60000%4.5.2017
    93,77000%5.5.2017
    95,07000%8.5.2017
    95,26000%9.5.2017
    94,82000%11.5.2017
    94,98000%12.5.2017
    95,35000%15.5.2017
    95,57000%17.5.2017
    95,22000%18.5.2017
    94,84000%19.5.2017
    94,84000%22.5.2017
    95,32000%23.5.2017
    95,12000%24.5.2017
    94,88000%26.5.2017
    94,94000%29.5.2017
    94,60000%30.5.2017
    94,92000%31.5.2017
    95,13000%1.6.2017
    95,53000%2.6.2017
    94,32000%6.6.2017
    93,90000%7.6.2017
    93,91000%8.6.2017
    93,86000%12.6.2017
    94,00000%13.6.2017
    94,28000%14.6.2017
    93,73000%15.6.2017
    93,75000%16.6.2017
    94,05000%19.6.2017
    94,05000%20.6.2017
    93,07000%21.6.2017
    93,07000%22.6.2017
    93,48000%26.6.2017
    93,26000%27.6.2017
    92,66000%28.6.2017
    93,20000%29.6.2017
    91,66000%30.6.2017
    91,75000%3.7.2017
    91,84000%4.7.2017
    91,69000%5.7.2017
    91,63000%6.7.2017
    91,01000%7.7.2017
    91,20000%10.7.2017
    91,44000%11.7.2017
    92,12000%14.7.2017
    92,27000%17.7.2017
    92,27000%18.7.2017
    92,36000%20.7.2017
    91,72000%21.7.2017
    91,05000%24.7.2017
    91,07000%25.7.2017
    91,46000%26.7.2017
    91,51000%27.7.2017
    90,77000%28.7.2017
    90,92000%31.7.2017
    91,17000%1.8.2017
    91,59000%2.8.2017
    91,52000%3.8.2017
    91,81000%4.8.2017
    92,82000%7.8.2017
    92,70000%8.8.2017
    91,03000%22.8.2017
    91,20000%29.8.2017
    91,43000%30.8.2017
    91,65000%31.8.2017
    92,17000%1.9.2017
    91,76000%4.9.2017
    92,34000%5.9.2017
    92,34000%6.9.2017
    93,15000%7.9.2017
    93,25000%8.9.2017
    93,69000%11.9.2017
    94,15000%12.9.2017
    94,24000%13.9.2017
    94,61000%14.9.2017
    94,75000%15.9.2017
    94,89000%18.9.2017
    94,77000%19.9.2017
    95,45000%25.9.2017
    95,81000%26.9.2017
    95,79000%27.9.2017
    95,63000%28.9.2017
    95,91000%29.9.2017
    96,64000%2.10.2017
    97,07000%3.10.2017
    97,69000%4.10.2017
    97,21000%5.10.2017
    97,16000%6.10.2017
    97,10000%9.10.2017
    96,75000%10.10.2017
    97,17000%11.10.2017
    97,12000%12.10.2017
    96,93000%13.10.2017
    97,06000%16.10.2017
    97,38000%17.10.2017
    97,44000%18.10.2017
    97,67000%19.10.2017
    97,52000%20.10.2017
    97,44000%23.10.2017
    97,33000%24.10.2017
    96,46000%26.10.2017
    98,07000%27.10.2017
    98,43000%31.10.2017
    99,23000%1.11.2017