public static void insert_ticker(string result, string pair) { StringBuilder sb = new StringBuilder(); BsonDocument doc = MongoHelper.get_doc_from_str(result); BtcHelper.insert_ticker("btcchina", pair, doc["ticker"]["last"].ToString(), doc["ticker"]["sell"].ToString(), doc["ticker"]["buy"].ToString(), doc["ticker"]["high"].ToString(), doc["ticker"]["low"].ToString(), doc["ticker"]["vol"].ToString(), doc["ticker"]["date"].ToString() + "000"); }
public static void insert_trade(string result, string pair) { StringBuilder sb = new StringBuilder(); BsonArray list = MongoHelper.get_array_from_str(result); BsonArray sell = new BsonArray(); BsonArray buy = new BsonArray(); for (int i = 0; i < list.Count; i++) { BsonDocument doc_item = new BsonDocument(); doc_item["id"] = list[i]["tid"].ToString(); doc_item["time"] = list[i]["date"].ToString(); doc_item["price"] = list[i]["price"].ToString(); doc_item["qty"] = list[i]["amount"].ToString(); if (list[i]["type"].ToString() == "sell") { sell.Add(doc_item); } if (list[i]["type"].ToString() == "buy") { buy.Add(doc_item); } } BtcHelper.insert_trade_log("btcchina", pair, "sell", "btc", sell.ToString()); BtcHelper.insert_trade_log("btcchina", pair, "buy", "btc", buy.ToString()); }
public static void insert_ticker(string result) { StringBuilder sb = new StringBuilder(); BsonDocument doc = MongoHelper.get_doc_from_str(result); BtcHelper.insert_ticker("btctrade", "btc_cny", doc["last"].ToString(), doc["sell"].ToString(), doc["buy"].ToString(), doc["high"].ToString(), doc["low"].ToString(), doc["vol"].ToString(), doc["time"].ToString() + "000"); }
public void okcoin_cn_btc_cny_trade() { string max_id = BtcHelper.get_trade_max_id("okcoin_cn"); string result = OkcCNApi.trade(max_id); BsonArray list = MongoHelper.get_array_from_str(result); for (int i = 0; i < list.Count; i++) { BtcHelper.insert_trade("okcoin_cn", list[i]["tid"].ToString(), list[i]["date_ms"].ToString(), list[i]["price"].ToString(), list[i]["amount"].ToString(), list[i]["type"].ToString(), "btc_cny", "btc"); } }
public void btcchina_btc_cny_trade() { string max_id = BtcHelper.get_trade_max_id("btcchina"); string result = BtcchinaApi.trade_by_id(Pair.btc_cny.ToString(), max_id); BsonArray list = MongoHelper.get_array_from_str(result); for (int i = 0; i < list.Count; i++) { BtcHelper.insert_trade("btcchina", list[i]["tid"].ToString(), list[i]["date"].ToString() + "000", list[i]["price"].ToString(), list[i]["amount"].ToString(), list[i]["type"].ToString(), "btc_cny", "btc"); } }
private void btn_test_Click(object sender, EventArgs e) { //this.txt_result.Text = BtceApi.trades(Pair.btc_usd.ToString()); //string max_id = BtcHelper.get_trade_max_id("btcchina"); // string result = BtcchinaApi.trade_by_id(Pair.btc_cny.ToString(), max_id); string result = ""; StreamReader reader = new StreamReader("c:/test.txt", Encoding.Default); result = reader.ReadToEnd(); reader.Close(); BsonArray list = MongoHelper.get_array_from_str(result); for (int i = 0; i < list.Count; i++) { BtcHelper.insert_trade("btcchina", list[i]["tid"].ToString(), list[i]["date"].ToString() + "000", list[i]["price"].ToString(), list[i]["amount"].ToString(), list[i]["type"].ToString(), "btc_cny", "btc"); } }
public static void insert_depth(string result, string pair) { StringBuilder sb = new StringBuilder(); BsonDocument doc = MongoHelper.get_doc_from_str(result); BsonArray asks = doc["asks"].AsBsonArray; BsonArray bids = doc["bids"].AsBsonArray; BtcHelper.delete_depth("huobi", pair); BtcHelper.insert_depth_log("huobi", pair, "sell", "btc", asks.ToString(), ""); BtcHelper.insert_depth_log("huobi", pair, "buy", "btc", bids.ToString(), ""); for (int i = 0; i < asks.Count; i++) { BtcHelper.insert_depth("huobi", pair, "sell", "btc", asks[i][0].ToString(), asks[i][1].ToString(), ""); } for (int i = 0; i < bids.Count; i++) { BtcHelper.insert_depth("huobi", pair, "buy", "btc", bids[i][0].ToString(), bids[i][1].ToString(), ""); } }
public void get_data_trade() { string max_id = BtcHelper.get_trade_max_id("btcchina"); string sql = "select * from trade_btcchina where tid={0}"; sql = string.Format(sql, max_id); DataTable dt_temp = SQLServerHelper.get_table(sql); sb.Append("BTCCHINA".PR(10) + dt_temp.Rows[0]["tid"].ToString().PR(15) + UnixTime.get_local_time_long(Convert.ToUInt64(dt_temp.Rows[0]["time"].ToString())).ToString("yyyy-MM-dd HH:mm:ss") + M.N); max_id = BtcHelper.get_trade_max_id("okcoin_cn"); sql = "select * from trade_okcoin_cn where tid={0}"; sql = string.Format(sql, max_id); dt_temp = SQLServerHelper.get_table(sql); sb.Append("OKCOIN_CN:".PR(10) + dt_temp.Rows[0]["tid"].ToString().PR(15) + UnixTime.get_local_time_long(Convert.ToUInt64(dt_temp.Rows[0]["time"].ToString())).ToString("yyyy-MM-dd HH:mm:ss") + M.N); this.txt_result.Text = sb.PRINT(); if (cb_btcchina_btc_cny_trade.Checked) { Thread thread_btcchina_btc_cny_trade = new Thread(new ThreadStart(btcchina_btc_cny_trade)); thread_btcchina_btc_cny_trade.Start(); } if (cb_okcoin_cn_btc_cny_trade.Checked) { Thread thread_okcoin_cn_btc_cny_trade = new Thread(new ThreadStart(okcoin_cn_btc_cny_trade)); thread_okcoin_cn_btc_cny_trade.Start(); } }