=’$date’ AND erDate<'$edate' AND sstk.avgVol>200000 AND ABS(e.MFI)>=0 AND e.marketCapM>300 AND e.price>1 ORDER BY “.$orderby;
while ($days>=100)
{
$days -=100;
$date = $edate;
$edate = date(“Y-m-d H:i:s”, strtotime(“+ 7 days”, strtotime($edate)));
$statement = “SELECT tick,erDate,sstk.price,sstk.marketCapM,e.avgChg as EstChg,erMove,e.MFI,e.cScore,e.lscore,e.trend, industry,topOwner,pctOwned, e.indexMember, optRate FROM erstks as e inner join sstk using (tick) WHERE erDate>=’$date’ AND erDate<'$edate' AND sstk.avgVol>200000 AND e.marketCapM>=300 AND e.price>1 ORDER BY (e.marketCapM) DESC”;
}
while ($days>=10)
{
$days -=10;
$date = $edate;
$edate = date(“Y-m-d H:i:s”, strtotime(“+ 1 days”, strtotime($edate)));
while (date(‘N’, strtotime($edate)) >= 6) $edate = getNextTradingdate($edate);
$statement = “SELECT tick,erDate,sstk.price,sstk.marketCapM,e.avgChg as EstChg,erMove ,e.MFI,e.cScore,e.lscore,e.trend, industry, e.indexMember, topOwner,pctOwned,optRate FROM erstks as e inner join sstk using (tick) WHERE erDate>=’$date’ AND erDate<'$edate' AND sstk.avgVol>200000 AND ABS(e.MFI)>=0 AND e.marketCapM>=300 AND e.price>1 ORDER BY erDate, (e.marketCapM) DESC”;
}
$hours =12;
While ($days >=1)
{
$date = $edate;
$edate = date(“Y-m-d H:i:s”, strtotime(“+ 12 hours”, strtotime($edate)));
while (date(‘N’, strtotime($edate)) >= 6) $edate = getNextTradingdate($edate);
$days -=1;
$statement = “SELECT tick,erDate,e.price,e.marketCapM,e.avgChg as EstChg,erMove ,e.MFI,e.cScore,e.lscore,e.trend, industry, e.indexMember, topOwner,pctOwned,optRate FROM erstks as e inner join sstk using (tick) WHERE erDate>=’$date’ AND erDate<'$edate' AND sstk.avgVol>200000 AND ABS(e.MFI)>=0 AND e.price>1 ORDER BY erDate, e.marketCapM DESC limit 99″;
}
while ($days<=-100)
{
$days +=100;
$edate = $date ;
$date = date("Y-m-d H:i:s", strtotime("- 7 days", strtotime($edate)));
$statement = "SELECT tick,erDate,sstk.price,sstk.marketCapM,e.avgChg as EstChg,erChange,openChg,erMove,e.MFI,e.cScore,e.lscore,e.trend, industry, e.indexMember, topOwner,pctOwned,optRate FROM erstks as e inner join sstk using (tick) WHERE erDate>=’$date’ AND erDate<'$edate' AND sstk.avgVol>200000 AND ABS(e.MFI)>=0 AND e.marketCapM>300 AND e.price>1 ORDER BY (erChange) DESC”;
}
While ($days <= - 10)
{
$edate = $date ;
$date = date("Y-m-d H:i:s", strtotime("- 24 hours", strtotime($edate)));
$days +=10;
$statement = "SELECT tick,erDate,e.price,e.marketCapM,e.erChange as result,e.avgChg as EstChg,erChange,openChg,erMove,e.MFI,e.cScore,e.lscore,e.trend, industry, e.indexMember, topOwner,pctOwned,optRate FROM erstks as e inner join sstk using (tick) WHERE erDate>=’$date’ AND erDate<'$edate' AND sstk.avgVol>200000 AND ABS(e.MFI)>=0 AND e.marketCapM>300 AND e.price>1 ORDER BY (e.avgChg) DESC”;
}
While ($days <= - 1)
{
$edate = $date ;
$date = date("Y-m-d H:i:s", strtotime("- 12 hours", strtotime($edate)));
$days +=1;
$statement = "SELECT tick,erDate,e.price,e.marketCapM,e.erChange as result,e.avgChg as EstChg,erChange,openChg,erMove,e.MFI,e.cScore,e.lscore,e.trend, industry, topOwner,pctOwned, e.indexMember,optRate FROM erstks as e inner join sstk using (tick) WHERE erDate>=’$date’ AND erDate<'$edate' AND sstk.avgVol>200000 AND ABS(e.MFI)>=0 AND e.marketCapM>300 AND e.price>1 ORDER BY (e.avgChg) DESC”;
}
if ($orderby)
{
if ($orderby == ‘price’ OR $orderby == ‘marketCapM’)
$orderby = $orderby.” desc”;
else
{
$myrand = rand ();
if ($myrand % 2 ==1)
$orderby = $orderby.” desc”;
}
}
else
{
// $orderby = ” abs(e.avgChg) DESC “;
$orderby = ‘ sstk.marketCapM Desc’ ;
}
if ($postedResult)
$statement = “SELECT tick,erDate,e.price,e.marketCapM,e.avgChg as EstChg,erMove as erRange,erChange,industry, sstk.indexMember, topOwner,pctOwned FROM erstks as e inner join sstk using (tick) WHERE sstk.indexMember like ‘%penny%’ and erDate>=’$date’ AND erDate<'$edate' and sstk.marketcapm>500 ORDER BY “.$orderby;
else
$statement = “SELECT tick,erDate,e.price,e.marketCapM,e.avgChg as EstChg,erMove as erRange,e.MFI,e.cScore as competitive,e.lscore as Value,e.trend as TA, industry, sstk.indexMember, topOwner,pctOwned FROM erstks as e inner join sstk using (tick) WHERE (sstk.indexMember like ‘%week%’ or sstk.indexMember like ‘%penny%’) and erDate>=’$date’ AND erDate<'$edate' and sstk.marketcapm>500 ORDER BY “.$orderby;
$conn = open_db();
//tick,price,pctChange,EPSNY,PEG,trend,MFI,vol,avgVol,erDate,marketCapM,floatM,score,lscore, shortRatio,shortScore,FA,institution,insider
//$statement = “SELECT erstks.*,sstk.sector, FROM sstk INNER JOIN erstks ON erstks.tick = sstk.tick WHERE “.$condition.” AND sstk.avgVol>200000 ORDER BY (erstks.score+erstks.lscore) DESC”;
//$statement = “SELECT sstk.*,erstks.erMove FROM sstk INNER JOIN erstks ON erstks.tick = sstk.tick WHERE “.$condition.” AND sstk.Vol10>200000 AND ABS(sstk.MFI)>=0 AND sstk.marketCapM>250 AND erstks.erMove>0 ORDER BY erstks.erDate, (sstk.lscore) DESC”;
//$statement = “SELECT sstk.*,erstks.erMove,erDate,erChange,avgChg,topOwner,pctOwned FROM sstk INNER JOIN erstks using (tick) WHERE erDate>=’$date’ AND erDate<'$edate' AND sstk.avgVol>300000 AND ABS(sstk.MFI)>=0 AND sstk.marketCapM>300 AND sstk.price>5 ORDER BY (e.avgChg) DESC”;
//echo $statement;
if (1)
{
$table =”ER List For Option Trader”.$date;
// $ret = queryDB($url,$statement, $table);
$table =”ER List Full “.$date;
if ($postedResult)
{
$tickerOnly = “SELECT tick FROM erstks as e inner join sstk using (tick) WHERE erDate>=’$date’ AND erDate<'$edate' and sstk.marketcapm>500 ORDER BY “.$orderby;
$statement = “SELECT tick as ticker,left(erDate,14)as ER_day,e.price,e.marketCapM,e.avgChg as EstChg,erMove as erRange,erChange,industry, topOwner,pctOwned， sstk.indexMember FROM erstks as e inner join sstk using (tick) WHERE erDate>=’$date’ AND erDate<'$edate' and sstk.marketcapm>500 ORDER BY “.$orderby;
}
else
{
$tickerOnly = “SELECT tick FROM erstks as e inner join sstk using (tick) WHERE erDate>=’$date’ AND erDate<'$edate' and sstk.marketcapm>500 ORDER BY “.$orderby;
$statement = “SELECT tick as ticker,left(erDate,14)as ER_day,e.price,e.marketCapM,e.avgChg as EstChg,erMove as erRange,e.MFI,e.cScore as competitive,e.lscore as Value,e.trend as TA, industry, topOwner,sstk.indexMember, pctOwned FROM erstks as e inner join sstk using (tick) WHERE erDate>=’$date’ AND erDate<'$edate' and sstk.marketcapm>500 ORDER BY “.$orderby;
}
$ret = chartTicker($url,$tickerOnly , $table);
$ret = queryDB($url,$statement, $table);
if ($ret ==0 )
{
$edate = date(“Y-m-d H:i:s”, strtotime(“+ 1 days”, strtotime($edate)));
$tickerOnly = “SELECT tick FROM erstks as e inner join sstk using (tick) WHERE erDate>=’$date’ AND erDate<'$edate' ORDER BY ".$orderby;
$ret = chartTicker($url,$tickerOnly , $table);
$statement = "SELECT tick as ticker,left(erDate,14)as ER_day,e.price,e.marketCapM,e.avgChg as EstChg,erMove as erRange,e.MFI,e.cScore as competitive,e.lscore as Value,e.trend as TA, industry, topOwner,e.indexMember, pctOwned FROM erstks as e inner join sstk using (tick) WHERE erDate>=’$date’ AND erDate<'$edate' ORDER BY ".$orderby;
$ret = queryDB($url,$statement, $table);
}
}
echo $days;
$conn->commit();
$conn->close();
?>