function processPullbacks()
{
$watches = new watchlist();
$watches->set_variable("watchlist_tradetype", PULLBACK_TRADE);
while ($watches->loadNext()) {
$tId = $watches->get_variable("watchlist_ticker_id");
$wId = $watches->get_variable("watchlist_id");
$calcHigh = $watches->get_variable("watchlist_high");
$calcLow = $watches->get_variable("watchlist_low");
$ticker = new ticker();
$ticker->set_variable("ticker_id", $tId);
if ($ticker->load()) {
$dayHigh = $ticker->get_variable("today_high");
$symbol = strtoupper($ticker->get_variable("ticker_symbol"));
echo "Testing " . $symbol . " PrevHigh=" . $calcHigh . " DayHigh=" . $dayHigh . "<br>\n";
if ($dayHigh > $calcHigh) {
echo " RECALC AND HIGHLIGHTING\n<br>";
$className = adminControlWatchlist::GetWatchClassName(PULLBACK_TRADE);
$watchlistAdmin = new $className($wId);
$watchlistAdmin->Edit($calcLow, $dayHigh);
// highlight the abandon price
highlights::watchlistHighlight($wId, W_ENTRY_ZONE, 0, highlights::EVENT_START_DAY);
}
}
}
}
require_once 'php/db_interface/autoload.php';
$login = new login(true);
if (isset($_GET['edit_id'])) {
$watchlistId = intval($_GET['edit_id']);
} else {
if (isset($_POST['watchlist_id'])) {
$watchlistId = intval($_POST['watchlist_id']);
} else {
if (isset($_GET['zone_id'])) {
$watchlistId = intval($_GET['zone_id']);
} else {
header('Location: admin.editall.php');
}
}
}
$watchlistItem = new watchlist();
$watchlistItem->set_variable('watchlist_id', $watchlistId);
if ($watchlistItem->load()) {
$tradeType = $watchlistItem->get_variable('watchlist_tradetype');
}
// Save any edited data
if (isset($_POST["low"]) || isset($_GET['zone_id'])) {
$className = adminControlWatchlist::GetWatchClassName($tradeType);
$watchlistAdmin = new $className($watchlistId);
}
if (isset($_POST["low"])) {
$low = isset($_POST["low"]) ? $_POST["low"] : 0;
$high = isset($_POST["high"]) ? $_POST["high"] : 0;
$top = isset($_POST["top"]) ? $_POST["top"] : 0;
$bottom = isset($_POST["bottom"]) ? $_POST["bottom"] : 0;
$t1 = isset($_POST["t1"]) ? $_POST["t1"] : 0;
//Include the PS_Pagination class
require_once 'php/db_interface/autoload.php';
$login = new login(true);
if (isset($_GET['tt'])) {
$tradeType = intval($_GET['tt']);
} else {
$tradeType = BREAKOUT_TRADE;
}
$counter = 1;
while (true) {
if (!isset($_POST[$counter])) {
break;
}
$watchId = $_POST[$counter];
$watchlist = new watchlist();
$watchlist->set_variable('watchlist_id', $watchId);
if ($watchlist->load()) {
$low = floatval($_POST['low_' . $watchId]);
$high = floatval($_POST['high_' . $watchId]);
$oldLow = floatval($watchlist->get_variable('watchlist_low'));
$oldHigh = floatval($watchlist->get_variable('watchlist_high'));
if ($oldLow != $low || $oldHigh != $high) {
$className = adminControlWatchlist::GetWatchClassName($tradeType);
$updateWatch = new $className();
$updateWatch->UpdateWatch($watchlist, $low, $high);
}
}
$counter++;
}
$watchlists = array();
public function AddNewTickerAndWatch($tickerName, $lowOrEntry, $highOrRange)
{
$tt = $this->GetTradeType();
// ADD THE TICKER FIRST
$ticker = new ticker();
$ticker->set_variable('ticker_symbol', $tickerName);
if (!$ticker->load()) {
$tickerId = $ticker->createNew();
$ticker->load();
$ticker->updateFromYahoo();
} else {
$tickerId = $ticker->get_variable('ticker_id');
}
// ADD TO THE WATCHLIST NOW
$watchlist = new watchlist();
$watchlist->set_variable('watchlist_ticker_id', $tickerId);
// call pure virtual to get fields based on trade type
$this->CalculateTargets($lowOrEntry, $highOrRange);
$watchlist->set_variable('watchlist_low', $lowOrEntry);
$watchlist->set_variable('watchlist_high', $highOrRange);
$watchlist->set_variable('watchlist_top', $this->topPrice);
$watchlist->set_variable('watchlist_bottom', $this->bottomPrice);
$watchlist->set_variable('watchlist_target0', $this->t0);
$watchlist->set_variable('watchlist_target1', $this->t1);
$watchlist->set_variable('watchlist_target2', $this->t2);
$watchlist->set_variable('watchlist_target3', $this->t3);
$watchlist->set_variable('watchlist_tradetype', $tt);
$watchId = $watchlist->createNew();
holdings::updateTickerSellPrices($tickerId, $this->bottomPrice, $tt, false);
highlights::watchlistHighlight($watchId, W_ROW, 0, highlights::EVENT_START_DAY);
}
private function updateHoldings()
{
$holdings = new holdings();
$now = date('Y-m-d H:i:s');
while ($holdings->loadNextAll()) {
$last_action = $holdings->get_variable('holdings_last_action');
$action = $last_action;
$last = floatval($holdings->get_variable('last'));
$high = floatval($holdings->get_variable('last_high'));
$low = floatval($holdings->get_variable('last_low'));
// check to make sure we didn't just zone for testing the ticker information
$origDate = $holdings->get_variable('holdings_orig_date');
$diff = (strtotime($now) - (strtotime($origDate) + 60 * updater::HIGH_MINUTE_WINDOW)) / 60;
if ($diff < 0) {
$high = $last;
}
if ($high <= 0) {
$high = $last;
}
if ($low <= 0) {
$low = $last;
}
$symbol = $holdings->get_variable('ticker_symbol');
$tId = $holdings->get_variable('ticker_id');
//$t0 = floatval($holdings->get_variable('holdings_t0'));
$t1 = floatval($holdings->get_variable('holdings_t1'));
$t2 = floatval($holdings->get_variable('holdings_t2'));
$t3 = floatval($holdings->get_variable('holdings_t3'));
$t1Marked = $holdings->get_variable('holdings_t1_marked');
$t2Marked = $holdings->get_variable('holdings_t2_marked');
$t3Marked = $holdings->get_variable('holdings_t3_marked');
$stopType = $holdings->get_variable('holdings_stop_type');
$stopPrice = $holdings->get_variable('holdings_stop_price');
$topPrice = $holdings->get_variable('holdings_top_price');
$origPrice = $holdings->get_variable('holdings_orig_price');
$hId = $holdings->get_variable('holdings_id');
$tradeType = $holdings->get_variable('holdings_tradetype');
$newHolding = new holdings();
if ($tradeType == SHORT_TRADE) {
if (!$t1Marked && ($last <= $t1 || $low <= $t1)) {
//"SELL #1";
echo "\n\n\nSHORT BUY 1 and send tweet!";
$action = SELL1;
$actionPrice = $t1;
$newHolding->set_variable('holdings_t1_marked', 1);
// update sell price of all holdings with this ticker_id
watchlist::removeTickerHitT1($tId);
//holdings::updateTickerSellPrices($tId, $origPrice);
highlights::holdingsHighlight($hId, H_T1, 0, highlights::EVENT_START_DAY);
} else {
if (!$t2Marked && ($last <= $t2 || $low <= $t2)) {
//"SELL #2";
echo "\n\n\nSHORT BUY2 and send tweet!";
$action = SELL2;
$actionPrice = $t2;
$newHolding->set_variable('holdings_t2_marked', 1);
holdings::updateTickerSellPrices($tId, $t1);
highlights::holdingsHighlight($hId, H_T2, 0, highlights::EVENT_START_DAY);
} else {
if (!$t3Marked && ($last <= $t3 || $low <= $t3)) {
//"SELL #3";
echo "\n\n\nSELL 3 and send tweet!";
$actionPrice = $t3;
$action = SELL3;
$newHolding->set_variable('holdings_t3_marked', 1);
holdings::updateTickerSellPrices($tId, $t3);
highlights::holdingsHighlight($hId, H_T3, 0, highlights::EVENT_START_DAY);
} else {
if (!$t3Marked && $last >= $stopPrice) {
if ($last_action != WARNING && !IsAbandoned($last_action)) {
//"WARNING";
echo "\n\n\nWARNING and send tweet!";
$action = WARNING;
$actionPrice = $stopPrice;
}
}
}
}
}
if ($action != $last_action) {
$newHolding->set_variable('holdings_id', $hId);
$newHolding->set_variable('holdings_last_action', $action);
$newHolding->update();
// Add a transaction to the transaction table
holdings::CreateNewTransaction($hId, $tradeType, $actionPrice, $action);
}
} else {
if ($tradeType == LONG_TRADE) {
if (!$t1Marked && ($last >= $t1 || $high >= $t1)) {
//"SELL #1";
echo "\n\n\nSELL 1 and send tweet!";
$action = SELL1;
$actionPrice = $t1;
$newHolding->set_variable('holdings_t1_marked', 1);
$newHolding->set_variable('holdings_stop_price', $origPrice);
// update sell price of all holdings with this ticker_id
watchlist::removeTickerHitT1($tId);
//holdings::updateTickerSellPrices($tId, $origPrice);
highlights::holdingsHighlight($hId, H_T1, 0, highlights::EVENT_START_DAY);
} else {
if (!$t2Marked && ($last >= $t2 || $high >= $t2)) {
//"SELL #2";
echo "\n\n\nSELL 2 and send tweet!";
$action = SELL2;
$actionPrice = $t2;
$newHolding->set_variable('holdings_t2_marked', 1);
holdings::updateTickerSellPrices($tId, $t1);
highlights::holdingsHighlight($hId, H_T2, 0, highlights::EVENT_START_DAY);
} else {
if (!$t3Marked && ($last >= $t3 || $high >= $t3)) {
//"SELL #3";
echo "\n\n\nSELL 3 and send tweet!";
$action = SELL3;
$actionPrice = $t3;
$newHolding->set_variable('holdings_t3_marked', 1);
holdings::updateTickerSellPrices($tId, $t2);
highlights::holdingsHighlight($hId, H_T3, 0, highlights::EVENT_START_DAY);
} else {
if ($last <= $stopPrice) {
if ($last_action != WARNING && !IsAbandoned($last_action)) {
//"WARNING";
echo "\n\n\nWARNING and send tweet!";
$action = WARNING;
$actionPrice = $stopPrice;
}
}
}
}
}
if ($action != $last_action) {
$newHolding->set_variable('holdings_id', $hId);
$newHolding->set_variable('holdings_last_action', $action);
$newHolding->update();
// Add a transaction to the transaction table
holdings::CreateNewTransaction($hId, $tradeType, $actionPrice, $action);
}
} else {
if ($tradeType == REVERSAL_TRADE) {
} else {
$abandonPrice = $stopPrice;
$hardStopPrice = $topPrice;
switch ($tradeType) {
case BREAKOUT_TRADE:
if (!$t3Marked && ($last >= $t3 || $high >= $t3)) {
$holdings->markTarget(3, $symbol, $last, true, $t3);
} else {
if ($last <= $hardStopPrice) {
holdings::abandonHardStop($hId, "");
} else {
if ($last <= $abandonPrice) {
holdings::abandonPriceMet($hId, $abandonPrice);
// if ($last_action != WARNING && !IsAbandoned($last_action)) {
// //"WARNING";
// echo "\n\n\nWARNING and send tweet!";
// $action = WARNING;
// $actionPrice = $abandonPrice;
// $newHolding -> set_variable('holdings_id', $hId);
// $newHolding -> set_variable('holdings_last_action', $action);
// $newHolding -> update();
//
// holdings::CreateNewTransaction($hId, $tradeType, $abandonPrice, $action);
// }
}
}
}
break;
case PULLBACK_TRADE:
if (!$t1Marked && ($last >= $t1 || $high >= $t1)) {
$holdings->markTarget(1, $symbol, $last, true, $t1);
} else {
if (!$t1Marked && $last <= $abandonPrice) {
holdings::abandonPriceMet($hId, $abandonPrice);
// if ($last_action != WARNING && !IsAbandoned($last_action)) {
// //"WARNING";
// echo "\n\n\nWARNING and send tweet!";
// $action = WARNING;
// $actionPrice = $abandonPrice;
// $newHolding -> set_variable('holdings_id', $hId);
// $newHolding -> set_variable('holdings_last_action', $action);
// $newHolding -> update();
//
// holdings::CreateNewTransaction($hId, $tradeType, $abandonPrice, $action);
// }
}
}
break;
case BACKDRAFT_TRADE:
if (!$t1Marked && ($last <= $t1 || $low <= $t1)) {
$holdings->markTarget(1, $symbol, $last, true, $t1);
} else {
if (!$t1Marked && $last >= $abandonPrice) {
holdings::abandonPriceMet($hId, $abandonPrice);
// if ($last_action != WARNING && !IsAbandoned($last_action)) {
// //"WARNING";
// echo "\n\n\nWARNING and send tweet!";
// $action = WARNING;
// $actionPrice = $abandonPrice;
// $newHolding -> set_variable('holdings_id', $hId);
// $newHolding -> set_variable('holdings_last_action', $action);
// $newHolding -> update();
//
// holdings::CreateNewTransaction($hId, $tradeType, $abandonPrice, $action);
// }
}
}
break;
case BREAKDOWN_TRADE:
if (!$t3Marked && ($last <= $t3 || $high <= $t3)) {
$holdings->markTarget(3, $symbol, $last, true, $t3);
} else {
if ($last >= $hardStopPrice) {
holdings::abandonHardStop($hId, "");
} else {
if ($last >= $abandonPrice) {
holdings::abandonPriceMet($hId, $abandonPrice);
// if ($last_action != WARNING && !IsAbandoned($last_action)) {
// //"WARNING";
// echo "\n\n\nWARNING and send tweet!";
// $action = WARNING;
// $actionPrice = $abandonPrice;
// $newHolding -> set_variable('holdings_id', $hId);
// $newHolding -> set_variable('holdings_last_action', $action);
// $newHolding -> update();
//
// holdings::CreateNewTransaction($hId, $tradeType, $abandonPrice, $action);
// }
}
}
}
break;
}
}
}
}
// OBSOLETE WITH THE NEW METHODS
if ($action != $last_action) {
$tweet = new tweet();
$updateEmail = new email(email::ADDRESSES_ALL_CHOSEN, $tradeType, $hId);
$tweet->newTweet($tradeType, $action, $symbol, $actionPrice);
$updateEmail->newEmail($tradeType, $action, $symbol, $actionPrice);
}
}
}
public static function deleteZonedTickers($tradeType)
{
$watchlist = new watchlist();
$watchlist->set_variable('watchlist_is_zoned', 1);
$watchlist->set_variable('watchlist_tradetype', $tradeType);
$watchlist->delete();
}
function startOfDayUpdate()
{
// Update the highlights with start of day trigger
highlights::eventTrigger(highlights::EVENT_START_DAY);
// Make sure no expired users get emails.
user::resetAllExpiredEmailUpdates();
// Delete previously deleted watchlists
watchlist::pruneDeletedWatchlistIds();
watchlist::deleteZonedTickers(BREAKOUT_TRADE);
watchlist::deleteZonedTickers(BREAKDOWN_TRADE);
watchlist::deleteZonedTickers(LONG_TRADE);
watchlist::deleteZonedTickers(SHORT_TRADE);
watchlist::deleteZonedTickers(PULLBACK_TRADE);
watchlist::deleteZonedTickers(BACKDRAFT_TRADE);
$deleteIds = array();
$deleteHoldingsIds = array();
$holdings = new holdings();
while ($holdings->loadNext()) {
$hid = $holdings->get_variable("holdings_id");
$tid = $holdings->get_variable("holdings_ticker_id");
$action = $holdings->get_variable("holdings_last_action");
$hidden = $holdings->get_variable("holdings_abandon_hide");
$tradeType = $holdings->get_variable("holdings_tradetype");
if (IsAbandoned($action) && $hidden == 0) {
$deleteHoldingsIds[] = $hid;
echo "\nDELETING Holdings ID " . $hid . " because it was abandoned";
$watchlist = new watchlist();
$watchlist->set_variable("watchlist_ticker_id", $tid);
$watchlist->set_variable("watchlist_tradetype", $tradeType);
while ($watchlist->loadNext()) {
$deleteIds[] = $watchlist->get_variable("watchlist_id");
}
} else {
if (($tradeType == REVERSAL_TRADE || $tradeType == SHORT_TRADE) && $hidden == 0) {
$hitT3 = $holdings->get_variable("holdings_t3_marked");
if ($hitT3 == 1) {
$deleteHoldingsIds[] = $hid;
echo "\nDELETING Holdings ID " . $hid . " because topped reversal/shorts";
$watchlist = new watchlist();
$watchlist->set_variable("watchlist_ticker_id", $tid);
$watchlist->set_variable("watchlist_tradetype", $tradeType);
while ($watchlist->loadNext()) {
$deleteIds[] = $watchlist->get_variable("watchlist_id");
}
}
} else {
if (($tradeType == BACKDRAFT_TRADE || $tradeType == PULLBACK_TRADE) && $hidden == 0) {
$hitT1 = $holdings->get_variable("holdings_t1_marked");
if ($hitT1 == 1) {
$deleteHoldingsIds[] = $hid;
echo "\nDELETING Holdings ID " . $hid . " because topped pullback/backdraft";
$watchlist = new watchlist();
$watchlist->set_variable("watchlist_ticker_id", $tid);
$watchlist->set_variable("watchlist_tradetype", $tradeType);
while ($watchlist->loadNext()) {
$deleteIds[] = $watchlist->get_variable("watchlist_id");
}
}
}
}
}
}
foreach ($deleteIds as $wid) {
echo "\n\n\nDELETING Watchlist ID " . $wid . " because it is abandoned or topped out reversal/shorts";
$watchlist = new watchlist();
$watchlist->set_variable('watchlist_id', $wid);
$watchlist->delete();
}
foreach ($deleteHoldingsIds as $hid) {
echo "\n\n\nDELETING Holdings ID " . $hid . " because it is abandoned or topped out reversal/shorts";
$holdings = new holdings();
$holdings->set_variable('holdings_id', $hid);
// instead of deleting, mark it as hidden
if ($holdings->load()) {
$tickerInfo = new ticker();
$tickerInfo->set_variable('ticker_id', $holdings->get_variable('holdings_ticker_id'));
if ($tickerInfo->load()) {
$holdings->set_variable('holdings_ticker_symbol', $tickerInfo->get_variable('ticker_symbol'));
}
$holdings->set_variable('holdings_abandon_hide', 1);
$holdings->set_variable('holdings_abandon_date', date('Y-m-d H:i:s'));
$holdings->update();
}
// replace this
//$holdings->delete();
}
// delete the tickers that are no longer used.
$ticker = new ticker();
$deleteIds = array();
while ($ticker->loadNext()) {
$tid = $ticker->get_variable("ticker_id");
// reset the high and low
$last = $ticker->get_variable("last");
$ticker->set_variable("today_high", $last);
$ticker->set_variable("today_low", $last);
$ticker->set_variable("last_high", $last);
$ticker->set_variable("last_low", $last);
$ticker->update();
$watchlist = new watchlist();
$watchlist->set_variable("watchlist_ticker_id", $tid);
if (!$watchlist->load()) {
$holding = new holdings();
$holding->set_variable("holdings_ticker_id", $tid);
$holding->set_variable("holdings_abandon_hide", 0);
if (!$holding->load()) {
$deleteIds[] = $tid;
}
}
}
foreach ($deleteIds as $tid) {
echo "\n\n\nDELETING TICKER ID " . $tid . " because it is no longer used";
$ticker = new ticker();
$ticker->set_variable('ticker_id', $tid);
$ticker->delete();
}
$tickerHist = new ticker_history();
while ($tickerHist->loadNextDistinctTicker()) {
$ticker = new ticker();
$tid = $tickerHist->get_variable('history_ticker_id');
$ticker->set_variable('ticker_id', $tid);
if (!$ticker->load()) {
echo "\nTicker History Cleanup:: Removing " . $tid . "\n";
ticker_history::removeTickerHistory($tid);
}
}
// try to reconcile any payments that are not currently known.
// now doing this whenever a payment is received.
//payment_info::reconcileAllPaymentUids();
}
public function markTarget($targetNum, $symbol, $last, $sendUpdate = false, $updatedSellPrice = -1)
{
$isMarked = $this->get_variable('holdings_t' . $targetNum . '_marked');
if ($isMarked) {
return;
}
$targetVal = $this->get_variable('holdings_t' . $targetNum);
$hId = $this->get_variable('holdings_id');
$tId = $this->get_variable('holdings_ticker_id');
if (!isset($tId)) {
$tId = $this->get_variable('ticker_id');
}
// fix if not set
$tradeType = $this->get_variable('holdings_tradetype');
$action = GetActionByTarget($targetNum);
$highlight = GetHighlightByTarget($targetNum);
if ($sendUpdate) {
$tweet = new tweet();
$updateEmail = new email(email::ADDRESSES_ALL_CHOSEN, $tradeType, $hId);
switch ($targetNum) {
case 1:
$action = SELL1;
break;
case 2:
$action = SELL2;
break;
case 3:
$action = SELL3;
break;
}
$tweet->newTweet($tradeType, $action, $symbol, $targetVal);
$updateEmail->newEmail($tradeType, $action, $symbol, $targetVal);
//$tweet->hitTarget($tradeType, $targetNum, $symbol, $last);
//$updateEmail->hitTarget($tradeType, $targetNum, $symbol, $last);
}
// update sell price of all holdings with this ticker_id
if ($targetNum == 1) {
watchlist::removeTickerHitT1($tId);
}
// get default price if not specified
$updatedSellPrice = $this->GetUpdatedSellPrice($tradeType, $targetNum);
// don't run if default is -1
echo "\n<br> Updating with sellPrice = " . $updatedSellPrice;
if ($updatedSellPrice >= 0) {
holdings::updateTickerSellPrices($tId, $updatedSellPrice, $tradeType);
}
$newHoldings = new holdings();
$newHoldings->set_variable('holdings_id', $hId);
$newHoldings->set_variable('holdings_last_action', $action);
$newHoldings->set_variable('holdings_t' . $targetNum . '_marked', 1);
$newHoldings->update();
holdings::CreateNewTransaction($hId, $tradeType, $targetVal, $action);
highlights::holdingsHighlight($hId, $highlight, 0, highlights::EVENT_START_DAY);
}
