}
// build navigation
$navigation = $doc->createElement('navigation');
// <navigation>
$navigation = $root->appendChild($navigation);
addNode($doc, $navigation, 'tab', '0');
addNode($doc, $navigation, 'menu', '2');
addNode($doc, $navigation, 'pagedescr', 'Process New Stock Prices And Market Signals');
addNode($doc, $navigation, 'title', 'Bully Bully - Process');
addNode($doc, $navigation, 'pagename', 'Administration - Process');
if ($_GET[s] == 'y') {
addNode($doc, $navigation, 'signedin', 'yes');
} else {
addNode($doc, $navigation, 'signedin', 'no');
}
// build content
$sql = 'select current_date() today';
$rows = mysql_query($sql);
$cols = mysql_fetch_array($rows);
$today = $cols['today'];
$ss = $doc->createElement('settings');
// <settings>
$ss = $root->appendChild($ss);
addNode($doc, $ss, 'lastprocess', getorset('0', 'Last Process Date', '2007-06-13'));
addNode($doc, $ss, 'today', $today);
// Javascript
$js = $doc->createElement('javascript');
// <javascript>
$js = $root->appendChild($js);
addNode($doc, $js, 'script', 'js/process.js');
echo $doc->saveXML();
// build navigation
$navigation = $doc->createElement('navigation');
// <navigation>
$navigation = $root->appendChild($navigation);
addNode($doc, $navigation, 'tab', '0');
addNode($doc, $navigation, 'menu', '4');
addNode($doc, $navigation, 'pagedescr', "Display Market Signals And Warnings");
addNode($doc, $navigation, 'title', 'Bully Bully - Signals');
addNode($doc, $navigation, 'pagename', 'Administration - Signals');
if ($_GET[s] == 'y') {
addNode($doc, $navigation, 'signedin', 'yes');
} else {
addNode($doc, $navigation, 'signedin', 'no');
}
// content
$days = getorset('0', 'Days of Market Signals', '3');
if ($days == 0) {
$days = 30;
}
for ($i = 0; $i < $days; $i++) {
$today = time() - $i * 24 * 60 * 60;
$date = date("Y-m-d", $today);
$occ = $doc->createElement('content');
$occ = $root->appendChild($occ);
addNode($doc, $occ, 'date', $date);
addNode($doc, $occ, 'datestring', date("l, F j, Y", $today));
$signals = array();
if ($i == 0) {
getAlerts(&$signals);
}
// getSignals( &$signals, $date );
}
}
// build navigation
$navigation = $doc->createElement('navigation');
// <navigation>
$navigation = $root->appendChild($navigation);
addNode($doc, $navigation, 'tab', $_GET[t]);
addNode($doc, $navigation, 'menu', $_GET[m]);
addNode($doc, $navigation, 'pagedescr', "Review the Fund's Operational Settings");
addNode($doc, $navigation, 'title', 'Bully Bully - Settings');
addNode($doc, $navigation, 'pagename', $fundname . ' - Settings');
if ($_GET[s] == 'y') {
addNode($doc, $navigation, 'signedin', 'yes');
} else {
addNode($doc, $navigation, 'signedin', 'no');
}
// build content
$ss = $doc->createElement('settings');
// <settings>
$ss = $root->appendChild($ss);
addNode($doc, $ss, 'risk', getorset($_GET[t], 'Percentage of Equity Risked Per Trade', '2'));
addNode($doc, $ss, 'positions', getorset($_GET[t], 'Number of Concurrent Open Positions', '15'));
addNode($doc, $ss, 'maxprice', getorset($_GET[t], 'Maximum Price Per Share', '30'));
// Javascript
if ($_GET[s] == 'y') {
$js = $doc->createElement('javascript');
// <javascript>
$js = $root->appendChild($js);
addNode($doc, $js, 'script', 'js/fundsettings.js');
}
echo $doc->saveXML();
// build navigation
$navigation = $doc->createElement('navigation');
// <navigation>
$navigation = $root->appendChild($navigation);
addNode($doc, $navigation, 'tab', $_GET[t]);
addNode($doc, $navigation, 'menu', $_GET[m]);
addNode($doc, $navigation, 'pagedescr', "Review The System's Performance History");
addNode($doc, $navigation, 'title', 'Bully Bully - History');
addNode($doc, $navigation, 'pagename', 'Administration - History');
if ($_GET[s] == 'y') {
addNode($doc, $navigation, 'signedin', 'yes');
} else {
addNode($doc, $navigation, 'signedin', 'no');
}
// build content
$date = getorset('0', 'Last Process Date', '2007-06-13');
// Get Deposits
$sql = "select ifnull(sum(amount),0) deposits from deposits";
$rows = mysql_query($sql);
$cols = mysql_fetch_array($rows);
$deposits = $cols['deposits'];
// Get Profits
$sql = "select ifnull(sum((amount / buyprice) * (sellprice - buyprice)),0) profit from trades where selldate < '" . $date . "'";
$rows = mysql_query($sql);
$cols = mysql_fetch_array($rows);
$profit = $cols['profit'];
// Get Gain & Holdings
$sql = "select ifnull(sum(t.amount),0) holdings, ifnull(sum((t.amount / t.buyprice) * (ifnull(t.sellprice,p.price) - t.buyprice) ),0) gain from trades t, prices p where t.stock = p.stock and p.thedate = '" . $date . "' and ifnull(t.selldate,'" . $date . "') >= '" . $date . "'";
$rows = mysql_query($sql);
$cols = mysql_fetch_array($rows);
$holdings = $cols['holdings'];
addNode($doc, $occ, 'name', $cols['name']);
// <funds><name>
}
// build navigation
$navigation = $doc->createElement('navigation');
// <navigation>
$navigation = $root->appendChild($navigation);
addNode($doc, $navigation, 'tab', '0');
addNode($doc, $navigation, 'menu', '7');
addNode($doc, $navigation, 'pagedescr', "Review the System's Operational Settings");
addNode($doc, $navigation, 'title', 'Bully Bully - Settings');
addNode($doc, $navigation, 'pagename', 'Administration - Settings');
if ($_GET[s] == 'y') {
addNode($doc, $navigation, 'signedin', 'yes');
} else {
addNode($doc, $navigation, 'signedin', 'no');
}
// build content
$ss = $doc->createElement('settings');
// <settings>
$ss = $root->appendChild($ss);
addNode($doc, $ss, 'pricehistory', getorset('0', 'Years of Price History', '5'));
addNode($doc, $ss, 'marketsignals', getorset('0', 'Days of Market Signals', '3'));
// Javascript
if ($_GET[s] == 'y') {
$js = $doc->createElement('javascript');
// <javascript>
$js = $root->appendChild($js);
addNode($doc, $js, 'script', 'js/settings.js');
}
echo $doc->saveXML();
function getBuys($date)
{
// Get 3rd High Signals
$sql = "select stock, count(*), max(thedate), max(price) price from signals group by stock having count(*) = 3 and max(thedate) = '" . $date . "'";
$rows1 = mysql_query($sql);
while ($cols1 = mysql_fetch_array($rows1)) {
// Get Funds That Track it
$stock = $cols1['stock'];
$price = $cols1['price'];
$sql = "select fund from fundstocks where stock = " . $stock;
$rows2 = mysql_query($sql);
while ($cols2 = mysql_fetch_array($rows2)) {
$fund = $cols2['fund'];
// Get Signal Dates & Prices
$sql = "select thedate, price from signals where stock = " . $stock . " order by thedate";
$rows = mysql_query($sql);
$cols = mysql_fetch_array($rows);
$s1date = $cols['thedate'];
$s1price = $cols['price'];
$cols = mysql_fetch_array($rows);
$s2date = $cols['thedate'];
$s2price = $cols['price'];
// Get High120 & Low120
$sql = "select low120, high120 from prices where stock = " . $stock . " and thedate = '" . $date . "'";
$rows = mysql_query($sql);
$cols = mysql_fetch_array($rows);
$low120 = $cols['low120'];
$high120 = $cols['high120'];
$stop = $low120 + ($price - $low120) * 0.5;
// Get Deposits
$sql = "select ifnull(sum(amount),0) deposits from deposits where fund = " . $fund . " and thedate < '" . $date . "'";
$rows = mysql_query($sql);
$cols = mysql_fetch_array($rows);
$deposits = $cols['deposits'];
// Get Profits
$sql = "select ifnull(sum((amount / buyprice) * (sellprice - buyprice)),0) profit from trades where fund = " . $fund . " and selldate < '" . $date . "'";
$rows = mysql_query($sql);
$cols = mysql_fetch_array($rows);
$profit = $cols['profit'];
// Get Gain & Holdings
$sql = "select ifnull(sum(t.amount),0) holdings, ifnull(sum((t.amount / t.buyprice) * (ifnull(t.sellprice,p.price) - t.buyprice) ),0) gain from trades t, prices p where t.stock = p.stock and p.thedate = '" . $date . "' and t.fund = " . $fund . " and ifnull(t.selldate,'" . $date . "') >= '" . $date . "'";
$rows = mysql_query($sql);
$cols = mysql_fetch_array($rows);
$holdings = $cols['holdings'];
$gain = $cols['gain'];
// Calculate Cash & Equity
$cash = $deposits + $profit - $holdings;
$equity = $deposits + $profit + $gain;
$portfolio = $equity - $cash;
// Get Fund Settings
$risk = getorset($fund, 'Percentage of Equity Risked Per Trade', '2');
$diversity = getorset($fund, 'Number of Concurrent Open Positions', '15');
$maxprice = getorset($fund, 'Maximum Price Per Share', '30');
// AMOUNT - Set Risk As Percentage Of Equity
$amount = $equity * ($risk / 100) / ($price - $stop) * $price;
// AMOUNT - Adjust Amount To Achieve Diversity
if ($amount > $equity * (1 / $diversity)) {
$amount = $equity * (1 / $diversity);
}
// AMOUNT - Set Amount Bases On Available Cash
if ($amount > $cash) {
$amount = $cash;
}
// AMOUNT - Set Amount Bases On Available Cash
if ($cash - $amount < 50) {
$amount = $cash;
}
// AMOUNT - Cheap Stocks Only
if ($maxprice != 0 && $price > $maxprice) {
$amount = 0;
}
// AMOUNT - Out of money
if ($amount < 50) {
$amount = 0;
}
if ($amount > 0) {
$sql = "insert into trades ( fund, stock, s1date, s1price, s2date, s2price, buydate, buyprice, amount, stop ) values ( " . $fund . ", " . $stock . ", '" . $s1date . "', " . $s1price . ", '" . $s2date . "', " . $s2price . ", '" . $date . "', " . $price . ", " . $amount . ", " . $stop . " )";
if (!mysql_query($sql)) {
return 0;
}
}
}
}
return 1;
}
<?php
header('Content-type: text/xml');
include '../bully.inc';
$stock = $_GET[s];
$phase = $_GET[p];
$rc = '0';
$message = 'Setting Successfuly Changed.';
$db = new Database();
// Get Symbol
$sql = 'select symbol from stocks where id = ' . $stock;
$rows = mysql_query($sql);
$cols = mysql_fetch_array($rows);
$symbol = $cols['symbol'];
// Get Dates
$history = getorset('0', 'Years of Price History', '5');
$sql = 'select current_date() Today, date_add(current_date, INTERVAL -' . $history . ' YEAR) Start, date_add(current_date, INTERVAL -10 DAY) Day10';
$rows = mysql_query($sql);
$cols = mysql_fetch_array($rows);
$today = $cols['Today'];
$start = $cols['Start'];
$day10 = $cols['Day10'];
switch ($phase) {
case '1':
$sql = "delete from prices where stock = " . $stock;
if (!mysql_query($sql)) {
$rc = '4';
$message = mysql_error();
break;
}
break;
$cols = mysql_fetch_array($rows);
$profit = $cols['profit'];
// Get Gain & Holdings
$sql = "select ifnull(sum(t.amount),0) holdings, ifnull(sum((t.amount / t.buyprice) * (ifnull(t.sellprice,p.price) - t.buyprice) ),0) gain from trades t, prices p where t.stock = p.stock and p.thedate = '" . $date . "' and t.fund = " . $fund . " and ifnull(t.selldate,'" . $date . "') >= '" . $date . "'";
$rows = mysql_query($sql);
$cols = mysql_fetch_array($rows);
$holdings = $cols['holdings'];
$gain = $cols['gain'];
// Calculate Cash & Equity
$cash = $deposits + $profit - $holdings;
$equity = $deposits + $profit + $gain;
$portfolio = $equity - $cash;
// Get Fund Settings
$risk = getorset($fund, 'Percentage of Equity Risked Per Trade', '2');
$diversity = getorset($fund, 'Number of Concurrent Open Positions', '15');
$maxprice = getorset($fund, 'Maximum Price Per Share', '30');
// AMOUNT - Set Risk As Percentage Of Equity
$amount = $equity * ($risk / 100) / ($price - $stop) * $price;
// AMOUNT - Adjust Amount To Achieve Diversity
if ($amount > $equity * (1 / $diversity)) {
$amount = $equity * (1 / $diversity);
}
// AMOUNT - Set Amount Bases On Available Cash
if ($amount > $cash) {
$amount = $cash;
}
// AMOUNT - Set Amount Bases On Available Cash
if ($cash - $amount < 50) {
$amount = $cash;
}
// AMOUNT - Cheap Stocks Only
