Example #1
0
/**
 * Will return an HTML formatted list of all portfolio's in our system.
 */
function get_portfolio_list()
{
    $portfolioTable = '
    <table class="table" width="720" cellspacing="0">
        <tr>
            <td width="75" class="table_header"><b>Name</b></td>
            <td width="60" class="table_header"><b>Open Trades</b></td>
            <td width="60" class="table_header"><b>Closed Trades</b></td>
            <td width="60" class="table_header"><b>Opening Capital</b></td>
            <td width="60" class="table_header"><b>Account Value</b></td>
            <td width="60" class="table_header"><b>Current Cash</b></td>
            <td width="60" class="table_header"><b>Net Gain/Loss</b></td>
        </tr>';
    $query = mysql_query("SELECT * FROM portfolio ORDER BY name ASC");
    while ($array = mysql_fetch_array($query)) {
        $portfolio = new Portfolio($array);
        $portfolio->runCapitalReport();
        $portfolioTable .= '
        <tr>
            <td width="75" class="table_row"><a href="portfolio.php?portfolio_id=' . $portfolio->id . '">' . $portfolio->name . '</a></td>
            <td width="60" class="table_row">' . $portfolio->getNumOpenTrades() . '</td>
            <td width="60" class="table_row">' . $portfolio->getNumClosedTrades() . '</td>
            <td width="60" class="table_row">$' . round($portfolio->opening_capital, 2) . '</td>
            <td width="60" class="table_row">$' . round($portfolio->account_value, 2) . '</td>
            <td width="60" class="table_row">$' . round($portfolio->current_cash, 2) . '</td>
            <td width="60" class="table_row">$' . round($portfolio->account_value - $portfolio->opening_capital, 2) . '</td>
        </tr>
        ';
    }
    $portfolioTable .= '</table>';
    return $portfolioTable;
}