foreach ($row as $key => $value) {
             //$rowRet[] = $value;
             $ret[$i][$key] = $value;
         }
         //$ret[i] = $rowRet;
         $i++;
     }
     $ret2["dataset"] = $ret;
     echo json_encode($ret2);
     //exit;
 } elseif ($_GET['action'] == 'getCurrentTurtlePortfolio') {
     $query = $_GET['txtInputQuery'];
     $query = stripslashes($query);
     $result = queryMysql($query);
     $sightings = array();
     $sightings = mysql_resultTo2DAssocArray_JGrid($result);
     echo json_encode($sightings);
     exit;
 } elseif ($_GET['action'] == 'calculateEndBalance') {
     $transactionList = array();
     $beginBalance = 1000000;
     // get unique symbol from transaction table that has sell
     $query = "select symbol, trade_type, trade_date, shares, price from turtle_portfolio_transaction where portfolio_id = 1 order by trade_date asc ";
     $result = queryMysql($query);
     while ($data = mysql_fetch_row($result)) {
         if ($data[1] == 'BUY') {
             $beginBalance -= $data[3] * $data[4];
         } else {
             $beginBalance += $data[3] * $data[4];
         }
     }

                    $my_sql = "insert into turtle_s2_system (symbol, trade_date, trade_type, num_shares, ";
                    $my_sql .= "price_paid, current_N, stop_loss, next_buy_point, stop_loss_type, cash_balance, buy_type) ";
                    $my_sql .= "values ('" . $symbol . "', '" . $ph[$x]['trade_date'] . "', 'Sell', {$current_pos}, " . $stop_loss . ", ";
                    $my_sql .= "{$current_N}, 0, 0, '{$stop_loss_type}', {$cash_balance}, '{$buy_signal}') ";
                    $result = queryMysql($my_sql);
                    $current_pos = 0;
                    $pyramid_mode = 0;
                }
            }
        }
        $query = "select * from turtle_s2_system where symbol = '" . $symbol . "'";
        $query .= " and stop_loss_type = '{$stop_loss_type}' and buy_type = '{$buy_signal}'";
        $query = stripslashes($query);
        $result = queryMysql($query);
        $json_result = array();
        $json_result = mysql_resultTo2DAssocArray_JGrid($result);
        echo json_encode($json_result);
        exit;
    }
}
function get_stop_loss($type, $current_stop, $close_price, $day_high, $day_low, $high_55, $high_20, $low_20, $ma_50, $ma_200, $ATR)
{
    $stop = 0;
    if ($type == "ATR_1N") {
        $stop = $high_55 - $ATR;
    } else {
        if ($type == "ATR_2N") {
            $stop = $high_55 - 2 * $ATR;
        } else {
            if ($type == "8PCT") {
                $stop = $high_55 * 0.92;