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
    110,00000%8.1.2013
    110,10000%14.2.2013
    109,90000%15.2.2013
    110,30000%18.2.2013
    110,20000%19.2.2013
    110,80000%20.2.2013
    110,60000%21.2.2013
    110,70000%22.2.2013
    111,20000%25.2.2013
    110,40000%26.2.2013
    111,10000%27.2.2013
    111,90000%28.2.2013
    112,00000%1.3.2013
    112,10000%4.3.2013
    112,70000%5.3.2013
    113,20000%7.3.2013
    112,80000%8.3.2013
    113,40000%11.3.2013
    113,60000%12.3.2013
    113,50000%13.3.2013
    114,10000%15.3.2013
    114,20000%18.3.2013
    113,80000%19.3.2013
    113,80000%20.3.2013
    114,50000%21.3.2013
    113,90000%22.3.2013
    114,60000%25.3.2013
    115,10000%26.3.2013
    115,70000%27.3.2013
    114,90000%28.3.2013
    115,80000%2.4.2013
    115,90000%3.4.2013
    115,30000%4.4.2013
    115,80000%5.4.2013
    115,70000%8.4.2013
    116,10000%9.4.2013
    116,30000%10.4.2013
    116,70000%11.4.2013
    117,40000%12.4.2013
    117,60000%15.4.2013
    115,90000%16.4.2013
    117,10000%17.4.2013
    116,80000%18.4.2013
    116,60000%19.4.2013
    117,80000%22.4.2013
    118,40000%23.4.2013
    118,90000%24.4.2013
    118,60000%25.4.2013
    118,70000%26.4.2013
    118,30000%29.4.2013
    118,10000%30.4.2013
    117,60000%2.5.2013
    118,40000%3.5.2013
    118,80000%6.5.2013
    117,90000%7.5.2013
    118,80000%8.5.2013
    117,70000%10.5.2013
    118,30000%13.5.2013
    118,30000%14.5.2013
    119,60000%15.5.2013
    120,60000%16.5.2013
    119,80000%17.5.2013
    120,80000%20.5.2013
    120,30000%21.5.2013
    120,10000%22.5.2013
    120,10000%23.5.2013
    118,00000%24.5.2013
    117,80000%27.5.2013
    118,00000%28.5.2013
    118,20000%29.5.2013
    116,10000%30.5.2013
    116,30000%31.5.2013
    114,50000%3.6.2013
    114,80000%4.6.2013
    114,50000%5.6.2013
    114,50000%6.6.2013
    113,60000%7.6.2013
    114,90000%10.6.2013
    113,70000%11.6.2013
    113,70000%12.6.2013
    113,20000%13.6.2013
    114,60000%14.6.2013
    115,30000%18.6.2013
    115,70000%19.6.2013
    114,00000%20.6.2013
    112,20000%24.6.2013
    111,70000%25.6.2013
    112,50000%26.6.2013
    113,70000%27.6.2013
    114,50000%28.6.2013
    114,00000%1.7.2013
    114,10000%2.7.2013
    114,10000%3.7.2013
    114,10000%4.7.2013
    114,70000%5.7.2013
    115,50000%8.7.2013
    116,20000%9.7.2013
    117,00000%10.7.2013
    117,70000%11.7.2013
    118,10000%12.7.2013
    118,50000%15.7.2013
    118,80000%16.7.2013
    118,80000%17.7.2013
    118,50000%18.7.2013
    119,50000%19.7.2013
    119,40000%22.7.2013
    119,40000%23.7.2013
    119,10000%24.7.2013
    118,10000%25.7.2013
    118,30000%26.7.2013
    118,50000%29.7.2013
    118,40000%30.7.2013
    118,50000%31.7.2013
    118,10000%1.8.2013
    119,00000%2.8.2013
    118,60000%5.8.2013
    117,40000%7.8.2013
    117,20000%8.8.2013
    117,20000%9.8.2013
    116,60000%12.8.2013
    116,80000%13.8.2013
    116,50000%14.8.2013
    115,90000%15.8.2013
    114,10000%16.8.2013
    113,40000%19.8.2013
    112,80000%20.8.2013
    113,30000%21.8.2013
    112,70000%22.8.2013
    113,10000%23.8.2013
    113,40000%26.8.2013
    111,90000%28.8.2013
    112,10000%29.8.2013
    111,20000%30.8.2013
    111,10000%2.9.2013
    112,00000%3.9.2013
    111,30000%5.9.2013
    111,30000%6.9.2013
    111,30000%9.9.2013
    111,90000%10.9.2013
    112,50000%11.9.2013
    112,80000%12.9.2013
    112,50000%13.9.2013
    112,60000%16.9.2013
    113,40000%17.9.2013
    113,70000%18.9.2013
    114,80000%19.9.2013
    114,70000%20.9.2013
    113,40000%23.9.2013
    114,00000%24.9.2013
    113,60000%25.9.2013
    113,00000%26.9.2013
    113,20000%27.9.2013
    112,60000%30.9.2013
    112,50000%1.10.2013
    112,50000%2.10.2013
    112,10000%3.10.2013
    111,00000%4.10.2013
    111,40000%7.10.2013
    111,10000%8.10.2013
    110,90000%10.10.2013
    112,70000%11.10.2013
    113,10000%14.10.2013
    113,30000%15.10.2013
    112,10000%16.10.2013
    113,40000%17.10.2013
    114,50000%18.10.2013
    114,70000%21.10.2013
    114,50000%22.10.2013
    115,50000%23.10.2013
    115,70000%24.10.2013
    115,70000%25.10.2013
    116,50000%28.10.2013
    116,80000%29.10.2013
    117,10000%30.10.2013
    115,90000%31.10.2013
    116,40000%1.11.2013
    116,60000%4.11.2013
    116,10000%6.11.2013
    117,80000%7.11.2013
    116,00000%8.11.2013
    116,90000%11.11.2013
    116,90000%12.11.2013
    116,40000%13.11.2013
    116,40000%14.11.2013
    117,70000%15.11.2013
    118,00000%18.11.2013
    117,50000%19.11.2013
    117,00000%20.11.2013
    116,40000%21.11.2013
    116,90000%22.11.2013
    116,90000%25.11.2013
    116,40000%26.11.2013
    116,10000%27.11.2013
    116,20000%28.11.2013
    116,10000%2.12.2013
    115,60000%3.12.2013
    115,50000%4.12.2013
    115,00000%5.12.2013
    115,50000%9.12.2013
    115,00000%10.12.2013
    114,40000%11.12.2013
    113,40000%12.12.2013
    113,10000%13.12.2013
    113,00000%16.12.2013
    113,10000%17.12.2013
    113,10000%18.12.2013
    115,20000%19.12.2013
    114,90000%20.12.2013
    115,40000%23.12.2013
    116,10000%27.12.2013
    116,20000%30.12.2013
    116,20000%31.12.2013
    116,10000%2.1.2014
    115,80000%3.1.2014
    115,50000%8.1.2014
    116,00000%9.1.2014
    116,10000%10.1.2014
    116,30000%13.1.2014
    115,20000%14.1.2014
    116,10000%15.1.2014
    116,10000%16.1.2014
    116,30000%17.1.2014
    116,10000%20.1.2014
    116,20000%21.1.2014
    116,90000%22.1.2014
    116,70000%23.1.2014
    115,40000%24.1.2014
    113,60000%27.1.2014
    113,40000%28.1.2014
    113,40000%29.1.2014
    113,40000%30.1.2014
    113,60000%31.1.2014
    113,60000%3.2.2014
    111,40000%4.2.2014
    111,20000%5.2.2014
    111,60000%6.2.2014
    111,60000%7.2.2014
    113,00000%10.2.2014
    113,40000%11.2.2014
    114,90000%12.2.2014
    114,60000%13.2.2014
    116,00000%17.2.2014
    115,80000%18.2.2014
    115,80000%19.2.2014
    115,80000%20.2.2014
    116,10000%24.2.2014
    116,30000%25.2.2014
    116,30000%26.2.2014
    116,50000%27.2.2014
    116,40000%28.2.2014
    117,00000%3.3.2014
    116,60000%4.3.2014
    118,30000%5.3.2014
    117,70000%6.3.2014
    117,30000%7.3.2014
    117,80000%10.3.2014
    117,90000%11.3.2014
    117,50000%12.3.2014
    118,00000%13.3.2014
    117,30000%14.3.2014
    118,00000%18.3.2014
    118,20000%19.3.2014
    117,50000%20.3.2014
    118,00000%21.3.2014
    118,30000%24.3.2014
    118,00000%25.3.2014
    118,70000%26.3.2014
    118,30000%27.3.2014
    119,00000%28.3.2014
    120,10000%2.4.2014
    120,40000%3.4.2014
    120,90000%4.4.2014
    120,10000%8.4.2014
    119,90000%10.4.2014
    118,30000%11.4.2014
    117,70000%14.4.2014
    118,70000%15.4.2014
    119,80000%16.4.2014
    120,80000%17.4.2014
    120,70000%22.4.2014
    120,60000%23.4.2014
    120,60000%24.4.2014
    120,70000%25.4.2014
    120,70000%28.4.2014
    121,50000%29.4.2014
    121,70000%30.4.2014
    122,10000%2.5.2014
    121,60000%5.5.2014
    121,70000%6.5.2014
    122,20000%9.5.2014
    122,10000%12.5.2014
    122,60000%13.5.2014
    122,80000%14.5.2014
    122,60000%15.5.2014
    121,80000%19.5.2014
    121,60000%20.5.2014
    120,60000%21.5.2014
    121,30000%22.5.2014
    121,80000%23.5.2014
    121,90000%26.5.2014
    122,00000%27.5.2014
    122,50000%28.5.2014
    122,80000%2.6.2014
    122,90000%3.6.2014
    122,80000%4.6.2014
    123,80000%5.6.2014
    123,80000%6.6.2014
    124,40000%9.6.2014
    124,60000%10.6.2014
    124,40000%11.6.2014
    123,60000%12.6.2014
    123,00000%13.6.2014
    123,50000%16.6.2014
    123,90000%17.6.2014
    124,10000%18.6.2014
    125,40000%19.6.2014
    126,20000%23.6.2014
    125,50000%24.6.2014
    125,20000%25.6.2014
    125,60000%26.6.2014
    125,30000%27.6.2014
    125,20000%30.6.2014
    125,20000%1.7.2014
    125,40000%2.7.2014
    124,60000%3.7.2014
    125,20000%7.7.2014
    125,10000%8.7.2014
    124,90000%9.7.2014
    124,70000%10.7.2014
    124,60000%11.7.2014
    124,50000%14.7.2014
    124,50000%15.7.2014
    124,80000%16.7.2014
    125,10000%17.7.2014
    123,60000%18.7.2014
    124,90000%21.7.2014
    124,70000%22.7.2014
    124,60000%23.7.2014
    124,60000%24.7.2014
    125,00000%25.7.2014
    124,30000%28.7.2014
    124,80000%29.7.2014
    123,90000%30.7.2014
    121,10000%31.7.2014
    120,10000%1.8.2014
    119,90000%4.8.2014
    120,10000%5.8.2014
    119,00000%6.8.2014
    118,90000%7.8.2014
    118,60000%8.8.2014
    120,60000%11.8.2014
    120,70000%12.8.2014
    120,80000%13.8.2014
    121,20000%14.8.2014
    121,80000%15.8.2014
    121,80000%18.8.2014
    122,60000%19.8.2014
    123,60000%20.8.2014
    124,10000%21.8.2014
    124,50000%22.8.2014
    124,40000%25.8.2014
    124,90000%26.8.2014
    124,60000%27.8.2014
    124,70000%28.8.2014
    125,00000%1.9.2014
    125,10000%2.9.2014
    124,70000%3.9.2014
    124,90000%4.9.2014
    125,50000%5.9.2014
    126,40000%8.9.2014
    126,20000%9.9.2014
    125,00000%10.9.2014
    125,10000%11.9.2014
    125,00000%12.9.2014
    124,00000%15.9.2014
    124,20000%16.9.2014
    125,00000%17.9.2014
    125,30000%19.9.2014
    125,80000%22.9.2014
    125,80000%23.9.2014
    124,50000%24.9.2014
    125,70000%25.9.2014
    125,10000%29.9.2014
    126,00000%30.9.2014
    125,30000%1.10.2014
    123,90000%2.10.2014
    123,90000%3.10.2014
    125,60000%6.10.2014
    125,30000%7.10.2014
    123,70000%8.10.2014
    125,50000%9.10.2014
    123,60000%10.10.2014
    123,70000%13.10.2014
    121,60000%14.10.2014
    122,10000%15.10.2014
    120,50000%16.10.2014
    120,70000%17.10.2014
    122,20000%20.10.2014
    123,40000%21.10.2014
    125,50000%22.10.2014
    125,40000%23.10.2014
    126,20000%24.10.2014
    127,20000%27.10.2014
    127,20000%28.10.2014
    128,30000%29.10.2014
    128,60000%30.10.2014
    128,50000%31.10.2014
    130,20000%3.11.2014
    130,40000%4.11.2014
    130,60000%5.11.2014
    132,10000%6.11.2014
    132,40000%7.11.2014
    132,10000%10.11.2014
    133,30000%11.11.2014
    132,70000%12.11.2014
    132,20000%13.11.2014
    132,10000%14.11.2014
    131,20000%17.11.2014
    131,90000%18.11.2014
    132,30000%19.11.2014
    132,00000%20.11.2014
    132,50000%21.11.2014
    133,50000%24.11.2014
    132,80000%25.11.2014
    132,60000%26.11.2014
    133,10000%27.11.2014
    133,10000%28.11.2014
    133,50000%2.12.2014
    134,90000%3.12.2014
    135,20000%4.12.2014
    135,00000%5.12.2014
    135,60000%8.12.2014
    135,20000%9.12.2014
    134,80000%10.12.2014
    132,70000%11.12.2014
    133,40000%12.12.2014
    131,00000%15.12.2014
    129,60000%16.12.2014
    129,50000%17.12.2014
    132,90000%18.12.2014
    136,40000%19.12.2014
    136,90000%22.12.2014
    136,90000%23.12.2014
    140,20000%29.12.2014
    140,80000%30.12.2014
    137,60000%2.1.2015
    136,20000%7.1.2015
    138,70000%8.1.2015
    140,70000%9.1.2015
    138,70000%12.1.2015
    138,40000%13.1.2015
    138,40000%14.1.2015
    138,30000%15.1.2015
    138,70000%16.1.2015
    140,80000%19.1.2015
    140,50000%20.1.2015
    140,90000%21.1.2015
    141,30000%22.1.2015
    145,50000%23.1.2015
    144,30000%26.1.2015
    144,00000%27.1.2015
    143,90000%28.1.2015
    140,80000%29.1.2015
    141,90000%30.1.2015
    138,40000%2.2.2015
    140,40000%3.2.2015
    142,00000%4.2.2015
    142,00000%5.2.2015
    143,60000%6.2.2015
    141,90000%9.2.2015
    141,30000%10.2.2015
    141,30000%11.2.2015
    141,90000%12.2.2015
    142,30000%13.2.2015
    141,60000%16.2.2015
    141,90000%17.2.2015
    141,90000%18.2.2015
    143,00000%19.2.2015
    140,50000%20.2.2015
    141,50000%23.2.2015
    141,80000%24.2.2015
    141,10000%25.2.2015
    140,60000%26.2.2015
    141,20000%27.2.2015
    141,20000%2.3.2015
    142,10000%3.3.2015
    141,60000%4.3.2015
    140,50000%5.3.2015
    141,50000%6.3.2015
    138,90000%9.3.2015
    140,50000%10.3.2015
    138,90000%11.3.2015
    141,50000%13.3.2015
    140,50000%16.3.2015
    142,00000%18.3.2015
    143,00000%20.3.2015
    142,00000%23.3.2015
    143,70000%24.3.2015
    142,30000%25.3.2015
    139,60000%26.3.2015
    139,90000%27.3.2015
    140,20000%30.3.2015
    143,30000%31.3.2015
    143,30000%1.4.2015
    143,30000%7.4.2015
    141,90000%8.4.2015
    142,80000%9.4.2015
    143,20000%10.4.2015
    144,00000%13.4.2015
    142,70000%14.4.2015
    143,10000%15.4.2015
    142,70000%16.4.2015
    140,10000%20.4.2015
    141,70000%21.4.2015
    140,80000%22.4.2015
    141,50000%23.4.2015
    141,40000%24.4.2015
    141,60000%27.4.2015
    140,10000%28.4.2015
    140,30000%29.4.2015
    138,50000%30.4.2015
    138,40000%4.5.2015
    139,20000%5.5.2015
    136,40000%6.5.2015
    135,30000%7.5.2015
    136,70000%8.5.2015
    138,60000%11.5.2015
    137,20000%12.5.2015
    136,90000%13.5.2015
    138,10000%15.5.2015
    139,80000%19.5.2015
    140,10000%20.5.2015
    139,90000%21.5.2015
    140,10000%22.5.2015
    140,00000%25.5.2015
    140,30000%26.5.2015
    138,80000%27.5.2015
    140,10000%28.5.2015
    140,00000%29.5.2015
    139,00000%1.6.2015
    138,20000%3.6.2015
    137,50000%4.6.2015
    136,40000%5.6.2015
    135,80000%8.6.2015
    135,10000%9.6.2015
    135,00000%10.6.2015
    137,10000%11.6.2015
    137,80000%12.6.2015
    136,80000%15.6.2015
    135,70000%16.6.2015
    136,80000%17.6.2015
    136,70000%18.6.2015
    137,80000%22.6.2015
    138,90000%23.6.2015
    138,70000%24.6.2015
    137,50000%25.6.2015
    136,90000%26.6.2015
    138,00000%29.6.2015
    135,20000%30.6.2015
    135,00000%1.7.2015
    137,70000%2.7.2015
    137,30000%3.7.2015
    137,50000%6.7.2015
    137,70000%7.7.2015
    139,20000%8.7.2015
    137,00000%9.7.2015
    136,90000%10.7.2015
    139,10000%13.7.2015
    140,50000%14.7.2015
    141,20000%15.7.2015
    141,60000%16.7.2015
    142,90000%17.7.2015
    142,50000%20.7.2015
    142,70000%21.7.2015
    141,20000%22.7.2015
    141,70000%23.7.2015
    139,30000%27.7.2015
    138,80000%28.7.2015
    140,40000%29.7.2015
    142,30000%30.7.2015
    142,80000%31.7.2015
    142,80000%3.8.2015
    143,00000%4.8.2015
    143,20000%5.8.2015
    144,30000%6.8.2015
    143,10000%7.8.2015
    143,00000%10.8.2015
    143,90000%11.8.2015
    143,00000%12.8.2015
    143,20000%13.8.2015
    143,20000%14.8.2015
    145,40000%18.8.2015
    145,40000%19.8.2015
    143,60000%20.8.2015
    140,10000%21.8.2015
    134,70000%24.8.2015
    128,60000%25.8.2015
    126,60000%26.8.2015
    132,50000%27.8.2015
    133,70000%28.8.2015
    132,90000%31.8.2015
    132,30000%1.9.2015
    131,80000%3.9.2015
    129,30000%4.9.2015
    128,90000%7.9.2015
    128,90000%8.9.2015
    132,60000%9.9.2015
    130,10000%10.9.2015
    130,50000%11.9.2015
    131,30000%14.9.2015
    130,90000%15.9.2015
    134,00000%17.9.2015
    133,30000%18.9.2015
    131,90000%21.9.2015
    131,20000%22.9.2015
    130,00000%24.9.2015
    131,20000%25.9.2015
    131,90000%28.9.2015
    128,90000%29.9.2015
    130,90000%30.9.2015
    131,50000%1.10.2015
    131,20000%2.10.2015
    132,40000%5.10.2015
    130,90000%6.10.2015
    134,10000%7.10.2015
    135,70000%8.10.2015
    137,30000%9.10.2015
    137,20000%12.10.2015
    137,80000%13.10.2015
    136,50000%14.10.2015
    134,70000%15.10.2015
    137,10000%16.10.2015
    138,20000%19.10.2015
    138,50000%20.10.2015
    139,00000%21.10.2015
    139,10000%22.10.2015
    143,50000%23.10.2015
    143,30000%27.10.2015
    143,50000%28.10.2015
    144,90000%29.10.2015
    144,20000%30.10.2015
    143,50000%2.11.2015
    145,80000%3.11.2015
    145,10000%4.11.2015
    144,90000%5.11.2015
    145,20000%6.11.2015
    144,70000%9.11.2015
    143,50000%10.11.2015
    144,50000%12.11.2015
    141,90000%13.11.2015
    140,70000%16.11.2015
    143,70000%17.11.2015
    144,00000%18.11.2015
    146,50000%19.11.2015
    147,00000%20.11.2015
    148,10000%23.11.2015
    148,00000%24.11.2015
    147,80000%25.11.2015
    148,00000%26.11.2015
    148,10000%27.11.2015
    148,80000%30.11.2015
    147,90000%1.12.2015
    149,40000%2.12.2015
    149,40000%3.12.2015
    143,20000%4.12.2015
    147,70000%7.12.2015
    147,00000%8.12.2015
    146,10000%9.12.2015
    144,40000%10.12.2015
    143,90000%11.12.2015
    141,60000%14.12.2015
    142,40000%15.12.2015
    144,10000%16.12.2015
    147,70000%17.12.2015
    145,90000%18.12.2015
    142,60000%21.12.2015
    143,60000%22.12.2015
    145,40000%23.12.2015
    147,00000%28.12.2015
    147,40000%29.12.2015
    149,10000%30.12.2015
    143,90000%4.1.2016
    143,90000%5.1.2016
    143,20000%7.1.2016
    140,00000%8.1.2016
    138,20000%11.1.2016
    138,70000%12.1.2016
    136,70000%14.1.2016
    138,30000%15.1.2016
    136,00000%18.1.2016
    137,20000%19.1.2016
    137,10000%20.1.2016
    134,90000%21.1.2016
    135,00000%22.1.2016
    138,00000%25.1.2016
    136,40000%26.1.2016
    138,70000%27.1.2016
    138,10000%28.1.2016
    140,60000%29.1.2016
    142,90000%1.2.2016
    143,00000%2.2.2016
    140,90000%3.2.2016
    140,20000%5.2.2016
    138,90000%8.2.2016
    137,00000%9.2.2016
    137,50000%10.2.2016
    137,20000%11.2.2016
    135,80000%12.2.2016
    138,30000%15.2.2016
    140,70000%17.2.2016
    142,10000%18.2.2016
    142,60000%19.2.2016
    143,00000%22.2.2016
    144,80000%23.2.2016
    144,50000%24.2.2016
    144,90000%25.2.2016
    147,10000%26.2.2016
    145,90000%29.2.2016
    144,90000%1.3.2016
    146,90000%2.3.2016
    147,10000%3.3.2016
    147,50000%4.3.2016
    148,00000%7.3.2016
    147,40000%8.3.2016
    147,50000%9.3.2016
    148,20000%10.3.2016
    147,70000%11.3.2016
    149,60000%14.3.2016
    149,90000%16.3.2016
    149,80000%17.3.2016
    151,50000%18.3.2016
    151,40000%21.3.2016
    151,70000%22.3.2016
    151,40000%23.3.2016
    151,50000%24.3.2016
    151,60000%29.3.2016
    151,60000%30.3.2016
    152,70000%1.4.2016
    154,40000%4.4.2016
    153,70000%5.4.2016
    152,60000%7.4.2016
    151,10000%8.4.2016
    151,70000%11.4.2016
    150,70000%12.4.2016
    152,50000%13.4.2016
    152,80000%14.4.2016
    152,40000%15.4.2016
    152,80000%18.4.2016
    153,90000%19.4.2016
    153,90000%20.4.2016
    152,70000%21.4.2016
    149,80000%22.4.2016
    151,00000%25.4.2016
    151,00000%26.4.2016
    150,80000%27.4.2016
    151,80000%28.4.2016
    149,90000%29.4.2016
    150,00000%2.5.2016
    151,20000%3.5.2016
    151,20000%4.5.2016
    152,80000%9.5.2016
    153,70000%10.5.2016
    155,50000%11.5.2016
    154,20000%12.5.2016
    155,60000%13.5.2016
    155,40000%17.5.2016
    151,80000%18.5.2016
    151,10000%19.5.2016
    152,00000%20.5.2016
    152,30000%23.5.2016
    151,60000%24.5.2016
    154,00000%25.5.2016
    153,70000%26.5.2016
    154,50000%27.5.2016
    155,20000%30.5.2016
    154,60000%31.5.2016
    155,00000%1.6.2016
    155,40000%2.6.2016
    155,70000%6.6.2016
    155,60000%7.6.2016
    155,70000%8.6.2016
    157,00000%9.6.2016
    158,40000%10.6.2016
    158,00000%13.6.2016
    156,80000%14.6.2016
    157,60000%15.6.2016
    156,50000%16.6.2016
    157,70000%17.6.2016
    158,60000%20.6.2016
    158,40000%22.6.2016
    158,00000%23.6.2016
    158,00000%27.6.2016
    157,00000%28.6.2016
    159,40000%29.6.2016
    161,70000%30.6.2016
    165,80000%1.7.2016
    165,80000%4.7.2016
    166,30000%5.7.2016
    166,40000%6.7.2016
    167,20000%7.7.2016
    166,00000%8.7.2016
    168,50000%11.7.2016
    168,20000%12.7.2016
    167,50000%13.7.2016
    167,90000%14.7.2016
    167,80000%15.7.2016
    168,30000%18.7.2016
    168,00000%19.7.2016
    168,00000%20.7.2016
    167,20000%22.7.2016
    168,70000%25.7.2016
    168,00000%26.7.2016
    167,30000%27.7.2016
    164,80000%28.7.2016
    165,20000%29.7.2016
    165,90000%1.8.2016
    166,00000%2.8.2016
    164,90000%3.8.2016
    164,50000%4.8.2016
    164,40000%5.8.2016
    164,90000%8.8.2016
    164,40000%9.8.2016
    164,10000%10.8.2016
    164,60000%11.8.2016
    164,90000%12.8.2016
    164,70000%15.8.2016
    163,50000%16.8.2016
    161,20000%17.8.2016
    162,60000%18.8.2016
    163,20000%19.8.2016
    162,60000%22.8.2016
    162,80000%23.8.2016
    161,50000%25.8.2016
    161,70000%26.8.2016
    160,60000%29.8.2016
    162,30000%30.8.2016
    161,10000%31.8.2016
    161,40000%1.9.2016
    162,50000%5.9.2016
    162,50000%6.9.2016
    162,90000%7.9.2016
    161,80000%8.9.2016
    161,10000%9.9.2016
    155,10000%12.9.2016
    158,20000%13.9.2016
    155,60000%14.9.2016
    155,10000%15.9.2016
    156,80000%16.9.2016
    157,00000%19.9.2016
    157,90000%20.9.2016
    158,30000%21.9.2016
    160,60000%22.9.2016
    162,20000%23.9.2016
    161,00000%26.9.2016
    160,00000%27.9.2016
    160,30000%28.9.2016
    158,60000%30.9.2016
    158,40000%3.10.2016
    157,10000%4.10.2016
    154,30000%5.10.2016
    154,00000%6.10.2016
    154,50000%7.10.2016
    153,90000%10.10.2016
    155,00000%11.10.2016
    153,20000%12.10.2016
    154,60000%13.10.2016
    155,20000%14.10.2016
    154,90000%17.10.2016
    154,80000%18.10.2016
    155,50000%19.10.2016
    155,10000%20.10.2016
    154,20000%21.10.2016
    153,90000%24.10.2016
    154,70000%25.10.2016
    154,40000%26.10.2016
    154,20000%27.10.2016
    152,60000%28.10.2016
    154,50000%31.10.2016
    154,20000%1.11.2016
    151,30000%2.11.2016
    150,20000%3.11.2016
    150,10000%4.11.2016
    149,60000%7.11.2016
    153,70000%9.11.2016
    154,30000%10.11.2016
    153,30000%11.11.2016
    153,90000%14.11.2016
    153,70000%15.11.2016
    155,50000%16.11.2016
    154,90000%17.11.2016
    156,10000%18.11.2016
    155,60000%21.11.2016
    156,90000%22.11.2016
    157,80000%23.11.2016
    158,10000%24.11.2016
    157,80000%25.11.2016
    159,60000%28.11.2016
    160,00000%29.11.2016
    157,40000%1.12.2016
    156,00000%2.12.2016
    156,40000%5.12.2016
    157,20000%7.12.2016
    159,80000%8.12.2016
    160,60000%9.12.2016
    162,10000%12.12.2016
    163,10000%13.12.2016
    164,00000%14.12.2016
    162,50000%15.12.2016
    163,40000%16.12.2016
    164,40000%19.12.2016
    165,70000%20.12.2016
    166,00000%21.12.2016
    164,80000%22.12.2016
    165,10000%23.12.2016
    165,20000%27.12.2016
    165,50000%28.12.2016
    163,50000%29.12.2016
    163,60000%30.12.2016
    163,80000%2.1.2017
    164,30000%3.1.2017
    164,80000%5.1.2017
    165,10000%9.1.2017
    163,00000%10.1.2017
    163,10000%11.1.2017
    162,80000%12.1.2017
    162,70000%13.1.2017
    162,40000%17.1.2017
    163,30000%18.1.2017
    163,60000%19.1.2017
    162,80000%20.1.2017
    163,00000%23.1.2017
    162,10000%24.1.2017
    162,80000%25.1.2017
    163,30000%26.1.2017
    163,00000%27.1.2017
    163,60000%30.1.2017
    162,50000%31.1.2017
    162,70000%1.2.2017
    160,50000%2.2.2017
    162,40000%3.2.2017
    163,60000%6.2.2017
    163,80000%8.2.2017
    164,60000%9.2.2017
    165,80000%10.2.2017
    166,60000%13.2.2017
    167,30000%14.2.2017
    167,30000%15.2.2017
    168,10000%16.2.2017
    170,20000%20.2.2017
    170,50000%21.2.2017
    172,30000%22.2.2017
    172,00000%23.2.2017
    172,90000%24.2.2017
    174,50000%27.2.2017
    173,90000%28.2.2017
    174,70000%1.3.2017
    176,50000%2.3.2017
    176,10000%3.3.2017
    174,30000%7.3.2017
    174,20000%8.3.2017
    172,90000%9.3.2017
    172,60000%10.3.2017
    173,40000%14.3.2017
    174,10000%15.3.2017
    174,90000%16.3.2017
    174,10000%17.3.2017
    174,80000%20.3.2017
    173,90000%21.3.2017
    172,60000%22.3.2017
    173,50000%23.3.2017
    174,60000%24.3.2017
    172,40000%27.3.2017
    172,00000%28.3.2017
    173,30000%29.3.2017
    172,90000%30.3.2017
    172,90000%31.3.2017
    173,30000%3.4.2017
    173,30000%6.4.2017
    173,30000%7.4.2017
    173,50000%10.4.2017
    173,50000%11.4.2017
    173,80000%12.4.2017
    174,20000%18.4.2017
    173,80000%19.4.2017
    173,10000%20.4.2017
    174,10000%21.4.2017
    172,70000%24.4.2017
    174,40000%25.4.2017
    175,10000%26.4.2017
    174,30000%27.4.2017
    174,20000%28.4.2017
    173,00000%2.5.2017
    172,90000%3.5.2017
    172,80000%4.5.2017
    173,60000%5.5.2017
    174,70000%8.5.2017
    174,30000%9.5.2017
    173,80000%10.5.2017
    173,80000%11.5.2017
    172,60000%15.5.2017
    172,70000%16.5.2017
    171,50000%17.5.2017
    170,30000%18.5.2017
    170,80000%19.5.2017
    171,50000%22.5.2017
    173,20000%23.5.2017
    173,90000%24.5.2017
    176,60000%30.5.2017
    176,90000%31.5.2017
    179,20000%5.6.2017
    178,80000%6.6.2017
    178,10000%7.6.2017
    178,00000%8.6.2017
    177,80000%9.6.2017
    178,20000%12.6.2017
    179,40000%14.6.2017
    181,10000%16.6.2017
    181,10000%19.6.2017
    182,10000%20.6.2017
    181,10000%21.6.2017
    179,90000%22.6.2017
    178,70000%26.6.2017
    179,00000%27.6.2017
    176,40000%28.6.2017
    176,10000%29.6.2017
    175,30000%30.6.2017
    175,40000%3.7.2017
    175,80000%4.7.2017
    176,00000%5.7.2017
    174,20000%6.7.2017
    173,60000%7.7.2017
    175,00000%10.7.2017
    174,50000%11.7.2017
    175,70000%12.7.2017
    175,30000%13.7.2017
    175,00000%14.7.2017
    175,60000%17.7.2017
    175,20000%18.7.2017
    176,00000%19.7.2017
    175,90000%21.7.2017
    176,30000%24.7.2017
    175,30000%25.7.2017
    175,80000%26.7.2017
    175,20000%27.7.2017
    175,90000%28.7.2017
    175,50000%31.7.2017
    175,30000%1.8.2017
    175,90000%2.8.2017
    175,90000%3.8.2017
    176,10000%4.8.2017
    176,60000%7.8.2017
    176,70000%8.8.2017
    176,50000%9.8.2017
    176,90000%10.8.2017
    175,60000%11.8.2017
    175,10000%14.8.2017
    177,10000%15.8.2017
    177,70000%16.8.2017
    178,60000%17.8.2017
    176,00000%18.8.2017
    175,60000%21.8.2017
    176,70000%23.8.2017
    176,50000%24.8.2017
    175,80000%25.8.2017
    175,40000%28.8.2017
    174,60000%29.8.2017
    175,30000%30.8.2017
    176,20000%31.8.2017
    176,10000%1.9.2017
    175,90000%4.9.2017
    175,90000%5.9.2017
    174,60000%6.9.2017
    174,60000%7.9.2017
    173,70000%8.9.2017
    175,20000%11.9.2017
    177,10000%12.9.2017
    177,00000%13.9.2017
    177,00000%14.9.2017
    177,00000%15.9.2017
    177,30000%18.9.2017
    177,10000%19.9.2017
    177,00000%20.9.2017
    178,00000%21.9.2017
    177,60000%22.9.2017
    177,30000%25.9.2017
    178,20000%26.9.2017
    178,10000%27.9.2017
    178,10000%28.9.2017
    178,20000%29.9.2017
    178,80000%2.10.2017
    180,20000%5.10.2017
    181,00000%6.10.2017
    180,30000%10.10.2017
    180,40000%11.10.2017
    180,60000%12.10.2017
    180,80000%13.10.2017
    181,30000%16.10.2017
    181,60000%17.10.2017
    181,60000%18.10.2017
    180,80000%19.10.2017
    181,80000%20.10.2017
    182,70000%23.10.2017
    182,40000%24.10.2017
    182,40000%25.10.2017
    181,50000%26.10.2017
    183,40000%27.10.2017
    183,40000%30.10.2017
    182,70000%31.10.2017
    183,40000%1.11.2017
    183,00000%2.11.2017
    183,20000%3.11.2017