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 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(); }
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()); }