示例#1
0
function codesword_atr($real, $periodLookback = 14)
{
    $tr = codesword_tr($real);
    //Compute the Average True Range by running WEMA on TR
    $atr = codesword_wilder_ema($tr, $periodLookback);
    return $atr;
}
示例#2
0
function getTrueRange($company, $from = "1900-01-01 00:00:00", $to = null, $dataorg = "json", $host, $db, $user, $pass)
{
    // Create connection
    $con = mysqli_connect($host, $user, $pass, $db);
    // Check connection
    if (mysqli_connect_errno()) {
        echo "Failed to connect to MySQL: " . mysqli_connect_error();
        return;
    }
    $studyPeriod = 14;
    $smoothingPeriod = 0;
    $offsetPeriod = $studyPeriod + $smoothingPeriod;
    if ($dataorg == "highchart") {
        //Added 8 hours to timestamp because of the Philippine Timezone WRT GMT (+8:00)
        $sql = "SELECT (UNIX_TIMESTAMP(DATE_ADD(timestamp, INTERVAL 8 HOUR)) * 1000) as timestamp, \n\t\t\t\t\thigh, low, close\n\t\t\t\t\tFROM {$company} \n\t\t\t\t\tWHERE timestamp >= DATE_ADD('" . $from . "', INTERVAL -{$offsetPeriod} DAY) \n\t\t\t\t\tAND timestamp <= '" . $to . "' ORDER BY timestamp ASC";
    } else {
        $sql = "SELECT DATE_FORMAT(timestamp, '%Y-%m-%d') as timestamp, high, low, close \n\t\t\t\t\tFROM {$company} \n\t\t\t\t\tWHERE timestamp >= DATE_ADD('" . $from . "', INTERVAL -{$offsetPeriod} DAY) \n\t\t\t\t\tAND timestamp <= '" . $to . "' ORDER BY timestamp ASC";
    }
    $result = mysqli_query($con, $sql);
    $dbreturn = "";
    $ctr = 0;
    $temp;
    $returnTrueRange;
    while ($row = mysqli_fetch_array($result)) {
        if ($dataorg == "json") {
            $dbreturn[$ctr][0] = $row['timestamp'];
            $dbreturn[$ctr][1] = floatval($row['high']);
            $dbreturn[$ctr][2] = floatval($row['low']);
            $dbreturn[$ctr][3] = floatval($row['close']);
        } elseif ($dataorg == "highchart") {
            $dbreturn[$ctr][0] = doubleval($row['timestamp']);
            $dbreturn[$ctr][1] = floatval($row['high']);
            $dbreturn[$ctr][2] = floatval($row['low']);
            $dbreturn[$ctr][3] = floatval($row['close']);
        } elseif ($dataorg == "array") {
            //TODO: create code for organizing an array data output
        } else {
            $dbreturn[$ctr][0] = $row['timestamp'];
            $dbreturn[$ctr][1] = floatval($row['high']);
            $dbreturn[$ctr][2] = floatval($row['low']);
            $dbreturn[$ctr][3] = floatval($row['close']);
        }
        $ctr = $ctr + 1;
    }
    if ($dataorg == "json") {
        $returnTrueRange = codesword_tr($dbreturn);
    } elseif ($dataorg == "highchart") {
        $returnTrueRange = codesword_tr($dbreturn);
    } elseif ($dataorg == "array") {
        //TODO: create code for organizing an array data output
    } else {
        //json
        $returnTrueRange = codesword_tr($dbreturn);
    }
    echo json_encode($returnTrueRange);
    mysqli_close($con);
}