function getStocks()
{
Zend_Loader::loadClass('table_Portfolio');
$stocks = new table_Portfolio();
$stocksList = $stocks->stocks();
foreach ($stocksList as $key => $value) {
$stock[$value] = $value;
}
return $stock;
}
public function sellStock($stock, $quantity)
{
$portfolio = new table_Portfolio();
$where = "CAUS_NM_ID={$_SESSION['userid']} and COAT_TX_ID='{$stock}'";
$port = $portfolio->fetchRow($where);
$qty = $port->CART_NM_Quantidade;
$totalQty = $qty - $quantity;
$data = array('CAUS_NM_ID' => $_SESSION['userid'], 'COAT_TX_ID' => $stock, 'CART_NM_Quantidade' => $totalQty);
if ($totalQty > 0) {
$portfolio->update($data, $where);
} else {
$portfolio->delete($where);
}
}
public function portfolioStdDeviation()
{
$portfolio = new table_Portfolio();
$w = $portfolio->weights();
$n = 0;
foreach ($w as $i) {
$weights[$n] = $i;
$n++;
}
$rets = $this->ReturnsArray();
$j = 0;
foreach ($rets as $r) {
$returns[$j] = $r;
$j++;
}
$matrix = new Finance_Matrix($weights, $rets);
$variance = $matrix->variancePortfolio($weights, $returns);
$portfolioStdDeviation = sqrt($variance);
return $portfolioStdDeviation;
}
