Example #1
0
    $cur_symbol = $val['Symbol'];
    array_push($symbols_array[$cur_symbol], $val);
}
// _print_r($symbols_array,false);
//-------------------------------------
//-------------------------------------
// find the open, heigh, low, & closing of the range
$data_range = array();
foreach ($symbols_array as $key => $val) {
    $heigh_array = array();
    $low_array = array();
    foreach ($val as $kk => $vv) {
        $heigh_array[] = $vv['Heigh'];
        $low_array[] = $vv['Low'];
    }
    // _print_r($heigh_array,false);
    // _print_r($low_array,false);
    $date = explode(' ', $val[0]['Datetime']);
    $data_range[] = array('Symbol' => $val[0]['Symbol'], 'Open' => $val[0]['Open'], 'Heigh' => max($heigh_array), 'Low' => min($low_array), 'Closing' => $val[count($val) - 1]['Closing'], 'Datetime' => $val[0]['Datetime'], 'Range_start' => $date[0] . ' ' . $config['range_start'], 'Range_end' => $date[0] . ' ' . $config['range_end']);
}
_print_r($data_range, false);
// die;
//----------------------------------
//---------------------------------------------------
// insert into day table
$db->insert_range($config['db']['range_table'], $data_range);
//---------------------------------------------------
//---------------------------------------------------
// delete data from the range table according to the settings
$db->del($config['db']['range_table'], $config['range_table_range']);
//---------------------------------------------------