Latest Institution Transcation (daily update)

0 )
$date = date(“Y-m-d”, strtotime(“-“.$days.” day”, strtotime($date)));
else
$date = getLastClosedTradingdate($date);
if ($orderby)
{
if ($orderby == ‘date’ OR $orderby == ‘marketCapM’)
$orderby = $orderby.” desc”;
else
{
$myrand = rand ();
if ($myrand % 2 ==1)
$orderby = $orderby.” desc”;
}
}
else
$orderby = ” date DESC, marketCapM desc “;

echo “Last Updated: “.$end_date.”\n”;

//$date =”Flux Power Holdings”;

//$sql = “SELECT isc.tick,date,action,sstk.price,sstk.marketCapM,acquirer,pctOwned,isc.pctChange,isc.MFI,sstk.industry,sstk.sector,lscore,cScore,dealer FROM isc INNER JOIN sstk ON isc.tick=sstk.tick WHERE isc.date >= ‘$date’ AND isc.date <= '$end_date' AND isc.tick !='UNKNOWN' AND action!='N' ORDER BY abs(isc.pctChange*sstk.marketcapm) desc"; $sql = "SELECT isc.tick,date,action,sstk.price,sstk.marketCapM,acquirer,pctOwned,isc.pctChange,isc.MFI,sstk.industry,sstk.sector,lscore,cScore,dealer FROM isc INNER JOIN sstk ON isc.tick=sstk.tick WHERE isc.date >= ‘$date’ AND isc.date <= '$end_date' AND isc.tick !='UNKNOWN' AND action!='N' AND isc.pctChange!=0 ORDER BY ".$orderby; if (0) { $url = basename(__FILE__); $url = $url."?days=$days"; $table ="ISC date: ".$date; $ret = queryDB($url,$sql, $table); } else { $conn = open_db(); $rs = $conn->query($sql);
if (!$rs) {
// echo $sql.”\n”;
trigger_error(‘Wrong SQL: ‘ . $sql . ‘ Error: ‘ . $conn->error, E_USER_ERROR);
}
else
{
// echo $sql.”\n”;

$num = 0;
$skipped =0;
echo “

“;
echo ‘

‘;
echo ‘

‘;

echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;

echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
while ($row = $rs->fetch_assoc())
{
$tickName = $row[“tick”];
if ( $row[“tick”] == ‘n/a’ OR $row[“tick”] == ‘UNKNOWN’)
{
if ($skipped == 0 )
{
$skipped = 1;
}
}
// else
{

$showDate = substr($row[“date”],0,10);
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;

}
$num = $num +1;
if ($num % 20 ==0)
{
echo ‘

‘;
echo ‘

‘;

echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;

echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;

}
}
echo “

Tick

price

date

marketCap

B/S

pctOwned

pctChange

acquirer

industry

sector

MFI

cpScore

LTScore

dealer

“.$row[“tick”].”

“.$row[“price”].”

“.$showDate.”

“.$row[“marketCapM”].”

“.$row[“action”].”

“.$row[“pctOwned”].”%

“.$row[“pctChange”].”%

“.$row[“acquirer”].”

“.($row[“industry”]).”

“.$row[“sector”].”

“.$row[“MFI”].”

“.$row[“cScore”].”

“.$row[“lscore”].”

“.$row[“dealer”].”

Tick

price

date

marketCap

action

pctOwned

pctChange

acquirer

industry

sector

MFI

cpScore

LTScore

dealer

“;
echo “

“;
echo “Total “.$num.” records Displayed

“;
}
$conn->close();

}
?>