$query = "select count(*) as total_pos_tran from turtle_transaction_pandl where profit_loss > 0"; $result = queryMysql($query); while ($data = mysql_fetch_row($result)) { $keyStatsArray[0]['total_pos_tran'] = $data[0]; } $query = "select count(*) as total_neg_tran from turtle_transaction_pandl where profit_loss < 0"; $result = queryMysql($query); while ($data = mysql_fetch_row($result)) { $keyStatsArray[0]['total_neg_tran'] = $data[0]; } $keyStatsArray[0]['pos_tran_probability'] = round($keyStatsArray[0]['total_pos_tran'] / $keyStatsArray[0]['tran_count'] * 100, 2); $keyStatsArray[0]['neg_tran_probability'] = round($keyStatsArray[0]['total_neg_tran'] / $keyStatsArray[0]['tran_count'] * 100, 2); echo json_encode($keyStatsArray); } elseif ($_GET['action'] == 'getRealTimeQuote') { $symbol = $_GET['symbol']; $quote = get_yahoo_rt_quote($symbol); echo json_encode($quote); } elseif ($_GET['action'] == 'test_turtle_portfolio_sell') { $today_date = $_GET['today_date']; $date = $_GET['date']; $portfolioID = 1; turtle_portfolio_sell($date, $portfolioID); } elseif ($_GET['action'] == 'test_crsi_sell') { $today_date = $_GET['today_date']; $date = $_GET['date']; $portfolioID = 1; crsi_sell($date, $portfolioID); } elseif ($_GET['action'] == 'test_turtle_portfolio_update_stop_loss') { $today_date = $_GET['today_date']; $date = $_GET['date']; turtle_portfolio_update_stop_loss($date);
} elseif ($_GET['action'] == 'getStockQuote') { /* $query = $_GET['txtInputQuery']; $query= stripslashes($query); $result = queryMysql($query); $sightings = array(); $sightings = mysql_resultTo2DAssocArray_JGrid($result); echo json_encode($sightings); */ $stock_list = get_stock_list_from_portfolio(); //echo "stock list", $stock_list; // $ret = get_yahoo_rt_quote ("MA+MCP+GMCR+F+WYNN+BAC+C+GS+SZYM+PER+RIMM+SFLY+PCLN"); $ret = get_yahoo_rt_quote($stock_list); echo json_encode($ret); exit; } elseif ($_GET['action'] == 'getStockQuote2') { $stock_list = get_stock_list_from_portfolio(); $ret = get_yahoo_rt_quote_2($stock_list); echo json_encode($ret); exit; } elseif ($_GET['action'] == 'getHP') { $symbol = $_GET['inputSymbol']; $begin_date = $_GET['begin_date']; $end_date = $_GET['end_date']; $freq = $_GET['freq']; $bd = explode('/', $begin_date); $ed = explode('/', $end_date); $begin_mon = $bd[0] - 1;