private MarketSummary GetMarketSummaryFromMarketSummaryResponse(GetMarketSummaryResponse resp) { return(new MarketSummary() { UniqueId = Guid.NewGuid(), //CurencyCode = GetCurrencyName(resp.MarketName), CurrentAskPrice = resp.Ask, CurrentBidPrice = resp.Bid, CurrentOpenBuyOrders = resp.OpenBuyOrders, CurrentOpenSellOrders = resp.OpenSellOrders, TimeStamp = new DateTimeOffset(DateTime.SpecifyKind(resp.TimeStamp, DateTimeKind.Utc)), LastPrice = resp.Last, //Source = this.Name, //TickerCode = GetTickerName(resp.MarketName), RawData = JsonConvert.SerializeObject(resp) }); }
private void guardaValorMonedas() { try { foreach (TIPO_MONEDA m in monedas) { GetMarketSummaryResponse res = ex.GetMarketSummary(m.moneda); res.TimeStamp = res.TimeStamp.AddHours(2); // PONEMOS HORA ESPAÑOLA bdd.altaMoneda(res); //listBox2.Items.Add(res.MarketName + " - HIGH: " + res.High + " LOW: " + res.Low); //if (listBox2.Items.Count > 300) // listBox2.Items.Clear(); } } catch (Exception ex) { } }
/// <summary> /// CARGA HISTORICO A PARTI DE CSV /// </summary> private void cargaHistorico() { int contFilas = 0; try { string path = @"C:\Users\juan.roncero\Documents\proyectos\csharp-bittrex-api-master\csharp-bittrex-api-master\consumer\History\bitstampUSD_1-min_data_2012-01-01_to_2017-05-31.csv"; path = Application.StartupPath + "\\bitstampUSD_1-min_data_2012-01-01_to_2017-05-31.csv"; // LEEMOS EXCEL // CAMPO 1 - TIMESTAMP System.DateTime dtDateTime = new DateTime(1970, 1, 1, 0, 0, 0, 0, System.DateTimeKind.Utc); GetMarketSummaryResponse valor = new GetMarketSummaryResponse(); using (var fs = File.OpenRead(path)) using (var reader = new StreamReader(fs)) { // Quitamos titulos reader.ReadLine(); while (!reader.EndOfStream) { // 850413 contFilas++; var line = reader.ReadLine(); var values = line.Split(','); // 0 1487927400, TIMESTAMP // 1 1191.01, OPEN // 2 1192.31, HIGH // 3 1188.87, LOW // 4 1188.92, CLOSE // 5 55.71403603, VOLUME_(BTC) // 6 66393.72532, VOLUME_(CURRENCY( // 7 1191.6875899 WEIGHTED_PRICE if (contFilas > 2704343) { // LIMPIAMOS NOT A NUMBER POR 0 if (values[7].ToString() != "NaN") { for (int i = 0; i < values.Length; i++) { if (values[i].ToString() == "NaN") { values[i] = "0"; } if (values[i].ToString() == "") { values[i] = "0"; } } try { var ci = CultureInfo.InvariantCulture.Clone() as CultureInfo; ci.NumberFormat.NumberDecimalSeparator = "."; double tempFecha = Convert.ToDouble(values[0].ToString()); //valor.MarketName = "USDT-BTC-HIST"; valor.MarketName = "USDT-BTC"; valor.TimeStamp = dtDateTime.AddSeconds(tempFecha).ToLocalTime(); valor.Open = Convert.ToDecimal(values[1].ToString()); valor.Bid = decimal.Parse(values[7].ToString().Trim(), ci); //valor.High = Convert.ToDecimal(values[2].ToString()); valor.High = decimal.Parse(values[2].ToString().Trim(), ci); //valor.Low = Convert.ToDecimal(values[3].ToString()); valor.Low = decimal.Parse(values[3].ToString().Trim(), ci); valor.Close = Convert.ToDecimal(values[4].ToString()); if (values[5].ToString().Contains("e")) { int ipos = values[5].ToString().IndexOf("e"); string tempVolume = values[5].ToString().Substring(0, ipos); valor.Volume = 0; } else { valor.Volume = Convert.ToDecimal(values[5].ToString()); } if (values[6].ToString().Contains("e")) { int ipos = values[6].ToString().IndexOf("e"); string tempVolume = values[6].ToString().Substring(0, ipos); valor.BaseVolume = 0; } else { valor.BaseVolume = Convert.ToDecimal(values[6].ToString()); } //valor.BaseVolume = Convert.ToDecimal(values[6].ToString()); //decimal valorAntiguo = Convert.ToDecimal(values[7].ToString()); valor.Bid = decimal.Parse(values[7].ToString().Trim(), ci); // 1.1 //if (valorAntiguo > 6000) //{ bdd.altaMonedaHistorico(valor); //} } catch (Exception ex) { listBox1.Items.Add(ex.ToString()); } } } } } } catch (Exception ex) { listBox1.Items.Add(ex.ToString()); } }