Esempio n. 1
0
        public static void StockData_Save(ArrayList data)
        {
            foreach (Object obj in data)
            {
                StockTradeInfo stock_info    = (StockTradeInfo)obj;
                String         stock_db_name = stock_info.stock_index;

                if (stock_db_name.StartsWith("237") == false)   //debug
                {
                    continue;
                }

                string sql_ins = "INSERT INTO " + StockDbName(stock_db_name) + "( trans_date, trans_volume, trans_count, trans_value, open, high, low ," +
                                 "close, diff, close_buy_price, close_buy_volume, close_sell_price, close_sell_volume) VALUE(" +
                                 "'" + Util.convertDate2mysql(stock_info.trans_date) + "'" + "," + stock_info.trans_volume.ToString() + "," + stock_info.trans_count.ToString() + "," + stock_info.trans_value.ToString() + "," +
                                 Util.double2dec(stock_info.open, 6, 2) + "," + Util.double2dec(stock_info.high, 6, 2) + "," + Util.double2dec(stock_info.low, 5, 2) + "," + Util.double2dec(stock_info.close, 5, 2) + "," +
                                 Util.double2dec(stock_info.diff, 5, 2) + "," + Util.double2dec(stock_info.close_buy_price, 5, 2) + "," + stock_info.close_buy_volume.ToString() + "," +
                                 Util.double2dec(stock_info.close_sell_price, 5, 2) + "," + stock_info.close_sell_volume.ToString() + ");";
                MySqlCommand cmd_insert = new MySqlCommand(sql_ins, conn);
                try
                {
                    cmd_insert.ExecuteNonQuery();
                }
                catch (MySql.Data.MySqlClient.MySqlException ex)
                {
                    //MessageBox.Show("Error " + ex.Number + " has occurred: " + ex.Message,
                    //    "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
            }
        }
Esempio n. 2
0
        private void show_kd(Canvas kd_canvas, StockTradeInfo[] hist)
        {
            double left_line_x    = 50;
            double buttom_space_y = 30;
            double x_step         = (kd_canvas.ActualWidth - left_line_x) / hist.Length;
            double kd_height      = kd_canvas.ActualHeight - buttom_space_y;

            Range_Mapper mapper = new Range_Mapper();

            mapper.UpdateRange(hist);
            mapper.targer_size = kd_height;

            for (int i = 0; i < hist.Length; i++)
            {
                StockTradeInfo  si       = hist[i];
                double          x_center = left_line_x + (49 - i) * x_step + x_step / 2;
                SolidColorBrush color    = si.close > si.open ? Brushes.Red : Brushes.Green;

                Line high_low = new Line();
                high_low.Stroke = color;
                high_low.X1     = x_center;
                high_low.X2     = x_center;
                high_low.Y1     = flip_y(kd_height, mapper.map(si.low));
                high_low.Y2     = flip_y(kd_height, mapper.map(si.high));
                kd_canvas.Children.Add(high_low);

                Rectangle open_close = new Rectangle();
                Canvas.SetLeft(open_close, x_center - x_step / 2);
                Canvas.SetTop(open_close, flip_y(kd_height, mapper.map(Math.Max(si.open, si.close))));
                open_close.Width  = x_step;
                open_close.Height = Math.Abs(mapper.map(si.open) - mapper.map(si.close));
                open_close.Stroke = color;
                kd_canvas.Children.Add(open_close);
            }
        }
Esempio n. 3
0
        public override ArrayList ParseHtml(string source, DateTime date)
        {
            Logger.Log("Parsing Stock Page:" + date.ToString());

            ArrayList stocks = new ArrayList();

            if (!IsValidJson(source))
            {
                return(stocks);
            }

            JObject obj = JObject.Parse(source);

            if (obj == null || obj["data9"] == null)
            {
                return(stocks);
            }

            foreach (JArray stk in obj["data9"])
            {
                //String stock_str = stk.ToString();
                //stock_str = stock_str.Substring(1, stock_str.Length - 2);   //remove []
                JToken[] token_ary   = stk.ToArray();
                String[] stk_strings = new string[token_ary.Length];
                for (int i = 0; i < token_ary.Length; i++)
                {
                    stk_strings[i] = token_ary[i].ToString();
                }

                StockTradeInfo stock_info = new StockTradeInfo(stk_strings, date);
                stocks.Add(stock_info);
            }
            return(stocks);
        }
Esempio n. 4
0
        float evaluate_transation(StockData stock_data, ArrayList history)
        {
            float     value = 1;
            float     share = 0;
            Trade_Cmd cmd;

            foreach (object obj in history)
            {
                cmd = (Trade_Cmd)obj;
                if (cmd.is_buy)
                {
                    StockTradeInfo trade_info = stock_data.getByDate(cmd.date);
                    float          buy_price  = trade_info.open;
                    share     = value / buy_price;
                    value     = 0;
                    cmd.price = buy_price;
                }
                else
                {
                    StockTradeInfo trade_info = stock_data.getByDate(cmd.date);
                    float          sell_price = trade_info.open;
                    value     = share * sell_price;
                    share     = 0;
                    cmd.price = sell_price;
                    cmd.perf  = value;
                }
            }
            if (share > 0)
            {
                StockTradeInfo trade_info = stock_data.getLatest();
                float          sell_price = trade_info.open;
                value = share * sell_price;
            }
            return(value);
        }