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%24.8.0590
    100,00000%3.5.2011
    99,60000%14.6.2011
    99,70000%15.6.2011
    100,30000%16.6.2011
    100,20000%17.6.2011
    100,20000%20.6.2011
    99,80000%21.6.2011
    99,70000%22.6.2011
    100,00000%23.6.2011
    100,20000%27.6.2011
    99,70000%28.6.2011
    99,60000%29.6.2011
    99,30000%30.6.2011
    99,20000%1.7.2011
    99,10000%4.7.2011
    99,20000%5.7.2011
    99,70000%6.7.2011
    99,70000%7.7.2011
    99,60000%8.7.2011
    100,40000%11.7.2011
    101,60000%12.7.2011
    100,80000%13.7.2011
    100,50000%14.7.2011
    100,70000%15.7.2011
    100,90000%18.7.2011
    100,50000%19.7.2011
    100,40000%20.7.2011
    100,30000%21.7.2011
    99,80000%22.7.2011
    100,10000%25.7.2011
    99,70000%26.7.2011
    99,90000%27.7.2011
    100,20000%28.7.2011
    100,50000%29.7.2011
    100,30000%1.8.2011
    100,90000%2.8.2011
    100,90000%3.8.2011
    100,80000%4.8.2011
    101,40000%5.8.2011
    99,90000%9.8.2011
    99,80000%10.8.2011
    100,40000%11.8.2011
    100,40000%12.8.2011
    99,90000%18.8.2011
    99,90000%19.8.2011
    99,90000%22.8.2011
    99,60000%23.8.2011
    99,60000%24.8.2011
    99,20000%25.8.2011
    99,50000%26.8.2011
    99,30000%29.8.2011
    99,40000%30.8.2011
    99,50000%31.8.2011
    99,90000%1.9.2011
    100,10000%2.9.2011
    100,40000%5.9.2011
    100,50000%6.9.2011
    100,50000%7.9.2011
    100,50000%8.9.2011
    101,20000%9.9.2011
    102,00000%12.9.2011
    101,80000%13.9.2011
    101,40000%14.9.2011
    101,40000%15.9.2011
    101,00000%16.9.2011
    101,40000%19.9.2011
    101,30000%20.9.2011
    101,50000%21.9.2011
    102,10000%22.9.2011
    102,10000%23.9.2011
    102,20000%26.9.2011
    101,40000%28.9.2011
    101,20000%29.9.2011
    101,40000%30.9.2011
    102,10000%3.10.2011
    102,60000%4.10.2011
    102,10000%5.10.2011
    102,30000%6.10.2011
    101,70000%7.10.2011
    101,20000%10.10.2011
    101,10000%11.10.2011
    100,70000%12.10.2011
    100,80000%13.10.2011
    100,80000%14.10.2011
    100,60000%17.10.2011
    100,90000%18.10.2011
    100,30000%19.10.2011
    100,30000%20.10.2011
    100,40000%21.10.2011
    100,10000%24.10.2011
    99,90000%25.10.2011
    100,20000%26.10.2011
    99,80000%27.10.2011
    99,40000%28.10.2011
    99,80000%31.10.2011
    101,00000%1.11.2011
    100,70000%2.11.2011
    100,60000%3.11.2011
    100,60000%4.11.2011
    100,80000%7.11.2011
    100,80000%8.11.2011
    101,10000%9.11.2011
    100,90000%10.11.2011
    100,80000%11.11.2011
    100,80000%14.11.2011
    101,00000%15.11.2011
    101,30000%16.11.2011
    101,00000%17.11.2011
    100,70000%18.11.2011
    101,00000%21.11.2011
    101,20000%23.11.2011
    101,10000%24.11.2011
    101,60000%25.11.2011
    101,20000%28.11.2011
    101,40000%29.11.2011
    101,50000%1.12.2011
    101,10000%2.12.2011
    101,40000%5.12.2011
    101,70000%7.12.2011
    101,70000%8.12.2011
    101,90000%9.12.2011
    102,00000%12.12.2011
    102,00000%13.12.2011
    102,30000%14.12.2011
    102,60000%16.12.2011
    102,30000%19.12.2011
    102,00000%20.12.2011
    101,90000%21.12.2011
    102,20000%22.12.2011
    102,40000%23.12.2011
    102,40000%27.12.2011
    102,40000%28.12.2011
    103,00000%29.12.2011
    102,00000%30.12.2011
    102,00000%2.1.2012
    101,70000%3.1.2012
    101,70000%4.1.2012
    101,90000%5.1.2012
    102,50000%9.1.2012
    102,20000%10.1.2012
    102,80000%11.1.2012
    102,70000%12.1.2012
    102,70000%13.1.2012
    103,10000%16.1.2012
    102,70000%17.1.2012
    102,80000%18.1.2012
    102,40000%19.1.2012
    102,40000%20.1.2012
    102,10000%24.1.2012
    101,60000%26.1.2012
    101,50000%30.1.2012
    101,60000%31.1.2012
    101,90000%2.2.2012
    101,80000%3.2.2012
    101,90000%7.2.2012
    101,40000%8.2.2012
    101,50000%9.2.2012
    101,10000%10.2.2012
    101,10000%13.2.2012
    101,70000%14.2.2012
    101,90000%15.2.2012
    102,20000%16.2.2012
    101,70000%17.2.2012
    101,50000%20.2.2012
    101,40000%21.2.2012
    101,30000%22.2.2012
    101,30000%23.2.2012
    100,80000%24.2.2012
    100,70000%27.2.2012
    100,90000%28.2.2012
    100,90000%29.2.2012
    101,30000%1.3.2012
    101,60000%2.3.2012
    101,70000%5.3.2012
    101,50000%6.3.2012
    101,80000%7.3.2012
    101,50000%8.3.2012
    101,90000%12.3.2012
    101,90000%13.3.2012
    101,80000%14.3.2012
    101,80000%15.3.2012
    101,60000%16.3.2012
    101,50000%19.3.2012
    101,40000%20.3.2012
    101,40000%21.3.2012
    101,20000%23.3.2012
    101,30000%26.3.2012
    101,20000%27.3.2012
    101,00000%28.3.2012
    101,00000%29.3.2012
    101,30000%30.3.2012
    101,30000%3.4.2012
    101,90000%4.4.2012
    102,00000%5.4.2012
    102,20000%10.4.2012
    102,30000%11.4.2012
    102,40000%12.4.2012
    102,10000%13.4.2012
    102,80000%16.4.2012
    102,30000%17.4.2012
    102,30000%19.4.2012
    102,00000%20.4.2012
    102,90000%25.4.2012
    103,00000%27.4.2012
    102,90000%30.4.2012
    103,30000%2.5.2012
    103,20000%3.5.2012
    103,10000%4.5.2012
    103,60000%8.5.2012
    103,40000%9.5.2012
    103,70000%10.5.2012
    103,80000%11.5.2012
    103,90000%14.5.2012
    104,00000%15.5.2012
    104,00000%16.5.2012
    104,30000%18.5.2012
    104,00000%21.5.2012
    104,20000%22.5.2012
    104,90000%24.5.2012
    105,10000%25.5.2012
    105,00000%28.5.2012
    105,10000%29.5.2012
    105,40000%30.5.2012
    105,60000%31.5.2012
    105,80000%1.6.2012
    105,50000%4.6.2012
    105,40000%5.6.2012
    105,30000%6.6.2012
    104,90000%7.6.2012
    105,30000%8.6.2012
    104,90000%11.6.2012
    105,00000%13.6.2012
    104,80000%14.6.2012
    104,90000%15.6.2012
    104,80000%18.6.2012
    104,70000%19.6.2012
    104,40000%20.6.2012
    104,50000%21.6.2012
    105,10000%25.6.2012
    105,20000%26.6.2012
    105,10000%27.6.2012
    105,30000%28.6.2012
    104,80000%29.6.2012
    104,70000%2.7.2012
    104,80000%3.7.2012
    104,80000%4.7.2012
    105,00000%5.7.2012
    105,40000%6.7.2012
    105,90000%9.7.2012
    105,80000%10.7.2012
    105,90000%11.7.2012
    106,30000%12.7.2012
    106,40000%13.7.2012
    106,30000%16.7.2012
    106,30000%17.7.2012
    106,30000%18.7.2012
    106,40000%19.7.2012
    106,70000%23.7.2012
    106,70000%24.7.2012
    106,80000%25.7.2012
    106,70000%26.7.2012
    106,10000%27.7.2012
    106,80000%30.7.2012
    106,80000%31.7.2012
    106,60000%1.8.2012
    106,80000%3.8.2012
    106,40000%6.8.2012
    106,20000%7.8.2012
    106,50000%8.8.2012
    106,30000%10.8.2012
    106,70000%13.8.2012
    106,50000%14.8.2012
    106,50000%15.8.2012
    106,70000%16.8.2012
    106,50000%17.8.2012
    106,60000%20.8.2012
    106,30000%21.8.2012
    100,00000%22.8.2012
    105,90000%23.8.2012
    106,30000%24.8.2012
    106,30000%27.8.2012
    106,30000%28.8.2012
    106,10000%29.8.2012
    106,20000%30.8.2012
    106,30000%31.8.2012
    106,20000%3.9.2012
    106,00000%4.9.2012
    106,00000%5.9.2012
    106,00000%6.9.2012
    106,00000%7.9.2012
    105,40000%10.9.2012
    105,50000%11.9.2012
    105,10000%12.9.2012
    105,10000%13.9.2012
    104,70000%14.9.2012
    104,50000%17.9.2012
    104,60000%18.9.2012
    104,90000%19.9.2012
    105,10000%20.9.2012
    105,00000%21.9.2012
    105,20000%24.9.2012
    105,10000%25.9.2012
    105,10000%26.9.2012
    105,00000%27.9.2012
    105,20000%28.9.2012
    105,00000%2.10.2012
    105,00000%3.10.2012
    104,90000%4.10.2012
    104,90000%5.10.2012
    104,80000%8.10.2012
    104,90000%9.10.2012
    105,10000%10.10.2012
    105,20000%11.10.2012
    104,80000%12.10.2012
    104,80000%15.10.2012
    104,70000%16.10.2012
    104,40000%17.10.2012
    104,40000%18.10.2012
    104,60000%19.10.2012
    104,50000%22.10.2012
    104,60000%23.10.2012
    104,50000%24.10.2012
    104,30000%25.10.2012
    104,50000%26.10.2012
    104,60000%29.10.2012
    104,50000%30.10.2012
    104,60000%2.11.2012
    104,70000%7.11.2012
    105,20000%9.11.2012
    105,20000%12.11.2012
    105,30000%13.11.2012
    105,10000%14.11.2012
    105,00000%15.11.2012
    105,00000%19.11.2012
    104,90000%20.11.2012
    105,00000%21.11.2012
    104,70000%22.11.2012
    104,50000%23.11.2012
    104,30000%26.11.2012
    104,40000%27.11.2012
    104,50000%28.11.2012
    104,20000%30.11.2012
    104,20000%3.12.2012
    104,00000%4.12.2012
    104,10000%6.12.2012
    104,60000%7.12.2012
    104,60000%10.12.2012
    104,40000%11.12.2012
    104,20000%12.12.2012
    104,10000%13.12.2012
    104,00000%14.12.2012
    103,80000%17.12.2012
    103,80000%18.12.2012
    103,50000%19.12.2012
    103,50000%20.12.2012
    103,60000%21.12.2012
    103,60000%28.12.2012
    103,50000%2.1.2013
    103,50000%3.1.2013
    104,10000%4.1.2013
    104,10000%7.1.2013
    103,80000%8.1.2013
    104,10000%9.1.2013
    103,70000%10.1.2013
    103,40000%11.1.2013
    103,10000%14.1.2013
    103,10000%15.1.2013
    103,20000%16.1.2013
    103,00000%17.1.2013
    103,00000%18.1.2013
    103,20000%21.1.2013
    103,10000%22.1.2013
    103,10000%24.1.2013
    102,60000%25.1.2013
    102,60000%28.1.2013
    102,60000%29.1.2013
    102,40000%30.1.2013
    102,30000%31.1.2013
    102,10000%1.2.2013
    102,40000%4.2.2013
    102,50000%5.2.2013
    102,50000%6.2.2013
    102,50000%7.2.2013
    102,90000%8.2.2013
    102,90000%12.2.2013
    102,70000%13.2.2013
    103,10000%14.2.2013
    103,10000%15.2.2013
    103,10000%18.2.2013
    103,10000%19.2.2013
    103,00000%20.2.2013
    103,50000%21.2.2013
    103,60000%22.2.2013
    103,20000%25.2.2013
    103,80000%26.2.2013
    103,90000%27.2.2013
    104,20000%28.2.2013
    104,60000%1.3.2013
    104,50000%4.3.2013
    104,40000%5.3.2013
    104,40000%7.3.2013
    104,20000%8.3.2013
    104,40000%11.3.2013
    104,40000%12.3.2013
    104,40000%13.3.2013
    104,30000%15.3.2013
    104,60000%18.3.2013
    104,60000%19.3.2013
    104,80000%20.3.2013
    104,70000%21.3.2013
    104,50000%22.3.2013
    104,60000%25.3.2013
    104,90000%26.3.2013
    105,20000%27.3.2013
    105,00000%28.3.2013
    105,10000%2.4.2013
    105,10000%3.4.2013
    105,20000%4.4.2013
    104,60000%5.4.2013
    104,50000%8.4.2013
    104,40000%9.4.2013
    104,30000%10.4.2013
    104,10000%11.4.2013
    104,30000%12.4.2013
    104,30000%15.4.2013
    104,20000%16.4.2013
    104,00000%17.4.2013
    104,40000%18.4.2013
    104,30000%19.4.2013
    104,50000%22.4.2013
    104,60000%23.4.2013
    104,50000%24.4.2013
    104,40000%25.4.2013
    104,60000%26.4.2013
    104,30000%29.4.2013
    104,00000%30.4.2013
    104,00000%2.5.2013
    104,20000%3.5.2013
    104,20000%6.5.2013
    104,20000%7.5.2013
    104,20000%8.5.2013
    104,60000%10.5.2013
    104,60000%13.5.2013
    104,50000%14.5.2013
    105,00000%15.5.2013
    105,00000%16.5.2013
    105,00000%17.5.2013
    105,10000%20.5.2013
    105,00000%21.5.2013
    104,80000%22.5.2013
    104,80000%23.5.2013
    104,70000%24.5.2013
    104,70000%27.5.2013
    104,80000%28.5.2013
    104,80000%29.5.2013
    104,60000%30.5.2013
    104,70000%31.5.2013
    104,50000%3.6.2013
    104,30000%4.6.2013
    104,30000%5.6.2013
    104,30000%6.6.2013
    103,60000%7.6.2013
    103,80000%10.6.2013
    103,50000%11.6.2013
    103,50000%12.6.2013
    103,40000%13.6.2013
    103,40000%14.6.2013
    103,30000%18.6.2013
    103,20000%19.6.2013
    103,80000%20.6.2013
    104,00000%24.6.2013
    104,00000%25.6.2013
    104,30000%26.6.2013
    104,30000%27.6.2013
    104,50000%28.6.2013
    104,20000%1.7.2013
    104,40000%2.7.2013
    104,60000%3.7.2013
    104,50000%4.7.2013
    104,90000%5.7.2013
    105,00000%8.7.2013
    104,90000%9.7.2013
    105,10000%10.7.2013
    104,30000%11.7.2013
    104,30000%12.7.2013
    104,30000%15.7.2013
    104,10000%16.7.2013
    103,90000%17.7.2013
    104,10000%18.7.2013
    104,10000%19.7.2013
    103,80000%22.7.2013
    103,80000%23.7.2013
    103,60000%24.7.2013
    103,80000%25.7.2013
    103,60000%26.7.2013
    103,50000%29.7.2013
    103,50000%30.7.2013
    103,50000%31.7.2013
    103,50000%1.8.2013
    103,70000%2.8.2013
    103,50000%5.8.2013
    103,40000%7.8.2013
    103,30000%8.8.2013
    103,30000%9.8.2013
    103,50000%12.8.2013
    103,40000%13.8.2013
    103,50000%14.8.2013
    103,40000%15.8.2013
    103,30000%16.8.2013
    103,20000%19.8.2013
    103,10000%20.8.2013
    103,10000%21.8.2013
    103,40000%22.8.2013
    103,20000%23.8.2013
    103,20000%26.8.2013
    103,20000%28.8.2013
    103,60000%29.8.2013
    103,90000%30.8.2013
    103,80000%2.9.2013
    104,00000%3.9.2013
    104,00000%5.9.2013
    104,20000%6.9.2013
    103,90000%9.9.2013
    103,70000%10.9.2013
    103,70000%11.9.2013
    103,60000%12.9.2013
    103,60000%13.9.2013
    103,40000%16.9.2013
    103,40000%17.9.2013
    103,40000%18.9.2013
    102,80000%19.9.2013
    102,80000%20.9.2013
    102,90000%23.9.2013
    103,00000%24.9.2013
    102,90000%25.9.2013
    102,90000%26.9.2013
    102,80000%27.9.2013
    102,80000%30.9.2013
    102,80000%1.10.2013
    102,60000%2.10.2013
    102,60000%3.10.2013
    102,60000%4.10.2013
    102,60000%7.10.2013
    102,70000%8.10.2013
    102,90000%10.10.2013
    102,80000%11.10.2013
    103,00000%14.10.2013
    103,20000%15.10.2013
    103,00000%16.10.2013
    102,70000%17.10.2013
    102,60000%18.10.2013
    102,60000%21.10.2013
    102,60000%22.10.2013
    102,40000%23.10.2013
    102,30000%24.10.2013
    102,30000%25.10.2013
    102,30000%28.10.2013
    102,30000%29.10.2013
    102,30000%30.10.2013
    102,90000%31.10.2013
    103,20000%1.11.2013
    103,10000%4.11.2013
    103,10000%6.11.2013
    103,50000%7.11.2013
    103,10000%8.11.2013
    103,10000%11.11.2013
    103,20000%12.11.2013
    103,10000%13.11.2013
    103,10000%14.11.2013
    102,90000%15.11.2013
    102,70000%18.11.2013
    102,80000%19.11.2013
    102,70000%20.11.2013
    102,90000%21.11.2013
    102,90000%22.11.2013
    102,90000%25.11.2013
    102,60000%26.11.2013
    102,40000%27.11.2013
    102,40000%28.11.2013
    102,60000%2.12.2013
    102,40000%3.12.2013
    102,50000%4.12.2013
    102,30000%5.12.2013
    102,00000%9.12.2013
    101,80000%10.12.2013
    101,70000%11.12.2013
    101,80000%12.12.2013
    101,80000%13.12.2013
    101,70000%16.12.2013
    101,80000%17.12.2013
    101,80000%18.12.2013
    102,10000%19.12.2013
    102,10000%20.12.2013
    102,00000%23.12.2013
    101,70000%27.12.2013
    101,80000%30.12.2013
    101,60000%31.12.2013
    102,10000%2.1.2014
    102,20000%3.1.2014
    102,20000%8.1.2014
    102,30000%9.1.2014
    102,30000%10.1.2014
    102,10000%13.1.2014
    102,00000%14.1.2014
    102,20000%15.1.2014
    102,10000%16.1.2014
    102,30000%17.1.2014
    102,30000%20.1.2014
    102,40000%21.1.2014
    102,40000%22.1.2014
    102,10000%23.1.2014
    101,90000%24.1.2014
    102,00000%27.1.2014
    101,90000%28.1.2014
    101,90000%29.1.2014
    102,20000%30.1.2014
    102,30000%31.1.2014
    102,30000%3.2.2014
    102,20000%4.2.2014
    102,20000%5.2.2014
    102,10000%6.2.2014
    102,10000%7.2.2014
    102,10000%10.2.2014
    102,00000%11.2.2014
    102,30000%12.2.2014
    102,10000%13.2.2014
    102,00000%17.2.2014
    101,70000%18.2.2014
    101,80000%19.2.2014
    101,80000%20.2.2014
    101,80000%24.2.2014
    101,80000%25.2.2014
    101,80000%26.2.2014
    102,10000%27.2.2014
    101,50000%28.2.2014
    101,50000%3.3.2014
    101,60000%4.3.2014
    101,70000%5.3.2014
    101,60000%6.3.2014
    101,10000%7.3.2014
    101,10000%10.3.2014
    101,20000%11.3.2014
    101,00000%12.3.2014
    101,30000%13.3.2014
    101,30000%14.3.2014
    101,40000%18.3.2014
    101,40000%19.3.2014
    101,90000%20.3.2014
    101,80000%21.3.2014
    101,80000%24.3.2014
    101,70000%25.3.2014
    101,70000%26.3.2014
    101,90000%27.3.2014
    101,90000%28.3.2014
    101,80000%2.4.2014
    101,80000%3.4.2014
    102,10000%4.4.2014
    102,00000%8.4.2014
    101,50000%10.4.2014
    101,40000%11.4.2014
    101,50000%14.4.2014
    101,60000%15.4.2014
    101,50000%16.4.2014
    101,40000%17.4.2014
    101,40000%22.4.2014
    101,30000%23.4.2014
    101,40000%24.4.2014
    101,30000%25.4.2014
    101,30000%28.4.2014
    101,20000%29.4.2014
    101,40000%30.4.2014
    101,20000%2.5.2014
    101,10000%5.5.2014
    100,80000%6.5.2014
    101,40000%9.5.2014
    101,50000%12.5.2014
    101,90000%13.5.2014
    102,20000%14.5.2014
    102,40000%15.5.2014
    102,30000%19.5.2014
    102,40000%20.5.2014
    102,60000%21.5.2014
    102,70000%22.5.2014
    103,00000%23.5.2014
    102,90000%26.5.2014
    102,90000%27.5.2014
    103,10000%28.5.2014
    103,20000%2.6.2014
    103,50000%3.6.2014
    103,50000%4.6.2014
    103,50000%5.6.2014
    103,50000%6.6.2014
    103,50000%9.6.2014
    103,50000%10.6.2014
    103,50000%11.6.2014
    103,50000%12.6.2014
    103,50000%13.6.2014
    103,77000%16.6.2014