erstkSearchTicker

“;
if ($ERClose>$DownLimit && $ERClose<$UpLimit) Echo "ER Close price $ERClose is within predicted extreme Range: ($DownLimit, $UpLimit )

“;
else
Echo “ER Close price $ERClose is out of predicted extreme Range: ($DownLimit, $UpLimit )

“;

$predError = abs(round(($ERClose-$DownTarget)*100/$DownTarget,2));
if ($predError <1.5) Echo "ER Close price $ERClose is within $predError% of predicted DownTarget Price: ($DownTarget )

“;
else
{
$predError = abs(round(($ERClose-$UpTarget)*100/$UpTarget,2));
if ($predError <1.5) Echo "ER Close price $ERClose is within $predError% of predicted UpTarget Price: ($UpTarget )

“;
else
if ($ERClose > $DownTarget and $ERClose<$UpTarget) Echo "ER Close price $ERClose is within predicted Target Range: ($DownTarget, $UpTarget )

“;
else
{
Echo “ER Close price $ERClose is out of predicted Target Range: ($DownTarget, $UpTarget )

“;

}
}
$predError = round(($ERClose-$closePrice)*100/$closePrice,2);
if ($predError <2.5 and $predError >-2.5)
Echo “ER Close price $ERClose is within $predError% of predicted Close Price: ($closePrice )

“;
else
Echo “ER Close price $ERClose had an error of $predError% to predicted price ($closePrice )

“;
}
}
return $erDate;
}

//$ticker =”AAPL,GOOGL, TSLA, FSLR, VLP”;
function updQueryCnt($conn, $ticker, $today)
{
$updated = $inserted =0;
$statement = “select totQuery,lastIP from lifan.sstkquery where tick=’$ticker’ and date=’$today'”;
$selection=$conn->query($statement);
if (!$selection) {
trigger_error(‘Wrong SQL: ‘ . $statement . ‘ Error: ‘ . $conn->error, E_USER_ERROR);
}
else
{
$fromIP = get_the_user_ip() ;
if ( $selection->num_rows)
{
$row = $selection->fetch_assoc();
$lastIP=$row[‘lastIP’];
$selection->free();
if ($lastIP != $fromIP)
{
$statement = “update lifan.sstkquery set totQuery=totQuery+1,lastIP=’$fromIP’ where tick=’$ticker’ and date=’$today'”;
$result =$conn->query($statement);
if (!$result)
{
trigger_error(‘Wrong SQL: ‘ . $statement . ‘ Error: ‘ . $conn->error, E_USER_ERROR);
}
else
$updated +=$conn->affected_rows;
}

}
else
{

$statement = “Insert into lifan.sstkquery (`tick`,`date`,`totQuery`,`lastIP`) VALUES (‘$ticker’,’$today’,1,’$fromIP’) “;
$result =$conn->query($statement);
if (!$result)
{
echo “Warning: failed to insert updQ(), $conn->error, E_USER_ERROR”;
}
else
$inserted += $conn->affected_rows;

}
$conn->commit();
}
// echo “inserted $inserted; updated $updated “;
}

if ($orderby)
{
if ($orderby == ‘ERDate’ OR $orderby == ‘acqOPrice’)
$orderby = $orderby.” desc”;
else
{
$myrand = rand ();
if ($myrand % 2 ==1)
$orderby = $orderby.” desc”;
}
}
else
$orderby = ” erdate desc, (erstks.cScore+erstks.lscore) DESC, erstks.tick “;

//echo $ticker;
$ticker = preg_replace(“/[\s,]+/”,”,”,$ticker);
echo “[“.$ticker.”]\n”;
// $ticks = preg_split(“/[\s,]+/”,$ticker);

// $ticks = explode(” “,$ticker);

// $count = count($ticks);
$today = date(“Y-m-d”);
$now = date(“Y-m-d H:i”);
$hour = date(“H:i”);
echo “$today\n”;
$cutoff_date= date(‘Y-m-d’, strtotime(“- 821 days”, strtotime($today))); //Calculate only latest ER result

if (1)
{
$url = basename(__FILE__);
$url = $url.”?tickName=$ticker”;

$conn=open_db();
$erDate = getLatestERDate($conn, $ticker);
if (NULL==$erDate)
{
echo “ER Date for ticker $ticker not found\n”;
$conn->close();
return;

}
echo “[finviz ticker=$ticker]”;
$erHour = date(“H:i”,strtotime($erDate));
if ($erDate > $now OR ($erDate >$today and $erHour>=’16:30′ ) OR ($erDate >$today and $erDate<$now and $hour <"16:30")) { predictER($conn, $ticker,$erDate,$cutoff_date); } else { // echo "$erDate > $now $erDate>$today $erHour>’16:30′ \n\n”;
checkERResult($conn, $ticker,$erDate,$cutoff_date);
/*
$preERDate = getLastClosedTradingdate($erDate);
getHistPriceFromG($ticker, $preERDate, $curPrice);
$statement= “SELECT tick,max(erDate) as erDate,$curPrice as preERPrice,erMove as erRange,round($curPrice*(100+max(HighChg))/100,2) as UpLimit, round($curPrice*(100+min(lowChg))/100,2) as DownLimit,round($curPrice*(100+avg(erChange))/100,2) as expectERClose,round($curPrice*(100+(erChange))/100,2) as ERClose, round($curPrice*(100+avg(OpenChg))/100,2) as expectEROpen,round($curPrice*(100+avg(erChange)+1.28*stddev(erChange))/100,2) as UpTarget, round($curPrice*(100+avg(erChange)-1.28*stddev(erChange))/100,2) as DownTarget, stddev(erChange) as sd from sstk as s inner join erstks as e using (tick) WHERE FIND_IN_SET(tick,’$ticker’) and erDate>’$cutoff_date’ “;
$table = $ticker.”Latest ER Result: “;
queryDB($url,$statement, $table);
*/
}

$statement= “SELECT tick,erDate,price,marketcapM,outstandM,floatM,lscore as value, trend as TA, FA, MFI,shortRatio,shortScore,erShtScore,institution,erstks.avgVol,erstks.vol,erstks.pctChange,avgChg as estChg,erChange,preERrun,postERrun,openChg,highChg,lowChg,topOwner,pctOwned,optPain,cest-sdest,callVal,putVal FROM erstks WHERE FIND_IN_SET(erstks.tick,’$ticker’) ORDER BY “.$orderby;

$table =”ERbyTick”;
// queryDB($url,$statement, $table);
$selection=$conn->query($statement);
$num = $selection->num_rows;
if ($num <8) echo "

NOTE: $ticker has limited ER history, thus statistic based on history data may not be as useful as other cases. Please reference this information with caution!

“;

}
if ($updateQuery)
updQueryCnt($conn, $ticker, $today);
$date8= date(‘Y-m-d’, strtotime(“-8 days”, strtotime($today)));
$statement= “SELECT tick, sum(totQuery) as totalCnt from lifan.sstkquery WHERE date>’$date8′ group by (tick) order by totalCnt desc limit 10”;
// echo $statement;
$table = “Currenty Hot Stocks: “;
// queryDB($url,$statement, $table);

$conn->close();
?>