public void loadHistoryData(DateTime sDate, DateTime eDate) { this.marketDataList_ = new List <IndexMarketData>(); WebClient webClient = new WebClient(); StringBuilder sb = new StringBuilder(); string s_year = (sDate.Year).ToString(); string s_month = (sDate.Month - 1).ToString(); string s_day = (sDate.Day).ToString(); string e_year = (eDate.Year).ToString(); string e_month = (eDate.Month - 1).ToString(); string e_day = (eDate.Day).ToString(); foreach (var item in this.indexYahooTickerList_) { sb.Clear(); sb.Append("http://ichart.yahoo.com/table.csv?s=%40%5EDJI," + item.Yahoo_ticker_ + "&a=" + s_month + "&b=" + s_day + "&c=" + s_year + "&d=" + e_month + "&e=" + e_day + "&f=" + e_year + "&g=d&ignore=.csv"); IndexHistoryMarketData ihmd = new IndexHistoryMarketData(item); string dataURL = sb.ToString(); Stream stream = webClient.OpenRead(dataURL); StreamReader reader = new StreamReader(stream); // 처음 한줄은 건너뜀 var line = reader.ReadLine(); while (!reader.EndOfStream) { line = reader.ReadLine(); var values = line.Split(','); DateTime d = DateTime.Parse(values[0]); ihmd.TimeSeries_.Add(d.ToString("yyyyMMdd"), values[4]); } stream.Close(); reader.Close(); this.marketHistoryDataList_.Add(ihmd); } }
private void loadButton_Click(object sender, RoutedEventArgs e) { IndexTickerInfo item = this.definedIndexList_.SelectedItem as IndexTickerInfo; IndexHistoryMarketData ihmd = new IndexHistoryMarketData(item); DateTime sd = new DateTime(2014, 1, 1); DateTime ed = DateTime.Now; QLNet.TimeSeries <string> series = ihmd.historySeries(sd, ed); this.historyDataGrid_.ItemsSource = series; }
public void historyUnderData(XmlWriter xmlWriter, DateTime issueDate, DateTime referenceDate) { //MarketDataLoaderFactory.CreateMarketLoader( foreach (var item in this.Excel_underlyingInfo_paraViewModel_) { IndexHistoryMarketData ihmd = new IndexHistoryMarketData(item.KrCode_); QLNet.TimeSeries <string> series = new QLNet.TimeSeries <string>(); if (item.Excel_type_.ToUpper() == "INTERESTRATE") { series = ihmd.historyCurveSeriesMRO(issueDate, referenceDate); } else { series = ihmd.historySeriesMRO(issueDate, referenceDate); } xmlWriter.WriteStartElement("marketData"); xmlWriter.WriteElementString("krcode", item.KrCode_); xmlWriter.WriteElementString("name", item.UnderNameTrans_.Value_); xmlWriter.WriteStartElement("dataValueInfo"); foreach (var itemData in series) { xmlWriter.WriteStartElement("dataValue"); DateTime d = itemData.Key; xmlWriter.WriteElementString("date", d.ToString("yyyy-MM-dd")); xmlWriter.WriteElementString("value", itemData.Value); xmlWriter.WriteEndElement(); } xmlWriter.WriteEndElement(); xmlWriter.WriteEndElement(); } }
public string historyUnderData(DateTime effectiveDate, DateTime referenceDate, bool bodyOnly = false) { //Dictionary<string, QLNet.TimeSeries<string>> dataList = new Dictionary<string, QLNet.TimeSeries<string>>(); StringBuilder sb = new StringBuilder(); XmlWriterSettings setting = new XmlWriterSettings(); setting.Indent = true; //setting.Encoding = Encoding.UTF8; if (bodyOnly == true) setting.OmitXmlDeclaration = true; XmlWriter xmlWriter = XmlWriter.Create(sb, setting); xmlWriter.WriteProcessingInstruction("xml", "version='1.0' encoding='UTF-8'"); xmlWriter.WriteStartElement("hisoryData"); foreach (var item in this.excel_underlyingInfoViewModel_) { IndexHistoryMarketData ihmd = new IndexHistoryMarketData(item.KrCode_); QLNet.TimeSeries<string> series = new QLNet.TimeSeries<string>(); if (item.Excel_type_.ToUpper() == "INTERESTRATE" || item.Excel_type_.ToUpper() == "EXCEL_INTERESTRATE") { ihmd.Tenor_ = ((Excel_interestRateViewModel)item).Tenor_; ihmd.LinkedCurveCode_ = ((Excel_interestRateViewModel)item).LinkedCurveCode_; series = ihmd.historyCurveSeriesMRO(effectiveDate, referenceDate); } else { series = ihmd.historySeriesMRO(effectiveDate, referenceDate); } xmlWriter.WriteStartElement("marketData"); xmlWriter.WriteElementString("krcode", item.KrCode_); xmlWriter.WriteElementString("name", item.NameTrans_.Value_); xmlWriter.WriteStartElement("dataValueInfo"); foreach (var itemData in series) { xmlWriter.WriteStartElement("dataValue"); DateTime d = itemData.Key; xmlWriter.WriteElementString("date", d.ToString("yyyy-MM-dd")); xmlWriter.WriteElementString("value", itemData.Value); xmlWriter.WriteEndElement(); } xmlWriter.WriteEndElement(); xmlWriter.WriteEndElement(); } xmlWriter.WriteEndElement(); xmlWriter.Close(); return sb.ToString(); }
private void loadButton_Click(object sender, RoutedEventArgs e) { IndexTickerInfo item = this.definedIndexList_.SelectedItem as IndexTickerInfo; IndexHistoryMarketData ihmd = new IndexHistoryMarketData(item); DateTime sd = new DateTime(2014, 1, 1); DateTime ed = DateTime.Now; QLNet.TimeSeries<string> series = ihmd.historySeries(sd, ed); this.historyDataGrid_.ItemsSource = series; }
public void loadHistoryData(DateTime sDate, DateTime eDate) { this.marketDataList_ = new List<IndexMarketData>(); WebClient webClient = new WebClient(); StringBuilder sb = new StringBuilder(); string s_year = (sDate.Year).ToString(); string s_month = (sDate.Month -1).ToString(); string s_day = (sDate.Day).ToString(); string e_year = (eDate.Year).ToString(); string e_month = (eDate.Month - 1).ToString(); string e_day = (eDate.Day).ToString(); foreach (var item in this.indexYahooTickerList_) { sb.Clear(); sb.Append("http://ichart.yahoo.com/table.csv?s=%40%5EDJI," + item.Yahoo_ticker_ + "&a=" + s_month + "&b=" + s_day + "&c=" + s_year + "&d=" + e_month + "&e=" + e_day + "&f=" + e_year + "&g=d&ignore=.csv"); IndexHistoryMarketData ihmd = new IndexHistoryMarketData(item); string dataURL = sb.ToString(); Stream stream = webClient.OpenRead(dataURL); StreamReader reader = new StreamReader(stream); // 처음 한줄은 건너뜀 var line = reader.ReadLine(); while (!reader.EndOfStream) { line = reader.ReadLine(); var values = line.Split(','); DateTime d = DateTime.Parse(values[0]); ihmd.TimeSeries_.Add(d.ToString("yyyyMMdd"), values[4]); } stream.Close(); reader.Close(); this.marketHistoryDataList_.Add(ihmd); } }
public void historyUnderData(XmlWriter xmlWriter, DateTime issueDate, DateTime referenceDate) { //MarketDataLoaderFactory.CreateMarketLoader( foreach (var item in this.Excel_underlyingInfo_paraViewModel_) { IndexHistoryMarketData ihmd = new IndexHistoryMarketData(item.KrCode_); QLNet.TimeSeries<string> series = new QLNet.TimeSeries<string>(); if (item.Excel_type_.ToUpper() == "INTERESTRATE") { series = ihmd.historyCurveSeriesMRO(issueDate, referenceDate); } else { series = ihmd.historySeriesMRO(issueDate, referenceDate); } xmlWriter.WriteStartElement("marketData"); xmlWriter.WriteElementString("krcode", item.KrCode_); xmlWriter.WriteElementString("name", item.UnderNameTrans_.Value_); xmlWriter.WriteStartElement("dataValueInfo"); foreach (var itemData in series) { xmlWriter.WriteStartElement("dataValue"); DateTime d = itemData.Key; xmlWriter.WriteElementString("date", d.ToString("yyyy-MM-dd")); xmlWriter.WriteElementString("value", itemData.Value); xmlWriter.WriteEndElement(); } xmlWriter.WriteEndElement(); xmlWriter.WriteEndElement(); } }
public string historyUnderData(DateTime effectiveDate, DateTime referenceDate, bool bodyOnly = false) { //Dictionary<string, QLNet.TimeSeries<string>> dataList = new Dictionary<string, QLNet.TimeSeries<string>>(); StringBuilder sb = new StringBuilder(); XmlWriterSettings setting = new XmlWriterSettings(); setting.Indent = true; //setting.Encoding = Encoding.UTF8; if (bodyOnly == true) { setting.OmitXmlDeclaration = true; } XmlWriter xmlWriter = XmlWriter.Create(sb, setting); xmlWriter.WriteProcessingInstruction("xml", "version='1.0' encoding='UTF-8'"); xmlWriter.WriteStartElement("hisoryData"); foreach (var item in this.excel_underlyingInfoViewModel_) { IndexHistoryMarketData ihmd = new IndexHistoryMarketData(item.KrCode_); QLNet.TimeSeries <string> series = new QLNet.TimeSeries <string>(); if (item.Excel_type_.ToUpper() == "INTERESTRATE" || item.Excel_type_.ToUpper() == "EXCEL_INTERESTRATE") { ihmd.Tenor_ = ((Excel_interestRateViewModel)item).Tenor_; ihmd.LinkedCurveCode_ = ((Excel_interestRateViewModel)item).LinkedCurveCode_; series = ihmd.historyCurveSeriesMRO(effectiveDate, referenceDate); } else { series = ihmd.historySeriesMRO(effectiveDate, referenceDate); } xmlWriter.WriteStartElement("marketData"); xmlWriter.WriteElementString("krcode", item.KrCode_); xmlWriter.WriteElementString("name", item.NameTrans_.Value_); xmlWriter.WriteStartElement("dataValueInfo"); foreach (var itemData in series) { xmlWriter.WriteStartElement("dataValue"); DateTime d = itemData.Key; xmlWriter.WriteElementString("date", d.ToString("yyyy-MM-dd")); xmlWriter.WriteElementString("value", itemData.Value); xmlWriter.WriteEndElement(); } xmlWriter.WriteEndElement(); xmlWriter.WriteEndElement(); } xmlWriter.WriteEndElement(); xmlWriter.Close(); return(sb.ToString()); }