function masterLoop()
{
require '../includes/connect.php';
$mainTickerSQL = "SELECT * FROM tickers";
$ticker_result = mysqli_query($connect, $mainTickerSQL);
while ($row = mysqli_fetch_array($ticker_result)) {
$ticker = $row['ticker'];
$nextDayIncrease = 0;
$nextDayDecrease = 0;
$nextDayNoChange = 0;
$sumOfIncreases = 0;
$sumOfDecreases = 0;
$total = 0;
require '../includes/connect.php';
$sql = "SELECT date, amount_change, percent_change FROM {$ticker}";
//WHERE percent_change < '0' ORDER BY date AS ASC";
$data = mysqli_query($connect, $sql);
if ($data) {
while ($row = mysqli_fetch_array($data)) {
$date = $row['date'];
$percent_change = $row['percent_change'];
$sql2 = "SELECT date, percent_change FROM {$ticker} WHERE date > {$date} ORDER BY date ASC LIMIT 1";
$data2 = mysqli_query($connect, $sql2);
$numberOfRows = mysqli_num_rows($data2);
if ($numberOfRows == 1) {
$row2 = mysqli_fetch_row($data2);
$tom_date = $row2[0];
$tom_percent_change = $row[1];
if ($tom_percent_change > 0) {
$nextDayIncrease++;
$sumOfIncreases += $tom_percent_change;
$total++;
} elseif ($tom_percent_change < 0) {
$nextDayDecrease++;
$sumOfDecreases += $tom_percent_change;
$total++;
} else {
$nextDayNoChange++;
$total = 0;
$total++;
}
} elseif ($numberOfRows == 0) {
//no more data after today
} else {
echo "you have an error in analysis_a";
}
}
} else {
echo "unable to select blah {$ticker} <br />" . mysqli_error($connect);
//we are ending up here
}
$nextDayIncreasePercent = $nextDayIncrease / $total * 100;
$nextDayDecreasePercent = $nextDayDecrease / $total * 100;
$averageIncreasePercent = $nextDayIncreasePercent / $nextDayIncrease;
$averageDecreasePercent = $sumOfDecreases / $nextDayDecrease;
insertIntoResultTable($ticker, $nextDayIncrease, $nextDayIncreasePercent, $averageIncreasePercent, $nextDayDecrease, $nextDayDecreasePercent, $averageDecreasePercent);
header('Location: ../dashboard.php');
}
}
function masterLoop()
{
$mainTickerFile = fopen("tickerMaster.txt", "r");
while (!feof($mainTickerFile)) {
$companyTicker = fgets($mainTickerFile);
$comapnyTicker = trim($companyTicker);
$nextDayIncrease = 0;
$nextDayDecrease = 0;
$nextDayNoChange = 0;
$totalDays = 0;
$sumOfIncreases = 0;
$sumOfDecreases = 0;
$sql = "SELECT date, percent_change FROM {$companyTicker} WHERE percent_change < '0' ORDER BY date ASC";
$result = mysql_query($sql);
if ($result) {
while ($row = mysql_fetch_array($result)) {
$date = $row['date'];
$percentChange = $row['percent_change'];
$sql2 = "SELECT date, percent_change FROM {$companyTicker} WHERE date > '{$date}' ORDER BY date ASC LIMIT 1";
$result2 = mqsql_query($sql2);
$numberOfRows = mysql_num_rows($result2);
if ($numberOfRows == 1) {
$row2 = mysql_fetch_row($result2);
$tomorrowDate = $row2[0];
$tomorrowPercentChange = $row2[1];
if ($tomorrowPercentChange > 0) {
$nextDayIncrease++;
$sumOfIncreases += $tomorrowPercentChange;
$total++;
} else {
if ($tomorrowPercentChange < 0) {
$nextDayDecrease++;
$sumOfDecreases += $tomorrowPercentChange;
$total++;
} else {
$nextDayNoChange++;
$total++;
}
}
} else {
if ($numberOfRows == 0) {
//no data after today
} else {
echo "You have an error in analysis_a";
}
}
}
} else {
echo "Unable to select {$companyTicker} <br />";
}
$nextDayIncreasePercent = $nextDayIncrease / $total * 100;
$nextDayDecreasePercent = $nextDayDecrease / $total * 100;
$averageIncreasePercent = $sumOfIncreases / $nextDayIncrease;
$averageDecreasePercent = $sumOfIncreases / $nextDayDecrease;
insertIntoResultTable();
}
}
function masterLoop()
{
$user = $_SESSION['username'];
require '../includes/connect.php';
require '../includes/connect.php';
$table_sql = "CREATE TABLE IF NOT EXISTS {$user}analysis_a (\n ticker VARCHAR(8),\n daysInc INTEGER,\n pctOfDaysInc FLOAT,\n avgIncPct FLOAT,\n daysDec INTEGER,\n pctOfDaysDec FLOAT,\n avgDecPct FLOAT,\n BuyValue FLOAT,\n SellValue FLOAT\n )";
$table = mysqli_query($connect, $table_sql);
if (!$table) {
echo 'cant create table' . mysqli_error($connect);
}
$mainTickerSQL = "SELECT ticker FROM {$user}tickers";
$ticker_result = mysqli_query($connect, $mainTickerSQL);
if (!$ticker_result) {
echo mysql_error();
echo "here 1";
return false;
}
while ($row = mysqli_fetch_array($ticker_result)) {
$ticker = $row['ticker'];
$nextDayIncrease = 0;
$nextDayDecrease = 0;
$nextDayNoChange = 0;
$sumOfIncreases = 0;
$sumOfDecreases = 0;
$total = 0;
require '../includes/connect.php';
$sql = "SELECT date, amount_change, percent_change FROM {$ticker}";
//WHERE percent_change < '0' ORDER BY date AS ASC";
$data = mysqli_query($connect, $sql);
if ($data) {
while ($row = mysqli_fetch_array($data)) {
$date = $row['date'];
$percent_change = $row['percent_change'];
$sql2 = "SELECT date, percent_change FROM {$ticker} WHERE date > {$date} ORDER BY date ASC LIMIT 1";
$data2 = mysqli_query($connect, $sql2);
$numberOfRows = mysqli_num_rows($data2);
if ($numberOfRows == 1) {
$row2 = mysqli_fetch_row($data2);
$tom_date = $row2[0];
$tom_percent_change = $row[1];
if ($tom_percent_change > 0) {
$nextDayIncrease++;
$sumOfIncreases += $tom_percent_change;
$total++;
} elseif ($tom_percent_change < 0) {
$nextDayDecrease++;
$sumOfDecreases += $tom_percent_change;
$total++;
} else {
$nextDayNoChange++;
$total = 0;
$total++;
}
} elseif ($numberOfRows == 0) {
//no more data after today
} else {
echo "you have an error in analysis_a";
}
}
} else {
echo "unable to select blah {$ticker} <br />" . mysqli_error($connect);
//we are ending up here
}
$nextDayIncreasePercent = $nextDayIncrease / $total * 100;
$nextDayDecreasePercent = $nextDayDecrease / $total * 100;
$averageIncreasePercent = $nextDayIncreasePercent / $nextDayIncrease;
$averageDecreasePercent = $sumOfDecreases / $nextDayDecrease;
insertIntoResultTable($ticker, $nextDayIncrease, $nextDayIncreasePercent, $averageIncreasePercent, $nextDayDecrease, $nextDayDecreasePercent, $averageDecreasePercent);
header('Location: ../dashboard.php');
}
}
function masterLoop()
{
require '../includes/connect.php';
$table_sql = "CREATE TABLE IF NOT EXISTS api (\n ticker VARCHAR(8),\n avgPrice FLOAT,\n lavgPrice FLOAT,\n l1avgPrice FLOAT,\n l6avgPrice FLOAT,\n predPrice FLOAT,\n BuyValue FLOAT,\n SellValue FLOAT\n )";
$table = mysqli_query($connect, $table_sql);
if (!$table) {
echo 'cant create table' . mysqli_error($connect);
}
$ticker = $_GET['ticker'];
$ticker = strtoupper($ticker);
$nextDayIncrease = 0;
$nextDayDecrease = 0;
$nextDayNoChange = 0;
$sumOfIncreases = 0;
$sumOfDecreases = 0;
$total = 0;
$ltotal = 0;
$sql = "SELECT date, open, close, high, low FROM {$ticker}";
//WHERE percent_change < '0' ORDER BY date AS ASC";
$data = mysqli_query($connect, $sql);
if ($data) {
//get formated current date
require '../includes/dates.php';
$lastYear = $curYear - 1;
$sixmonthsAgo = $rcurMonth - 6;
$oneMonthAgo = $rcurMonth - 1;
$elevenMonths = $rcurMonth + 11;
if ($rcurMonth > 6) {
$sixmonthsAgo = $rcurMonth - 6;
if ($rcurMonth < 10) {
if ($curDay < 10) {
$curDate = "{$curYear}-0{$rcurMonth}-0{$curDay}";
$lastYearD = "{$lastYear}-0{$rcurMonth}-0{$curDay}";
$last6YearD = "{$lastYear}-0{$sixmonthsAgo}-0{$curDay}";
if ($rcurMonth > 1) {
$last1YearD = "{$curYear}-0{$oneMonthAgo}-0{$curDay}";
} else {
$last1YearD = "{$lastYear}-0{$elevenMonths}-0{$curDay}";
}
} else {
$curDate = "{$curYear}-0{$rcurMonth}-{$curDay}";
$lastYearD = "{$lastYear}-0{$rcurMonth}-{$curDay}";
$last6YearD = "{$lastYear}-0{$sixmonthsAgo}-{$curDay}";
if ($rcurMonth > 1) {
$last1YearD = "{$curYear}-0{$oneMonthAgo}-{$curDay}";
} else {
$last1YearD = "{$lastYear}-0{$elevenMonths}-{$curDay}";
}
}
} else {
if ($curDay < 10) {
$curDate = "{$curYear}-{$rcurMonth}-0{$curDay}";
$lastYearD = "{$lastYear}-{$rcurMonth}-0{$curDay}";
$last6YearD = "{$lastYear}-{$sixmonthsAgo}-0{$curDay}";
if ($rcurMonth > 1) {
$last1YearD = "{$curYear}-{$oneMonthAgo}-0{$curDay}";
} else {
$last1YearD = "{$lastYear}-{$elevenMonths}-0{$curDay}";
}
} else {
$curDate = "{$curYear}-{$rcurMonth}-{$curDay}";
$lastYearD = "{$lastYear}-{$rcurMonth}-{$curDay}";
$last6YearD = "{$lastYear}-{$sixmonthsAgo}-{$curDay}";
if ($rcurMonth > 1) {
$last1YearD = "{$curYear}-{$oneMonthAgo}-{$curDay}";
} else {
$last1YearD = "{$lastYear}-{$elevenMonths}-{$curDay}";
}
}
}
} else {
$sixmonthsAgo = $rcurMonth + 6;
$lastYear = $lastYear - 1;
if ($rcurMonth < 10) {
if ($curDay < 10) {
$curDate = "{$curYear}-0{$rcurMonth}-0{$curDay}";
$lastYearD = "{$lastYear}-0{$rcurMonth}-0{$curDay}";
$last6YearD = "{$lastYear}-0{$sixmonthsAgo}-0{$curDay}";
if ($rcurMonth > 1) {
$last1YearD = "{$curYear}-0{$oneMonthAgo}-0{$curDay}";
} else {
$last1YearD = "{$lastYear}-0{$elevenMonths}-0{$curDay}";
}
} else {
$curDate = "{$curYear}-0{$rcurMonth}-{$curDay}";
$lastYearD = "{$lastYear}-0{$rcurMonth}-{$curDay}";
$last6YearD = "{$lastYear}-0{$sixmonthsAgo}-{$curDay}";
if ($rcurMonth > 1) {
$last1YearD = "{$curYear}-0{$oneMonthAgo}-{$curDay}";
} else {
$last1YearD = "{$lastYear}-0{$elevenMonths}-{$curDay}";
}
}
} else {
if ($curDay < 10) {
$curDate = "{$curYear}-{$rcurMonth}-0{$curDay}";
$lastYearD = "{$lastYear}-{$rcurMonth}-0{$curDay}";
$last6YearD = "{$lastYear}-{$sixmonthsAgo}-0{$curDay}";
if ($rcurMonth > 1) {
$last1YearD = "{$curYear}-{$oneMonthAgo}-0{$curDay}";
} else {
$last1YearD = "{$lastYear}-{$elevenMonths}-0{$curDay}";
}
} else {
$curDate = "{$curYear}-{$rcurMonth}-{$curDay}";
$lastYearD = "{$lastYear}-{$rcurMonth}-{$curDay}";
$last6YearD = "{$lastYear}-{$sixmonthsAgo}-{$curDay}";
if ($rcurMonth > 1) {
$last1YearD = "{$curYear}-{$oneMonthAgo}-{$curDay}";
} else {
$last1YearD = "{$lastYear}-{$elevenMonths}-{$curDay}";
}
}
}
}
//end of get formatted date
$l_sql = "SELECT SUM(open), SUM(close), SUM(high), SUM(low) FROM {$ticker} WHERE date > '{$lastYearD}'";
$l_res = mysqli_query($connect, $l_sql);
if (!$l_res) {
echo "this prolem";
}
$row3 = mysqli_fetch_row($l_res);
$all_sql = "SELECT * FROM {$ticker} WHERE date > '{$lastYearD}'";
$row_q = mysqli_query($connect, $all_sql);
$numRows1 = mysqli_num_rows($row_q);
$lopen = $row3[0];
$lclose = $row3[1];
$lhigh = $row3[2];
$llow = $row3[3];
$lavgPriceLow = $llow / $numRows1;
$lavgPrice = ($lhigh + $llow) / ($numRows1 * 2);
//get last 6 month info
$l6_sql = "SELECT SUM(open), SUM(close), SUM(high), SUM(low) FROM {$ticker} WHERE date >= (now() - interval 6 month)";
$l6_res = mysqli_query($connect, $l6_sql);
if (!$l_res) {
echo "this prolem";
}
$row6 = mysqli_fetch_row($l6_res);
$all_sql6 = "SELECT * FROM {$ticker} WHERE date >= (now() - interval 6 month)";
$row_q6 = mysqli_query($connect, $all_sql6);
$numRows161 = mysqli_num_rows($row_q6);
$lopen6 = $row6[0];
$lclose6 = $row6[1];
$lhigh6 = $row6[2];
$llow6 = $row6[3];
$l6avgPriceLow = $llow6 / $numRows161;
$l6avgPrice = ($lhigh6 + $llow6) / ($numRows161 * 2);
//get last year info
$l1_sql = "SELECT SUM(open), SUM(close), SUM(high), SUM(low) FROM {$ticker} WHERE date >= '{$last1YearD}'";
$l1_res = mysqli_query($connect, $l1_sql);
if (!$l1_res) {
echo "this prolem";
}
$row1 = mysqli_fetch_row($l1_res);
$all_sql1 = "SELECT * FROM {$ticker} WHERE date > '{$last1YearD}'";
$row_q1 = mysqli_query($connect, $all_sql1);
$numRows11 = mysqli_num_rows($row_q1);
$l1open = $row1[0];
$l1close = $row1[1];
$l1high = $row1[2];
$l1low = $row1[3];
$l1avgPriceLow = $l1low / $numRows11;
$l1avgPrice = ($l1high + $l1low) / ($numRows11 * 2);
$a_sql = "SELECT SUM(open), SUM(close), SUM(high), SUM(low) FROM {$ticker}";
$a_res = mysqli_query($connect, $a_sql);
if (!$a_res) {
echo "this prolem";
}
$rowa = mysqli_fetch_row($a_res);
$all_sqla = "SELECT * FROM {$ticker}";
$row_qa = mysqli_query($connect, $all_sqla);
$numRowsa = mysqli_num_rows($row_qa);
$aopen = $rowa[0];
$aclose = $rowa[1];
$a1high = $rowa[2];
$a1low = $rowa[3];
$avgPriceLow = $alow / $numRowsa;
$avgPrice = ($a1high + $a1low) / ($numRowsa * 2);
//loop through data
while ($row = mysqli_fetch_array($data)) {
//all analytics in here
//deep buy analysis
$date = $row['date'];
$open = $row[2];
$close = $row[3];
$high = $row[4];
$low = $row[5];
$percent_change = $row['percent_change'];
$sql2 = "SELECT date FROM {$ticker} WHERE date > {$date} ORDER BY date ASC LIMIT 1";
$data2 = mysqli_query($connect, $sql2);
$numberOfRows = mysqli_num_rows($data2);
if ($numberOfRows == 1) {
//all analytics in here
//deep buy analysis
$row2 = mysqli_fetch_row($data2);
$Buy = 1;
$Sell = 0;
$tom_date = $row2[0];
$tom_percent_change = $row[1];
if ($tom_percent_change > 0) {
$nextDayIncrease++;
$sumOfIncreases += $tom_percent_change;
$total++;
} elseif ($tom_percent_change < 0) {
$total++;
$nextDayDecrease++;
$sumOfDecreases += $tom_percent_change;
$total++;
} else {
$nextDayNoChange++;
$total = 0;
$total++;
}
} elseif ($numberOfRows == 0) {
//no more data after today
} else {
echo "you have an error in api";
}
//if buy = 1 buy = yes and so on
}
//end of loop
} else {
echo "unable to select blah {$ticker} <br />" . mysqli_error($connect);
//we are ending up here
}
$predPrice = ($l6avgPriceLow + $l1avgPriceLow) / 2;
$currPrice = getRTQoute($ticker);
if ($avgPrice < $currPrice && $avgPrice < $l1avgPrice) {
if ($currPrice > $avgPrice && $predPrice > $currPrice) {
$BuyValue = 1;
}
if ($predPrice > $currPrice) {
$BuyValue = 1;
} else {
$BuyValue = 0;
}
} else {
$BuyValue = 0;
}
$SellValue = $predPrice / $currPrice;
$test = 237872;
insertIntoResultTable($ticker, $avgPrice, $lavgPrice, $l1avgPrice, $l6avgPrice, $BuyValue, $SellValue, $predPrice);
}
function masterLoop()
{
require '../includes/connect.php';
$table_sql = "CREATE TABLE IF NOT EXISTS analysis_a (\n ticker VARCHAR(8),\n daysInc INTEGER,\n pctOfDaysInc FLOAT,\n avgIncPct FLOAT,\n daysDec float,\n pctOfDaysDec FLOAT,\n avgDecPct FLOAT,\n BuyValue FLOAT,\n SellValue FLOAT\n )";
$table = mysqli_query($connect, $table_sql);
if (!$table) {
echo 'cant create table' . mysqli_error($connect);
}
$ticker = $_GET['ticker'];
$nextDayIncrease = 0;
$nextDayDecrease = 0;
$nextDayNoChange = 0;
$sumOfIncreases = 0;
$sumOfDecreases = 0;
$total = 0;
$ltotal = 0;
$sql = "SELECT date, amount_change, percent_change, open, close, high, low FROM {$ticker}";
//WHERE percent_change < '0' ORDER BY date AS ASC";
$data = mysqli_query($connect, $sql);
if ($data) {
//get formated current date
require '../includes/dates.php';
$lastYear = $curYear - 1;
if ($rcurMonth < 10) {
if ($curDay < 10) {
$curDate = "{$curYear}-0{$rcurMonth}-0{$curDay}";
$lastYearD = "{$lastYear}-0{$rcurMonth}-0{$curDay}";
} else {
$curDate = "{$curYear}-0{$rcurMonth}-{$curDay}";
$lastYearD = "{$lastYear}-0{$rcurMonth}-{$curDay}";
}
} else {
if ($curDay < 10) {
$curDate = "{$curYear}-{$rcurMonth}-0{$curDay}";
$lastYearD = "{$lastYear}-{$rcurMonth}-0{$curDay}";
} else {
$curDate = "{$curYear}-{$rcurMonth}-{$curDay}";
$lastYearD = "{$lastYear}-{$rcurMonth}-{$curDay}";
}
}
//end of get formatted date
$l_sql = "SELECT open, close, high, low FROM {$ticker} WHERE date > '{$lastYearD}'";
$l_res = mysqli_query($connect, $l_sql);
if (!$l_res) {
echo "this prolem";
}
while ($row3 = mysqli_fetch_array($l_res)) {
$lopen = $row3[0];
$lclose = $row3[1];
$lhigh = $row3[2];
$llow = $row3[3];
$ltotal++;
}
$avgPrice = 0;
$lavgPrice1 = 0;
//loop through data
while ($row = mysqli_fetch_array($data)) {
//all analytics in here
//deep buy analysis
$date = $row['date'];
$open = $row[2];
$close = $row[3];
$high = $row[4];
$low = $row[5];
$percent_change = $row['percent_change'];
$sql2 = "SELECT date, percent_change FROM {$ticker} WHERE date > {$date} ORDER BY date ASC LIMIT 1";
$data2 = mysqli_query($connect, $sql2);
$numberOfRows = mysqli_num_rows($data2);
$avgPrice = $open + $close + $high + $low;
if ($numberOfRows == 1) {
//all analytics in here
//deep buy analysis
$row2 = mysqli_fetch_row($data2);
$Buy = 1;
$Sell = 0;
$tom_date = $row2[0];
$tom_percent_change = $row[1];
if ($tom_percent_change > 0) {
$nextDayIncrease++;
$sumOfIncreases += $tom_percent_change;
$total++;
} elseif ($tom_percent_change < 0) {
$total++;
$nextDayDecrease++;
$sumOfDecreases += $tom_percent_change;
$total++;
} else {
$nextDayNoChange++;
$total = 0;
$total++;
}
} elseif ($numberOfRows == 0) {
//no more data after today
} else {
echo "you have an error in analysis_a";
}
//if buy = 1 buy = yes and so on
}
//end of loop
} else {
echo "unable to select blah {$ticker} <br />" . mysqli_error($connect);
//we are ending up here
}
$nextDayIncreasePercent = $nextDayIncrease / $total * 100;
$nextDayDecreasePercent = $nextDayDecrease / $total * 100;
$lavgPrice1 = $lopen + $lclose + $lhigh + $llow;
$averageIncreasePercent = 0;
$averageDecreasePercent = 0;
$BuyValue = $Buy;
$SellValue = $Sell;
$avgPrice = $avgPrice / $total;
$lavgPrice = $lavgPrice1 / $ltotal;
insertIntoResultTable($ticker, $nextDayIncrease, $nextDayIncreasePercent, $avgPrice, $nextDayDecrease, $nextDayDecreasePercent, $averageDecreasePercent, $BuyValue, $SellValue);
}
