2015 - 2016 Global Network Investment Competition Leaderboard
= $a['Value'];
});
//addition for all team scoreboard
$resultCompositePortfolio = mysql_query("select DateStamp, SUM(PercentChange)/50 as Portfolio from SecuritiesData where Ticker NOT LIKE '%Index%' group by DateStamp order by DateStamp", $connect);
$resultCompositeIndex = mysql_query("
SELECT
DateStamp,
PercentChange AS IndexChange
FROM SecuritiesData
Where Ticker = 'FTAW01 Index';
", $connect);
$compositeValue = 0;
if ($resultCompositePortfolio AND $resultCompositeIndex) {
$p_total = 1;
$i_total = 1;
while ($row = mysql_fetch_assoc($resultCompositePortfolio)){
$p_total = $p_total * (1+($row["Portfolio"]/100));
}
while ($row = mysql_fetch_assoc($resultCompositeIndex)){
$i_total = $i_total * (1+($row["IndexChange"]/100));
}
$compositeValue = round((($p_total - $i_total)/$i_total)*100, 2);
}
//end addition
?>
| ".$scoreboard[$x]["Name"]." | ".$scoreboard[$x]["Value"]."% | "; } echo "
| "."Composite of All Teams vs. FTSE All Word Index"." | ".$compositeValue."% |
Performance is measured by the total return of a school’s portfolio since inception (October 30, 2015), calculated on an equally weighted basis, less the total return of the local stock index over the same period.