$results_portfolio = mysql_query("SELECT id, name, manager FROM portfolios_compare WHERE id > 0 ORDER BY id ASC");
while ($row = mysql_fetch_row($results_portfolio)) {
?>
|
echo $row[1];?> Portfolio
Portfolio Manager: echo $row[2];?>
|
Company |
Symbol |
Pitch Date |
Pitch Price |
Current Price |
Return |
| |
|
|
|
|
|
$criteria = $row[0]-1;
if ($criteria < 2) $results_stock = mysql_query("SELECT ticker, date, voted FROM stocks_pitched WHERE voted = '$criteria'");
else $results_stock = mysql_query("SELECT ticker, date, voted FROM stocks_pitched");
unset($pricesArray, $oldPricesArray, $nameArray, $retArray);
$pricesArray;
$oldPricesArray;
$nameArray;
$retArray;
while ($stock = mysql_fetch_row($results_stock)) {
$ticker = $stock[0];
$open = fopen("http://download.finance.yahoo.com/d/quotes.csv?s=$ticker&f=l1", "r");
$read = fread($open, 2000);
fclose($open);
$read = str_replace("\"", "", $read);
$read = explode(",", $read);
$price = $read[0];
$open = fopen("http://download.finance.yahoo.com/d/quotes.csv?s=$ticker&f=n", "r");
$read = fread($open, 2000);
fclose($open);
$read = str_replace("\"", "", $read);
$read = explode(",", $read);
$name = $read[0];
//old price here
$date = $stock[1];
$endyear = substr($date, 0, 4);
$endmonth = substr($date, 5, 2)-1;
$endday = substr($date, 8, 2);
$startyear = $endyear;
$startmonth = $endmonth;
$startday = $endday - 10;
if ($startday < 1){
$startday += 28;
$startmonth -= 1;
if ($startmonth < 0){
$startmonth = 11;
$startyear -= 1;
}
}
$open = fopen("http://ichart.finance.yahoo.com/table.csv?s=$ticker&d=$endmonth&e=$endday&f=$endyear&g=d&a=$startmonth&b=$startday&c=$startyear&ignore=.csv","r");
$read = fread($open, 2000);
fclose($open);
$read = str_replace("\"", "", $read);
$read = explode(",", $read);
$oldprice = $read[10];
$ticker_suffix = substr(strtoupper($ticker), -3);
switch ($ticker_suffix) {
case ".TO":
if (empty($fxCADUSD)) {
$fxOpen = fopen("http://download.finance.yahoo.com/d/quotes.csv?s=CADUSD=X&f=l1","r");
$fxRead = fread($fxOpen,2000);
fclose($fxOpen);
$fxRead = str_replace("\"","",$fxRead);
$fxRead = explode(",",$fxRead);
$fxCADUSD = $fxRead[0];
}
$price = $price * $fxCADUSD;
break;
case ".MX":
if (empty($fxMXNUSD)) {
$fxOpen = fopen("http://download.finance.yahoo.com/d/quotes.csv?s=MXNUSD=X&f=l1","r");
$fxRead = fread($fxOpen,2000);
fclose($fxOpen);
$fxRead = explode(",", str_replace("\"","",$fxRead));
$fxMXNUSD = $fxRead[0];
}
$price = $price * $fxMXNUSD;
break;
}
$pricesArray[] = round($price,2);
$oldPricesArray[] = round($oldprice,2);
$nameArray[] = $name;
$retArray[] = $price/$oldprice-1;
}
$totalReturn_pct = round(array_sum($retArray)/count($retArray),4)*100;
if($totalReturn_pct >= 0) $totalReturn_pct_text = $totalReturn_pct."%";
else {
$temp = $totalReturn_pct * (-1);
$totalReturn_pct_text = "-".$temp."%";
}
mysql_data_seek($results_stock,0);
$x = 0;
$color = true;
while ($stock = mysql_fetch_row($results_stock)) {
$ticker = $stock[0];
$date = $stock[1];
$price = $pricesArray[$x];
$oldprice = $oldPricesArray[$x];
$name = $nameArray[$x];
$return_pct = round($retArray[$x],4)*100;
if($return_pct >= 0) $return_pct_text = $return_pct."%";
else {
$temp = $return_pct * (-1);
$return_pct_text = "-".$temp."%";
}
if($color) {
?>
| echo $name;?> |
echo $ticker;?> |
echo $date;?> |
$ echo $oldprice;?> |
$ echo $price;?> |
echo $return_pct_text;?> |
$color = false;
}
else {
?>
| echo $name;?> |
echo $ticker;?> |
echo $date;?> |
$ echo $oldprice;?> |
$ echo $price;?> |
echo $return_pct_text;?> |
$color = true;
}
$x++;
}
if($color) {
?>
| |
|
|
|
|
|
}
?>
|
| Average Return |
|
|
|
|
echo $totalReturn_pct_text;?> |
|
}
mysql_close();
?>
|