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