GOUSAK - The sky is... NOT the limit
DATE_SUB(CURDATE(),INTERVAL 30 DAY)"; $mres = mysql_query($msql); $mrow = mysql_fetch_array($mres); if(isset($mrow)) { $iFrom = strtotime($mrow['minDate']); $iTo = strtotime($mrow['maxDate']); $aData = getYahooHistoryData($sTicker,date('m',$iFrom),date('d',$iFrom),date('Y',$iFrom),date('m',$iTo),date('d',$iTo),date('Y',$iTo)); } $dsql = "SELECT * FROM gi_stock WHERE date>DATE_SUB(CURDATE(),INTERVAL 30 DAY) GROUP BY date ORDER BY date ASC LIMIT 30"; $dres = mysql_query($dsql); $iDN = 0; $iDP = 0; $iD = 0; $sPrBefore = 0; $bChange = false; while($drow = mysql_fetch_array($dres,MYSQL_ASSOC)) { /*$sRecTimeStamp = strtotime($drow['date']); $sRecDate = date('m',$sRecTimeStamp).'%2F'.date('d',$sRecTimeStamp).'%2F'.str_replace('20','',date('Y',$sRecTimeStamp));*/ if($sPrBefore==0) { //????? ???????? close ?????????? ??? ? ????????? ??? ????? if(isset($aData[$drow['date']])) { $sPrBefore = $aData[$drow['date']]['close']; continue; } } $chsql = 'SELECT count(*) as recCount FROM gi_stock WHERE `date`="'.$drow['date'].'" and keyword="'.addslashes($sTicker).'"'; $chres = mysql_query($chsql); $chrow = mysql_fetch_array($chres); if(isset($chrow['recCount'])&&($chrow['recCount']==0)) { $sTimeStamp = strtotime($drow['date']); $fValue = 0; if(isset($aData[$drow['date']])) { $aKeys = array_keys($aData[$drow['date']]); foreach($aKeys as $key=>$val) { $aData[$drow['date']][$val] = str_replace(',','',$aData[$drow['date']][$val]); } } /* $url = 'http://bigcharts.marketwatch.com/historical/default.asp?symb='.strtolower($sTicker).'&closeDate='.date('m',$sTimeStamp).'%2F'.date('d',$sTimeStamp).'%2F'.date('Y',$sTimeStamp).'&x=0&y=0'; $result = download($url); preg_match("/Closing Price:<\/th>(.*?)(.*?)<\/td>/",$result,$aValue); $sClose = getValue("Closing Price:<\/th> (.*?)<\/td>",$result); $sOpen = getValue("Open:<\/th> (.*?)<\/td>",$result); $sHigh = getValue("High:<\/th> (.*?)<\/td>",$result); $sLow = getValue("Low:<\/th> (.*?)<\/td>",$result); $sVolume = str_replace(',','',getValue("Volume:<\/th> (.*?)<\/td>",$result));*/ $sClose = $aData[$drow['date']]['close']; $sOpen = $aData[$drow['date']]['open']; $sHigh = $aData[$drow['date']]['high']; $sLow = $aData[$drow['date']]['low']; $sVolume= $aData[$drow['date']]['volume']; $fValue = $aData[$drow['date']]['close']; /*if(isset($aValue)) { $fValue = (float)str_replace(',','',$aValue[2]); }*/ $fPr = (($fValue*100)/$sPrBefore)-100; $sPrBefore = $fValue; if($fPr<0) { $iDN++; $iDP=0; } if($fPr>0) { $iDP++; $iDN=0; } if($fValue!=0) { $isql = 'INSERT INTO gi_stock SET '; $isql .= 'tid='.$iTickerID.','; $isql .= 'pr="'.$fPr.'",'; $isql .= 'position="'.$fValue.'",'; $isql .= 'open="'.addslashes($sOpen).'",'; $isql .= 'close="'.addslashes($sClose).'",'; $isql .= 'high="'.addslashes($sHigh).'",'; $isql .= 'low="'.addslashes($sLow).'",'; $isql .= 'volume="'.addslashes($sVolume).'", '; $isql .= '`date`="'.$drow['date'].'",'; $isql .= 'keyword="'.addslashes($sTicker).'"'; mysql_query($isql); } } } ConsecutiveLosses($sTicker); $tsql = 'SELECT max( date ) as maxDate FROM `gi_stock`'; $tres = mysql_query($tsql); $trow = mysql_fetch_array($tres); $fK = getStohastK($sTicker,$trow['maxDate']); $fD = getStohastD($sTicker,$trow['maxDate']); $fRSI = getRSI($sTicker,$trow['maxDate']); $usql = 'UPDATE `gi_tickers` SET rsi="'.$fRSI.'",stock="'.$fK.'" WHERE ticker="'.$sTicker.'"'; mysql_query($usql); } else { getTickerInfo($sTicker, $chrow['id'], 'update'); $uchsql = 'SELECT count(*) as recCount FROM gi_u_tickers WHERE uid="'.addslashes($sUserID).'" and tid='.(int)$chrow['id']; $ucsres = mysql_query($uchsql); $uchrow = mysql_fetch_array($ucsres); if(isset($uchrow['recCount'])&&($uchrow['recCount']==0)) { $isql = 'INSERT INTO gi_u_tickers SET uid="'.addslashes($sUserID).'",tid='.$chrow['id'].',ip="'.$_SERVER['REMOTE_ADDR'].'"'; mysql_query($isql); } } } //get shadow script header("Location: http://gousak.com"); getTickerInShadowMode($sTicker,$aData); //getPage( "http://gousak.com/get_ticker_in_shadow_mode.php?ticker=".$sTicker,'CURL','',false,1,1); break; } ?> DATE_SUB(CURDATE(),INTERVAL 30 DAY) '); $sql = "SELECT * FROM gi_stock $sWhere GROUP BY date"; $res = mysql_query($sql); ob_start(); $iTickerCount = 0; $iColspnCount = 6; while($row = mysql_fetch_array($res,MYSQL_ASSOC)) { $aDates[] = $row["date"]; $sDateStamp = strtotime($row["date"]); ?>07.09 =5000000000 and a.marketcap<=10000000000 ORDER BY ".$sOrderBy; break; case'10001': $sql = "SELECT * FROM gi_tickers as a WHERE a.marketcap>=10000000000 and a.marketcap<=25000000000 ORDER BY ".$sOrderBy; break; case'10002': $sql = "SELECT * FROM gi_tickers as a WHERE a.marketcap>25000000000 ORDER BY ".$sOrderBy; break; case'10003': $sql = "SELECT * FROM gi_tickers as a WHERE a.debt_cash=0 ORDER BY ".$sOrderBy; break; case'10004': $sql = "SELECT * FROM gi_tickers as a WHERE a.gn_pps>1 ORDER BY ".$sOrderBy; break; case'10005': $sql = "SELECT * FROM gi_tickers as a WHERE a.peg<1 and a.peg>0 ORDER BY ".$sOrderBy; break; case'10006': $sql = "SELECT * FROM gi_tickers as a WHERE a.rsi<=30 ORDER BY ".$sOrderBy; break; case'10007': $sql = "SELECT * FROM gi_tickers as a WHERE a.stoh_K<=20 ORDER BY ".$sOrderBy; break; case'10008': $sql = "SELECT * FROM gi_tickers as a ORDER BY ".$sOrderBy; break; default: $sql = "SELECT * FROM gi_tickers as a WHERE a.sid=".(int)$iSID." ORDER BY ".$sOrderBy; break; } ob_start(); $res = mysql_query($sql); $iCounter = 1; $PrevId = 0; $aRows = array(); while($row = mysql_fetch_array($res,MYSQL_ASSOC)) { $aRows[] = $row; } $iC = 0; foreach($aRows as $row) { $sPrefix = ($iCounter%2==0?'odd':'even'); $sDarkPrefix = ''; if((isset($_COOKIE['selected']))&&(isset($aRows[$iC+1])&&('tr'.$aRows[$iC+1]['id']==$_COOKIE['selected']))) { $sDarkPrefix = 'dark-tr'; } $iC++; ?>
Add:
# Ticker Cap IO% PPS RPS R/P GN G/P rsi stoch PEG D/C
. X