$cmiWeight = 0; $rsiWeight = 0; if (mysql_query($sql)) { while ($row = mysql_fetch_array($resultSet)) { $tp = $row['TP']; $dma_5 = $row['DMA_5']; $dma_10 = $row['DMA_10']; $dma_20 = $row['DMA_20']; $dma_50 = $row['DMA_50']; $dma_100 = $row['DMA_100']; $rsi = $row['RSI']; $so = $row['SO']; $cmi = $row['CMI']; $close = $row['close']; $id = $row['id']; $nextDayClose = getNextClose($id); if ($nextDayClose != -1) { if ($nextDayClose > $close) { if (strcmp($tp, $BUY) == 0) { $tpWeight++; } if (strcmp($tp, $DN) == 0) { } if (strcmp($dma_5, $BUY) == 0) { $dma_5Weight++; } if (strcmp($dma_5, $DN) == 0) { } if (strcmp($dma_10, $BUY) == 0) { $dma_10Weight++; }
function calculateWeights($tableName) { //echo $tableName . "<br>"; global $tpWeight, $dma_5Weight, $dma_10Weight, $dma_20Weight, $dma_50Weight, $dma_100Weight, $soWeight, $rsiWeight, $cmiWeight, $startDate, $BUY, $SELL, $DN, $rowCounter; $sql = "SELECT * FROM {$tableName} WHERE date > '{$startDate}'"; $resultSet = $result = mysql_query($sql); if (mysql_query($sql)) { while ($row = mysql_fetch_array($resultSet)) { $rowCounter++; $tp = $row['TP']; $dma_5 = $row['DMA_5']; $dma_10 = $row['DMA_10']; $dma_20 = $row['DMA_20']; $dma_50 = $row['DMA_50']; $dma_100 = $row['DMA_100']; $rsi = $row['RSI']; $so = $row['SO']; $cmi = $row['CMI']; $close = $row['close']; $id = $row['id']; $nextDayClose = getNextClose($id, $tableName); //echo $tableName . " " . $id . " " .$close . " " . $nextDayClose . "<br>"; if ($nextDayClose != -1) { if ($nextDayClose > $close) { if (strcmp($tp, $BUY) == 0) { $tpWeight++; } if (strcmp($tp, $DN) == 0) { } if (strcmp($dma_5, $BUY) == 0) { $dma_5Weight++; } if (strcmp($dma_5, $DN) == 0) { } if (strcmp($dma_10, $BUY) == 0) { $dma_10Weight++; } if (strcmp($dma_10, $DN) == 0) { } if (strcmp($dma_20, $BUY) == 0) { $dma_20Weight++; } if (strcmp($dma_20, $DN) == 0) { } if (strcmp($dma_50, $BUY) == 0) { $dma_50Weight++; } if (strcmp($dma_50, $DN) == 0) { } if (strcmp($dma_100, $BUY) == 0) { $dma_100Weight++; } if (strcmp($dma_100, $DN) == 0) { } if (strcmp($rsi, $DN) == 0) { } if (strcmp($rsi, $BUY) == 0) { $rsiWeight++; } if (strcmp($rsi, $SELL) == 0) { $rsiWeight--; } if (strcmp($cmi, $SELL) == 0) { $cmiWeight--; } if (strcmp($cmi, $BUY) == 0) { $cmiWeight++; } if (strcmp($cmi, $DN) == 0) { } if (strcmp($so, $DN) == 0) { } if (strcmp($so, $BUY) == 0) { $soWeight++; } if (strcmp($so, $SELL) == 0) { $soWeight--; } } else { if ($close > $nextDayClose) { if (strcmp($tp, $BUY) == 0) { $tpWeight--; } if (strcmp($tp, $DN) == 0) { } if (strcmp($dma_5, $BUY) == 0) { $dma_5Weight--; } if (strcmp($dma_5, $DN) == 0) { /*$dma_5Weight++;*/ } if (strcmp($dma_10, $BUY) == 0) { $dma_10Weight--; } if (strcmp($dma_10, $DN) == 0) { /*$dma_10Weight++;*/ } if (strcmp($dma_20, $BUY) == 0) { $dma_20Weight--; } if (strcmp($dma_20, $DN) == 0) { /*$dma_20Weight++;*/ } if (strcmp($dma_50, $BUY) == 0) { $dma_50Weight--; } if (strcmp($dma_50, $DN) == 0) { /*$dma_50Weight++;*/ } if (strcmp($dma_100, $BUY) == 0) { $dma_100Weight--; } if (strcmp($dma_100, $DN) == 0) { /*$dma_100Weight++;*/ } if (strcmp($rsi, $DN) == 0) { } if (strcmp($rsi, $BUY) == 0) { $rsiWeight--; } if (strcmp($rsi, $SELL) == 0) { $rsiWeight++; } if (strcmp($cmi, $SELL) == 0) { $cmiWeight++; } if (strcmp($cmi, $BUY) == 0) { $cmiWeight--; } if (strcmp($cmi, $DN) == 0) { } if (strcmp($so, $DN) == 0) { } if (strcmp($so, $BUY) == 0) { $soWeight--; } if (strcmp($so, $SELL) == 0) { $soWeight++; } } } } } } }