private void marketDataCheck(DateTime calcDate)
{
//bool isExist = false;
clsHDAT_CURVEDATA_TB clstb = new clsHDAT_CURVEDATA_TB();
clstb.REF_DT = calcDate.ToString("yyyyMMdd");
DataTable tb = clstb.Select();
if (tb.Rows.Count == 0)
{
throw new Exception("Curve Data does not exist : " + calcDate.ToString("yyyyMMdd"));
}
}
public void loadCurveData(DateTime refDate, string curveID ,clsHDAT_CURVEDATA_TB.RATE_TYP_Type type)
{
this.ReferenceDate_ = refDate;
this.ResultCuveData_.Clear();
this.DAO_.REF_DT = refDate.ToString("yyyyMMdd");
this.DAO_.CURVE_CD = curveID;
this.DAO_.RATE_TYP = (int)type;
DataTable tb = this.DAO_.Select();
if (tb.Rows.Count == 0)
{ throw new NoMarketDataExistException(this.DAO_.REF_DT, curveID,this.DAO_.QuaryLog_); }
foreach ( DataRow dr in tb.Select() )
{
this.ResultCuveData_.Add(clsHDAT_CURVEDATA_TB.Create(dr));
}
}
private void Button_Click(object sender, RoutedEventArgs e)
{
clsTRADABLE_OTC_VANILLA_IRS_TB clstb
= this.availableTradeListView_.SelectedItem as clsTRADABLE_OTC_VANILLA_IRS_TB;
clsHDAT_CURVEDATA_TB clstb_curve = new clsHDAT_CURVEDATA_TB();
clstb_curve.REF_DT = this.ViewModel_.HedgeTradingViewModel_.TradingDate_.ToString("yyyyMMdd");
clstb_curve.CURVE_CD = "IRSKRW";
clstb_curve.TENOR = "120M";
clstb_curve.RATE_TYP = 1;
clstb_curve.SelectOwn();
this.PriceTB_.Text = clstb_curve.RATE.ToString();
}
public void buildTestData()
{
clsHDAT_CURVEDATA_TB clsTB = new clsHDAT_CURVEDATA_TB();
//string[] depositePeriodStr = {"3M","6M","9M","12M"};
//string[] swapPeriodStr =
string[] depositeTenor = { "3M" };
string[] swapTenor = { "1Y","2Y", "3Y", "4Y", "5Y", "7Y", "10Y","12Y", "15Y", "20Y" };
string[][] rateList = {
new string[] { "0.0269","0.0278","0.028775","0.02983","0.03053","0.0312","0.03243","0.03368","0.034","0.03415","0.0352" },
#region data
new string[] { "0.0269","0.02758","0.0285","0.02948","0.03018","0.0309","0.03203","0.0333","0.0336","0.03375","0.0348" },
new string[] { "0.0269","0.0275","0.028475","0.0295","0.030175","0.0309","0.03205","0.033275","0.033575","0.033725","0.034775" },
new string[] { "0.0269","0.02745","0.028425","0.02948","0.03023","0.031","0.0321","0.03328","0.03355","0.0337","0.03475" },
new string[] { "0.0269","0.02748","0.028425","0.02955","0.0304","0.03125","0.03248","0.03363","0.033925","0.034075","0.035125" },
new string[] { "0.0269","0.02753","0.028625","0.0299","0.03088","0.03188","0.03323","0.0345","0.03485","0.035025","0.036075" },
new string[] { "0.0269","0.0275","0.0286","0.02983","0.03078","0.03173","0.03305","0.03428","0.034625","0.0348","0.03585" },
new string[] { "0.0269","0.02728","0.028375","0.02953","0.03045","0.0314","0.03273","0.034","0.03435","0.034525","0.035575" },
new string[] { "0.0269","0.027075","0.027875","0.02875","0.02955","0.03035","0.03165","0.032925","0.033275","0.03345","0.0345" },
new string[] { "0.0269","0.02718","0.028","0.02878","0.0295","0.03023","0.03153","0.0328","0.03325","0.033425","0.034475" },
new string[] { "0.0269","0.02733","0.02815","0.02905","0.02978","0.03055","0.03185","0.03313","0.0335","0.033675","0.034725" },
new string[] { "0.0269","0.02728","0.0281","0.029","0.02973","0.0305","0.03183","0.03313","0.0335","0.03365","0.0347" },
new string[] { "0.0269","0.02738","0.0282","0.02918","0.02998","0.0308","0.03213","0.03345","0.033825","0.033975","0.035025" },
new string[] { "0.0269","0.02718","0.0279","0.02878","0.02958","0.03038","0.0317","0.03305","0.033375","0.033525","0.034575" },
new string[] { "0.0267","0.02705","0.027825","0.02868","0.0295","0.0303","0.03168","0.03305","0.033375","0.033525","0.034625" },
new string[] { "0.0267","0.02705","0.027775","0.028575","0.02935","0.03015","0.0315","0.032875","0.0332","0.033325","0.034475" },
new string[] { "0.0267","0.02715","0.0279","0.028725","0.029475","0.03025","0.0316","0.03295","0.033275","0.0334","0.03455" },
new string[] { "0.0267","0.027213","0.028075","0.028925","0.029728","0.03048","0.03182","0.0332","0.033525","0.0337","0.03485" },
new string[] { "0.0266","0.02738","0.0284","0.0294","0.03025","0.03113","0.032538","0.03395","0.03425","0.034425","0.035575" },
new string[] { "0.0266","0.02735","0.028375","0.02935","0.0302","0.031075","0.032475","0.0339","0.034225","0.0344","0.03555" },
new string[] { "0.0266","0.02715","0.028215","0.02915","0.02995","0.03075","0.03215","0.0336","0.033925","0.0341","0.035325" },
new string[] { "0.0266","0.02725","0.0283","0.02935","0.03015","0.03095","0.032363","0.033788","0.034075","0.0342","0.035425" },
new string[] { "0.0266","0.027235","0.0285","0.029573","0.030378","0.03121","0.032638","0.034038","0.0343","0.03445","0.035725" },
new string[] { "0.0266","0.02727","0.028525","0.029525","0.03037","0.0312","0.032578","0.03403","0.03435","0.0345","0.035775" },
new string[] { "0.0266","0.02747","0.028825","0.030175","0.03104","0.0319","0.03335","0.034803","0.035","0.03515","0.036425" },
new string[] { "0.0266","0.02727","0.0285","0.02965","0.03045","0.0313","0.032713","0.03418","0.0345","0.03465","0.035975" },
new string[] { "0.0266","0.0272","0.028425","0.029588","0.03045","0.03125","0.032688","0.03415","0.034425","0.034575","0.0359" },
new string[] { "0.0266","0.02725","0.0286","0.02975","0.03068","0.03158","0.033025","0.03445","0.034775","0.034925","0.03625" },
new string[] { "0.0266","0.02713","0.028475","0.0296","0.03055","0.03145","0.032863","0.034375","0.034675","0.034775","0.0361" },
new string[] { "0.0266","0.027188","0.0285","0.029663","0.030663","0.031588","0.033038","0.034438","0.034725","0.034825","0.03615" },
new string[] { "0.0266","0.02715","0.028325","0.02945","0.0304","0.0313","0.032688","0.034","0.034275","0.034375","0.0357" },
new string[] { "0.0266","0.02722","0.028475","0.02963","0.03065","0.0316","0.03298","0.03425","0.034525","0.034625","0.03595" },
new string[] { "0.0266","0.02745","0.02875","0.03005","0.031075","0.032075","0.033588","0.035075","0.03535","0.03545","0.036775" },
new string[] { "0.0266","0.0274","0.02875","0.03","0.03105","0.03205","0.033575","0.03505","0.03535","0.03545","0.036775" },
new string[] { "0.0266","0.027488","0.0289","0.03025","0.031363","0.032375","0.033988","0.035575","0.035875","0.035975","0.037375" },
new string[] { "0.0266","0.0276","0.029225","0.0307","0.031863","0.0331","0.034675","0.0363","0.036575","0.036675","0.038075" },
new string[] { "0.0266","0.027363","0.0288","0.030163","0.031363","0.03245","0.0339","0.03545","0.035775","0.0358","0.037275" },
new string[] { "0.0266","0.027375","0.02885","0.0302","0.031375","0.032475","0.034","0.03555","0.035875","0.035925","0.0374" },
new string[] { "0.0266","0.027525","0.029025","0.030475","0.031775","0.032925","0.034475","0.03605","0.036375","0.036425","0.0379" },
new string[] { "0.0266","0.027425","0.0288","0.030363","0.03162","0.032813","0.034363","0.035888","0.036175","0.036225","0.0377" },
new string[] { "0.0266","0.027188","0.0286","0.029963","0.03125","0.032313","0.033838","0.035338","0.03575","0.0358","0.037275" },
new string[] { "0.0266","0.02725","0.028625","0.0301","0.03135","0.03245","0.0339","0.03535","0.035725","0.035775","0.03725" },
new string[] { "0.0266","0.027288","0.028525","0.02988","0.03105","0.03215","0.0336","0.0349","0.035275","0.035325","0.0368" },
new string[] { "0.0266","0.0272","0.028475","0.0298","0.031","0.032","0.0334","0.0349","0.0352","0.03525","0.036725" },
new string[] { "0.0266","0.0272","0.02835","0.02957","0.03068","0.031538","0.03305","0.03448","0.0348","0.03485","0.036325" },
new string[] { "0.0266","0.0273","0.02855","0.029875","0.031","0.031988","0.033488","0.034963","0.035175","0.035225","0.0367" },
new string[] { "0.0266","0.0274","0.028625","0.02988","0.03097","0.03198","0.03345","0.035","0.035375","0.035425","0.0369" },
new string[] { "0.0266","0.0275","0.028775","0.03005","0.03125","0.032213","0.03378","0.035325","0.035725","0.0358","0.037275" },
new string[] { "0.0266","0.027675","0.02915","0.030575","0.03175","0.032775","0.03435","0.035975","0.0363","0.036375","0.03785" },
new string[] { "0.0266","0.027675","0.0292","0.03055","0.031738","0.032715","0.03429","0.03589","0.036225","0.0363","0.037775" },
new string[] { "0.0266","0.02747","0.02895","0.03015","0.0312","0.0321","0.03355","0.034975","0.03535","0.035425","0.0369" },
new string[] { "0.0266","0.02755","0.029125","0.03035","0.03145","0.0321","0.03385","0.035275","0.035575","0.03565","0.037125" },
new string[] { "0.0266","0.02747","0.029025","0.03023","0.03117","0.03195","0.03331","0.034675","0.035025","0.0351","0.036575" },
new string[] { "0.0266","0.02747","0.028975","0.03008","0.0309","0.03162","0.033","0.034375","0.034775","0.03485","0.036325" },
new string[] { "0.0266","0.0276","0.0291","0.03025","0.03115","0.03195","0.0333","0.03475","0.035025","0.0351","0.036575" },
new string[] { "0.0266","0.027475","0.02875","0.029825","0.03065","0.031425","0.03277","0.0342","0.034525","0.0346","0.0361" },
new string[] { "0.0266","0.027425","0.028475","0.029475","0.030255","0.031","0.0324","0.0339","0.0342","0.034275","0.035775" },
new string[] { "0.0266","0.02735","0.028475","0.029475","0.030275","0.030975","0.032375","0.03385","0.0342","0.034275","0.035775" },
new string[] { "0.0266","0.02735","0.028475","0.029475","0.030275","0.030975","0.032375","0.03385","0.0342","0.034275","0.035775" },
new string[] { "0.0266","0.02735","0.028475","0.029475","0.030275","0.030975","0.032375","0.03385","0.0342","0.034275","0.035775" },
new string[] { "0.0266","0.02715","0.02795","0.028775","0.0295","0.030125","0.031525","0.033025","0.0334","0.033475","0.034975" },
new string[] { "0.0266","0.0271","0.027925","0.0288","0.0295","0.03015","0.031538","0.033113","0.033475","0.033575","0.035075" },
new string[] { "0.0266","0.02725","0.028075","0.02892","0.02968","0.03035","0.03178","0.03332","0.0337","0.0338","0.0353" },
new string[] { "0.0266","0.02735","0.028175","0.02915","0.02995","0.03065","0.03205","0.03365","0.03395","0.03405","0.03555" },
new string[] { "0.0266","0.027338","0.028075","0.02903","0.029913","0.030635","0.03198","0.0335","0.033775","0.03385","0.03535" },
new string[] { "0.0266","0.0272","0.027975","0.0289","0.029725","0.0305","0.031925","0.033375","0.0337","0.033775","0.035275" },
new string[] { "0.0266","0.027275","0.02815","0.0291","0.02995","0.03075","0.03215","0.0336","0.033925","0.034","0.0355" },
new string[] { "0.0266","0.0272","0.028025","0.02895","0.029775","0.0305","0.0319","0.03335","0.033675","0.03375","0.03525" },
new string[] { "0.0266","0.0272","0.028025","0.02895","0.029775","0.0305","0.0319","0.03335","0.033675","0.03375","0.03525" },
new string[] { "0.0266","0.027175","0.028","0.0289","0.029725","0.03045","0.03185","0.0333","0.033625","0.033725","0.035225" },
new string[] { "0.0266","0.027175","0.0279","0.028825","0.02965","0.0304","0.0318","0.0333","0.033625","0.0337","0.0352" },
new string[] { "0.0266","0.027225","0.028025","0.028975","0.02985","0.030625","0.032025","0.033525","0.03385","0.03395","0.03545" },
new string[] { "0.0266","0.027225","0.028025","0.028975","0.02985","0.030625","0.032025","0.033525","0.03385","0.03395","0.03545" },
new string[] { "0.0266","0.02725","0.02825","0.029275","0.030225","0.031075","0.0325","0.03405","0.034375","0.034475","0.035975" },
new string[] { "0.0266","0.0272","0.028175","0.0292","0.030175","0.03105","0.032425","0.033975","0.0343","0.0344","0.0359" },
new string[] { "0.0266","0.0273","0.0283","0.02936","0.03035","0.031225","0.0326","0.034125","0.03445","0.03455","0.03605" },
new string[] { "0.0266","0.02725","0.028225","0.0293","0.0303","0.03115","0.032525","0.033975","0.0343","0.0344","0.0359" },
new string[] { "0.0266","0.027275","0.028175","0.02925","0.030225","0.031075","0.03245","0.0339","0.0342","0.034325","0.035825" },
new string[] { "0.0266","0.027225","0.028","0.029025","0.02995","0.03075","0.0321","0.03345","0.033775","0.03385","0.03535" },
new string[] { "0.0266","0.027125","0.027825","0.02875","0.029625","0.030375","0.03165","0.03295","0.033275","0.033375","0.034875" },
new string[] { "0.0266","0.02715","0.027875","0.0288","0.02965","0.030375","0.031675","0.032985","0.033325","0.033425","0.034925" },
new string[] { "0.0266","0.027125","0.027825","0.028725","0.02955","0.030275","0.031575","0.03295","0.033275","0.033375","0.034875" },
new string[] { "0.0266","0.026975","0.0275","0.02825","0.0289","0.029525","0.030775","0.032175","0.0325","0.0326","0.0341" },
new string[] { "0.0266","0.027","0.027525","0.028325","0.029","0.029625","0.03085","0.03225","0.03255","0.03265","0.03415" },
new string[] { "0.0266","0.026975","0.0275","0.028275","0.02895","0.029575","0.0308","0.032225","0.032525","0.032625","0.034125" },
new string[] { "0.0266","0.02705","0.027675","0.028475","0.0292","0.02985","0.0311","0.032525","0.032825","0.032925","0.034425" },
new string[] { "0.026505","0.026875","0.027475","0.028275","0.028975","0.0296","0.030825","0.032275","0.032575","0.03265","0.03415" },
new string[] { "0.026503","0.026875","0.027475","0.028275","0.02895","0.02955","0.030775","0.032175","0.032475","0.032575","0.034075" },
new string[] { "0.0265","0.027","0.027675","0.028525","0.029275","0.029925","0.031175","0.032575","0.032875","0.032975","0.034475" },
new string[] { "0.0265","0.027088","0.027825","0.028763","0.029575","0.030275","0.0315","0.032925","0.033225","0.033325","0.034875" },
new string[] { "0.0265","0.027275","0.02805","0.028975","0.0298","0.030525","0.031825","0.033175","0.033475","0.03355","0.03505" },
new string[] { "0.0265","0.027225","0.028075","0.0291","0.03","0.03075","0.0321","0.03345","0.03375","0.033825","0.035325" },
new string[] { "0.0265","0.0272","0.028075","0.0291","0.03","0.030775","0.0321","0.033475","0.033775","0.033875","0.035375" },
new string[] { "0.0265","0.027175","0.0281","0.029175","0.0301","0.030875","0.0322","0.033575","0.033875","0.033975","0.035475" },
new string[] { "0.0265","0.0271","0.02795","0.028975","0.029775","0.030475","0.03175","0.033075","0.0334","0.0335","0.035" },
new string[] { "0.0265","0.027325","0.028425","0.029525","0.030475","0.031275","0.0325","0.033875","0.034175","0.034275","0.035775" },
new string[] { "0.0265","0.027275","0.0284","0.0295","0.030475","0.031325","0.03265","0.034025","0.034325","0.034425","0.035925" },
new string[] { "0.0265","0.027175","0.028275","0.029425","0.030375","0.0312","0.0325","0.0339","0.0342","0.034325","0.035825" },
new string[] { "0.0265","0.0272","0.028225","0.029425","0.030375","0.0312","0.0325","0.033925","0.034225","0.03435","0.03585" },
new string[] { "0.0265","0.027225","0.028225","0.02945","0.03045","0.03125","0.032525","0.03395","0.03425","0.034375","0.035875" },
new string[] { "0.0265","0.0272","0.0282","0.029425","0.03045","0.031275","0.03255","0.03395","0.03425","0.0344","0.0359" },
new string[] { "0.0265","0.02725","0.028325","0.0296","0.030675","0.0315","0.0328","0.034225","0.034525","0.034675","0.036175" },
new string[] { "0.0265","0.027225","0.028325","0.0296","0.030675","0.031525","0.032825","0.03425","0.03455","0.0347","0.0362" },
new string[] { "0.0265","0.02725","0.02845","0.029825","0.030975","0.031875","0.033205","0.03465","0.03495","0.035125","0.036625" },
new string[] { "0.0265","0.02725","0.02855","0.029825","0.031088","0.031988","0.03325","0.0347","0.035","0.035163","0.036688" },
new string[] { "0.0265","0.0272","0.0284","0.02975","0.030925","0.031825","0.033175","0.034575","0.034875","0.03505","0.03655" },
new string[] { "0.0265","0.027175","0.028375","0.029725","0.03085","0.03175","0.0331","0.0345","0.0348","0.034975","0.036475" },
new string[] { "0.0265","0.027175","0.02835","0.0297","0.030825","0.0317","0.03305","0.034375","0.034675","0.03485","0.03635" },
new string[] { "0.0265","0.02825","0.02945","0.030775","0.031875","0.032775","0.0331","0.034425","0.034725","0.0349","0.0364" },
new string[] { "0.0265","0.027285","0.028535","0.02989","0.031013","0.031913","0.033225","0.034563","0.034863","0.035025","0.036515" },
new string[] { "0.0265","0.027425","0.02875","0.030125","0.031275","0.0322","0.03355","0.034925","0.035225","0.0354","0.0369" },
new string[] { "0.0265","0.02745","0.028775","0.03015","0.0313","0.032225","0.033575","0.03495","0.03525","0.035425","0.036925" },
new string[] { "0.0265","0.027375","0.02875","0.030125","0.031275","0.032175","0.033525","0.0349","0.0352","0.035425","0.036925" },
new string[] { "0.0265","0.027375","0.02885","0.030275","0.03145","0.0324","0.0338","0.03525","0.0356","0.035825","0.037325" },
new string[] { "0.0265","0.0273","0.0288","0.030175","0.031375","0.032238","0.033625","0.035075","0.0355","0.035713","0.037213" },
new string[] { "0.0265","0.027125","0.028525","0.029925","0.031125","0.03205","0.03345","0.03485","0.0352","0.035425","0.036925" },
new string[] { "0.0265","0.0271","0.0285","0.029875","0.031075","0.032025","0.033425","0.034825","0.035175","0.0354","0.0369" },
new string[] { "0.0265","0.027175","0.02855","0.0299","0.0311","0.032025","0.0334","0.034775","0.035125","0.03535","0.03685" },
new string[] { "0.0265","0.027175","0.028525","0.0299","0.0311","0.03205","0.033425","0.0348","0.03515","0.035375","0.036875" },
new string[] { "0.0265","0.027125","0.028375","0.0297","0.030875","0.0318","0.033163","0.034575","0.034925","0.03515","0.03665" },
new string[] { "0.0265","0.027075","0.0282","0.02955","0.0307","0.031575","0.032975","0.034375","0.034725","0.03495","0.03645" },
new string[] { "0.0265","0.027025","0.0281","0.029375","0.0305","0.03135","0.032675","0.03405","0.0344","0.034625","0.036125" },
new string[] { "0.0265","0.027075","0.0281","0.029325","0.030425","0.0313","0.032625","0.034","0.03435","0.034575","0.036075" },
new string[] { "0.0265","0.027075","0.02825","0.0295","0.030675","0.031625","0.033","0.034375","0.034725","0.03495","0.03645" },
new string[] { "0.0265","0.027088","0.028263","0.02955","0.030775","0.031725","0.033075","0.034475","0.034763","0.035025","0.036525" },
new string[] { "0.0265","0.027075","0.02815","0.029325","0.030525","0.031475","0.032825","0.034225","0.034575","0.034775","0.036275" },
new string[] { "0.0265","0.0271","0.02815","0.0293","0.0305","0.031475","0.032825","0.034225","0.034575","0.034775","0.036275" },
new string[] { "0.0265","0.0271","0.02815","0.0293","0.0305","0.031475","0.032825","0.034225","0.034575","0.034775","0.036275" },
new string[] { "0.0265","0.027125","0.0282","0.02935","0.03055","0.031525","0.032875","0.034275","0.034625","0.034825","0.036325" },
new string[] { "0.0265","0.027","0.02805","0.0292","0.03035","0.0313","0.032713","0.034075","0.0344","0.0346","0.0361" },
new string[] { "0.0266","0.0271","0.0282","0.029375","0.030525","0.031525","0.0329","0.0343","0.03465","0.0348","0.0363" },
new string[] { "0.0266","0.0271","0.0282","0.029375","0.030525","0.031525","0.0329","0.0343","0.03465","0.0348","0.0363" },
new string[] { "0.0266","0.0271","0.0282","0.029375","0.030525","0.031525","0.0329","0.0343","0.03465","0.0348","0.0363" },
new string[] { "0.0266","0.027225","0.028525","0.029825","0.031075","0.032125","0.033525","0.03495","0.03535","0.035525","0.037025" },
new string[] { "0.0266","0.02725","0.028475","0.0298","0.03105","0.0321","0.033525","0.035","0.03535","0.035635","0.03705" },
new string[] { "0.0266","0.02665","0.0278","0.029175","0.030575","0.03165","0.0331","0.03455","0.03495","0.0351","0.0366" },
new string[] { "0.0266","0.026625","0.0277","0.02905","0.030425","0.03155","0.03305","0.034525","0.03495","0.035125","0.036625" },
new string[] { "0.0266","0.026575","0.027625","0.028925","0.030275","0.031375","0.0329","0.0344","0.034825","0.035","0.0365" },
new string[] { "0.0265","0.026725","0.0279","0.029225","0.03055","0.031675","0.033125","0.034575","0.035","0.035175","0.036675" },
new string[] { "0.0265","0.026825","0.027925","0.029213","0.030475","0.031563","0.032988","0.03455","0.034875","0.035075","0.036575" },
new string[] { "0.0265","0.026725","0.027825","0.02905","0.030275","0.0313","0.0327","0.034125","0.0345","0.03465","0.03615" },
new string[] { "0.0265","0.026775","0.027925","0.02915","0.030375","0.0314","0.032825","0.03425","0.034625","0.034775","0.036275" },
new string[] { "0.0265","0.026825","0.028","0.029225","0.030475","0.031575","0.033025","0.03445","0.03485","0.034975","0.036475" },
new string[] { "0.0265","0.02675","0.02785","0.029075","0.0303","0.031375","0.032825","0.03425","0.03465","0.034775","0.036275" },
new string[] { "0.0265","0.026775","0.027825","0.029088","0.030275","0.03135","0.032875","0.034225","0.034625","0.03485","0.03635" },
new string[] { "0.0265","0.026775","0.0279","0.029125","0.0303","0.0314","0.032925","0.03435","0.0347","0.034875","0.036375" },
new string[] { "0.0265","0.026775","0.027975","0.029225","0.0304","0.031525","0.03305","0.0345","0.03485","0.03505","0.03655" },
new string[] { "0.0265","0.026775","0.028","0.029275","0.030475","0.0316","0.033125","0.0346","0.03495","0.035175","0.036675" },
new string[] { "0.0265","0.026775","0.0279","0.029125","0.0303","0.0314","0.032925","0.034375","0.034725","0.034975","0.03645" },
new string[] { "0.0265","0.02664","0.027575","0.028763","0.029875","0.0309","0.032375","0.0338","0.034113","0.0344","0.035725" },
new string[] { "0.0265","0.02665","0.02765","0.028825","0.029825","0.030825","0.0323","0.0337","0.03405","0.0343","0.03565" },
new string[] { "0.0265","0.026675","0.0276","0.02875","0.02975","0.030725","0.0322","0.033625","0.033975","0.034225","0.035575" },
new string[] { "0.0265","0.0267","0.0277","0.028913","0.029925","0.03085","0.032375","0.03375","0.034175","0.034413","0.035775" },
new string[] { "0.0265","0.026725","0.027725","0.028875","0.029875","0.030875","0.03235","0.033775","0.034125","0.034375","0.035725" },
new string[] { "0.0265","0.026725","0.027725","0.028875","0.029875","0.030875","0.03235","0.033775","0.034125","0.034375","0.035725" },
new string[] { "0.0265","0.0267","0.02765","0.028775","0.029775","0.030725","0.032175","0.0336","0.03395","0.0342","0.03555" },
new string[] { "0.0265","0.026575","0.02735","0.02835","0.0293","0.030225","0.03165","0.03305","0.0334","0.03365","0.035" },
new string[] { "0.0265","0.0266","0.0274","0.028375","0.029325","0.03025","0.031675","0.03305","0.0334","0.03365","0.035" },
new string[] { "0.0265","0.026575","0.027425","0.0284","0.02935","0.030275","0.031675","0.03305","0.0334","0.033675","0.035025" },
new string[] { "0.0265","0.026625","0.027513","0.02855","0.029513","0.03055","0.032025","0.0334","0.033625","0.033925","0.03535" },
new string[] { "0.0265","0.026575","0.02745","0.028475","0.02945","0.03045","0.031875","0.03325","0.0336","0.0339","0.03525" },
new string[] { "0.0265","0.02655","0.027375","0.02835","0.0293","0.030275","0.031675","0.03305","0.0334","0.033725","0.035075" },
new string[] { "0.0265","0.026525","0.027425","0.028425","0.0294","0.030325","0.0317","0.033075","0.033425","0.03375","0.0351" },
new string[] { "0.0265","0.026525","0.02735","0.0283","0.0292","0.030075","0.0314","0.032725","0.0331","0.03345","0.0348" },
new string[] { "0.0265","0.02655","0.02742","0.02835","0.02915","0.03","0.03128","0.03255","0.03295","0.03335","0.03477" },
new string[] { "0.0265","0.026575","0.027525","0.02845","0.02925","0.03005","0.0313","0.032575","0.032975","0.033325","0.034575" },
new string[] { "0.0265","0.0266","0.027625","0.028625","0.0295","0.030325","0.0316","0.03285","0.03325","0.033575","0.034825" },
new string[] { "0.0265","0.0266","0.027625","0.0286","0.02945","0.0302","0.03145","0.032675","0.033075","0.0334","0.03465" },
new string[] { "0.0265","0.0266","0.027625","0.0286","0.029425","0.0302","0.031425","0.032625","0.033","0.033325","0.034575" },
new string[] { "0.0265","0.02665","0.02775","0.028763","0.029575","0.0304","0.031763","0.0329","0.033363","0.033625","0.0349" },
new string[] { "0.0265","0.0266","0.0277","0.028675","0.029475","0.030225","0.031475","0.0327","0.033075","0.033375","0.034575" },
new string[] { "0.0265","0.0266","0.027625","0.0286","0.029425","0.03015","0.031375","0.0326","0.03295","0.0332","0.0344" },
new string[] { "0.0265","0.026575","0.027575","0.028625","0.029525","0.030325","0.0316","0.032875","0.033225","0.033475","0.034675" },
new string[] { "0.0265","0.02655","0.02755","0.028575","0.029475","0.030275","0.03155","0.0328","0.03315","0.0334","0.0346" },
new string[] { "0.0265","0.026588","0.027588","0.028513","0.029475","0.03025","0.0315","0.032775","0.033163","0.0334","0.0346" },
new string[] { "0.0265","0.02685","0.027938","0.028975","0.02995","0.03075","0.032075","0.033438","0.033763","0.03405","0.03525" },
new string[] { "0.0265","0.02685","0.027925","0.029","0.029975","0.03085","0.03215","0.03345","0.0338","0.034075","0.035275" },
new string[] { "0.0265","0.0268","0.02785","0.028925","0.0299","0.030775","0.032025","0.033275","0.033625","0.0339","0.0351" },
new string[] { "0.0265","0.026775","0.0278","0.028875","0.02985","0.03075","0.031975","0.0332","0.03355","0.033825","0.035025" },
new string[] { "0.0265","0.026725","0.0278","0.028875","0.0299","0.030763","0.031938","0.033225","0.03355","0.033825","0.035025" },
new string[] { "0.0265","0.026775","0.027775","0.028875","0.02985","0.030725","0.0319","0.033125","0.033475","0.03375","0.03495" },
new string[] { "0.0265","0.0268","0.0278","0.0289","0.029875","0.03075","0.031975","0.0332","0.03355","0.033825","0.035025" },
new string[] { "0.0265","0.02675","0.027725","0.0288","0.02975","0.030625","0.0319","0.033175","0.033525","0.0338","0.035" },
new string[] { "0.0265","0.02675","0.0277","0.02875","0.0297","0.030575","0.03185","0.0331","0.03345","0.033725","0.034925" },
new string[] { "0.0265","0.026563","0.02735","0.028313","0.0292","0.03","0.031213","0.032413","0.032813","0.0331","0.0343" },
new string[] { "0.0265","0.0267","0.027625","0.028625","0.029525","0.030375","0.0316","0.032825","0.033175","0.03345","0.03465" },
new string[] { "0.0265","0.026675","0.0276","0.028575","0.029475","0.030325","0.031575","0.032875","0.033225","0.0335","0.0347" },
new string[] { "0.0265","0.02665","0.027525","0.028475","0.029375","0.0302","0.03145","0.03275","0.0331","0.033375","0.034575" },
new string[] { "0.0265","0.026775","0.027775","0.02875","0.02965","0.030475","0.031725","0.033","0.03335","0.033625","0.034825" },
new string[] { "0.0265","0.026825","0.027925","0.02895","0.02985","0.030675","0.03185","0.03319","0.033535","0.033825","0.035025" },
new string[] { "0.0265","0.026825","0.027975","0.029","0.0299","0.030725","0.031925","0.033225","0.033575","0.033875","0.035075" },
new string[] { "0.0265","0.0268","0.027925","0.02895","0.02985","0.03065","0.03185","0.033125","0.033475","0.033775","0.034975" },
new string[] { "0.0265","0.02685","0.028","0.029025","0.029925","0.030725","0.031925","0.033175","0.033525","0.033825","0.035025" },
new string[] { "0.0265","0.026825","0.027925","0.02895","0.02985","0.03065","0.031825","0.033075","0.033425","0.033725","0.034925" },
new string[] { "0.0265","0.0268","0.0279","0.0289","0.029725","0.0305","0.03165","0.032875","0.033225","0.033525","0.034725" },
new string[] { "0.0265","0.0268","0.027925","0.02895","0.029775","0.03055","0.0317","0.032925","0.033275","0.033575","0.034775" },
new string[] { "0.0265","0.02685","0.0281","0.02925","0.03015","0.03095","0.03215","0.03345","0.0338","0.034075","0.035275" },
new string[] { "0.0265","0.0268","0.02795","0.029","0.029875","0.03065","0.031875","0.03315","0.03355","0.033825","0.035025" },
new string[] { "0.0265","0.026825","0.027975","0.029","0.0299","0.030675","0.0319","0.033175","0.033575","0.03385","0.03505" },
new string[] { "0.0265","0.02675","0.027825","0.02885","0.029725","0.0305","0.03165","0.03285","0.03325","0.03355","0.03475" },
new string[] { "0.0265","0.02685","0.02795","0.02895","0.029825","0.0306","0.03175","0.032975","0.033375","0.033675","0.034875" },
new string[] { "0.0265","0.026875","0.02795","0.028875","0.029725","0.0305","0.03165","0.03285","0.03325","0.03355","0.03475" },
new string[] { "0.0265","0.02695","0.02805","0.02895","0.029775","0.03055","0.031675","0.032825","0.033225","0.03355","0.03475" },
new string[] { "0.0265","0.027025","0.028125","0.029025","0.02985","0.0306","0.0317","0.03285","0.03325","0.033575","0.034775" },
new string[] { "0.0265","0.027075","0.028175","0.0291","0.029925","0.03065","0.03175","0.0329","0.0333","0.033625","0.034825" },
new string[] { "0.0265","0.02705","0.028125","0.02905","0.0298","0.0305","0.03155","0.03265","0.03305","0.033375","0.034575" },
new string[] { "0.0265","0.0271","0.02825","0.029225","0.03","0.0307","0.03175","0.03285","0.03325","0.033575","0.034775" },
new string[] { "0.0265","0.0271","0.028275","0.02925","0.03005","0.030775","0.031825","0.032975","0.0334","0.033725","0.034925" },
new string[] { "0.0265","0.027075","0.0282","0.0292","0.030025","0.03075","0.0318","0.03295","0.033375","0.033725","0.034925" },
new string[] { "0.0265","0.0271","0.028225","0.029225","0.03005","0.030775","0.031825","0.032975","0.0334","0.03375","0.03495" },
new string[] { "0.0265","0.027075","0.0282","0.0292","0.030025","0.03075","0.031825","0.032975","0.0334","0.033725","0.034925" },
new string[] { "0.0265","0.027025","0.028075","0.02905","0.02985","0.030575","0.031625","0.032775","0.033225","0.033575","0.034775" },
new string[] { "0.0265","0.027025","0.028075","0.02905","0.029875","0.03055","0.0316","0.03275","0.0332","0.03355","0.03475" },
new string[] { "0.0265","0.027025","0.02805","0.029025","0.02985","0.030525","0.031575","0.032725","0.033175","0.0336","0.0348" },
new string[] { "0.0265","0.02695","0.028025","0.029","0.029825","0.0305","0.03155","0.03275","0.0332","0.033625","0.034825" },
new string[] { "0.0265","0.02695","0.028025","0.029","0.029825","0.0305","0.03155","0.03275","0.0332","0.033625","0.034825" },
new string[] { "0.0265","0.02685","0.02785","0.028825","0.02965","0.030325","0.03135","0.032575","0.033025","0.03345","0.03465" },
new string[] { "0.0265","0.02685","0.02785","0.028825","0.02965","0.030325","0.03135","0.032575","0.033025","0.03345","0.03465" },
new string[] { "0.0265","0.02685","0.02785","0.028825","0.02965","0.030325","0.03135","0.032575","0.033025","0.03345","0.03465" },
new string[] { "0.0265","0.02675","0.0277","0.028625","0.0294","0.030025","0.03105","0.032225","0.032675","0.033075","0.034275" },
new string[] { "0.0265","0.026775","0.027725","0.028625","0.0294","0.03","0.031","0.032175","0.032625","0.033","0.0342" },
new string[] { "0.0265","0.02675","0.0277","0.028485","0.02929","0.02989","0.030875","0.031963","0.03235","0.03279","0.03392" },
new string[] { "0.0265","0.02675","0.0277","0.02855","0.0293","0.029875","0.030875","0.032","0.03245","0.032825","0.034025" },
new string[] { "0.0265","0.0268","0.0278","0.02865","0.0294","0.029975","0.030975","0.032075","0.032525","0.0329","0.0341" },
new string[] { "0.0265","0.026775","0.02775","0.028625","0.029325","0.0299","0.03085","0.03195","0.032375","0.03275","0.03395" },
new string[] { "0.0265","0.0267","0.027525","0.028325","0.028975","0.029475","0.030325","0.031375","0.0318","0.032175","0.033375" },
new string[] { "0.0265","0.02675","0.027575","0.02835","0.02905","0.02955","0.03045","0.03145","0.0319","0.0323","0.0335" },
new string[] { "0.0265","0.02675","0.0276","0.0284","0.029075","0.0296","0.03045","0.0315","0.031925","0.0323","0.0335" },
new string[] { "0.0265","0.026775","0.02765","0.02845","0.02915","0.0297","0.03055","0.031625","0.03205","0.032425","0.033625" },
new string[] { "0.0265","0.026775","0.027625","0.02845","0.0291","0.02965","0.030475","0.03155","0.031975","0.03235","0.03355" },
new string[] { "0.0265","0.0268","0.02775","0.028575","0.02925","0.029825","0.030675","0.03175","0.032175","0.032575","0.033775" },
new string[] { "0.0265","0.026775","0.02765","0.02845","0.029075","0.0297","0.030525","0.031625","0.03205","0.03245","0.03365" },
new string[] { "0.0265","0.026775","0.02765","0.02845","0.029125","0.029675","0.030525","0.031625","0.03205","0.03245","0.03365" },
new string[] { "0.0265","0.0268","0.027675","0.028475","0.02915","0.0297","0.030575","0.031675","0.0321","0.0325","0.0337" },
new string[] { "0.0265","0.026725","0.0276","0.0284","0.029025","0.02955","0.030425","0.03155","0.031975","0.032375","0.033575" },
new string[] { "0.0265","0.0267","0.0275","0.028275","0.02885","0.02935","0.030175","0.0313","0.031725","0.032125","0.033325" },
new string[] { "0.0265","0.0267","0.027515","0.0283","0.0289","0.0294","0.03025","0.031375","0.0318","0.0322","0.0334" },
new string[] { "0.0265","0.026725","0.0276","0.0284","0.02905","0.029575","0.03045","0.0316","0.032025","0.032425","0.033625" },
new string[] { "0.0265","0.02675","0.027625","0.02845","0.029125","0.029675","0.03055","0.031725","0.03215","0.032525","0.033725" },
new string[] { "0.0265","0.02675","0.027625","0.02845","0.029125","0.029675","0.03055","0.031725","0.03215","0.032525","0.033725" },
new string[] { "0.0265","0.02675","0.027675","0.028488","0.029238","0.029763","0.030675","0.031875","0.03225","0.032625","0.033825" },
new string[] { "0.0265","0.026725","0.027675","0.0285","0.0292","0.029775","0.030675","0.031875","0.0323","0.032675","0.033875" },
new string[] { "0.0265","0.026675","0.027475","0.02825","0.028925","0.029475","0.030375","0.031575","0.032","0.032375","0.033575" },
new string[] { "0.0265","0.0267","0.027525","0.028325","0.029025","0.0296","0.030525","0.03175","0.032175","0.03255","0.03375" },
new string[] { "0.0265","0.0266","0.02725","0.028025","0.0287","0.02925","0.030175","0.0314","0.031825","0.0322","0.0334" },
new string[] { "0.0265","0.0263","0.0269","0.027625","0.0284","0.029025","0.03","0.031275","0.031675","0.032125","0.033325" },
new string[] { "0.0265","0.02625","0.026775","0.027525","0.028275","0.028925","0.02995","0.03125","0.031675","0.032075","0.033275" },
new string[] { "0.0265","0.026275","0.0268","0.02755","0.028275","0.0289","0.029925","0.0312","0.031625","0.032025","0.033225" },
new string[] { "0.0265","0.0263","0.026875","0.0276","0.028325","0.028925","0.02995","0.0312","0.031625","0.032","0.0332" },
new string[] { "0.0265","0.026175","0.0267","0.02735","0.02805","0.0286","0.0296","0.03085","0.031275","0.03165","0.03285" },
new string[] { "0.0265","0.025975","0.026425","0.02705","0.02775","0.028325","0.029275","0.030475","0.0309","0.031275","0.0325" },
new string[] { "0.0265","0.02603","0.02655","0.0272","0.0279","0.02845","0.02938","0.0306","0.03103","0.0314","0.0326" },
new string[] { "0.0265","0.026025","0.02655","0.0272","0.027875","0.0284","0.0293","0.030475","0.0309","0.0313","0.0325" },
new string[] { "0.0265","0.02605","0.026575","0.0272","0.027875","0.0284","0.029275","0.030425","0.03085","0.03125","0.03245" },
new string[] { "0.0265","0.026075","0.026575","0.027175","0.0278","0.02835","0.0292","0.030325","0.03075","0.031175","0.032375" },
new string[] { "0.0265","0.026","0.0264","0.026915","0.02753","0.028025","0.0289","0.030025","0.030415","0.030828","0.032038" },
new string[] { "0.0265","0.02595","0.0263","0.0268","0.0274","0.02795","0.0288","0.029925","0.03035","0.03075","0.03195" },
new string[] { "0.0265","0.025925","0.026225","0.026725","0.027325","0.0279","0.0288","0.02995","0.030375","0.030775","0.031975" },
new string[] { "0.0265","0.0256","0.025725","0.026175","0.026825","0.027425","0.028325","0.029525","0.02995","0.03035","0.03155" },
new string[] { "0.0265","0.02565","0.0258","0.02625","0.026925","0.02755","0.028475","0.029675","0.030125","0.030525","0.031725" },
new string[] { "0.0265","0.025625","0.025775","0.026275","0.02694","0.027575","0.0285","0.0297","0.030125","0.03055","0.03175" },
new string[] { "0.0265","0.025725","0.025875","0.026325","0.027","0.027625","0.028575","0.0298","0.03025","0.03065","0.03185" },
new string[] { "0.0265","0.0259","0.026125","0.026625","0.027275","0.027875","0.028875","0.030125","0.030575","0.030975","0.032175" },
new string[] { "0.0265","0.025675","0.02585","0.0264","0.027125","0.0278","0.02885","0.0302","0.03065","0.03105","0.03225" },
new string[] { "0.0265","0.02545","0.0255","0.026","0.026675","0.0273","0.028325","0.02965","0.0301","0.0305","0.0317" },
new string[] { "0.0265","0.025325","0.0254","0.02585","0.02645","0.02705","0.0281","0.029425","0.029875","0.030275","0.031475" },
new string[] { "0.0265","0.0253","0.02543","0.0259","0.0265","0.0271","0.02815","0.02948","0.02993","0.03033","0.03153" },
new string[] { "0.0265","0.02525","0.025375","0.0258","0.026375","0.02695","0.027975","0.0293","0.029775","0.0302","0.0314" },
new string[] { "0.0265","0.02525","0.02535","0.025725","0.026275","0.026825","0.02785","0.029175","0.029675","0.0301","0.0313" },
new string[] { "0.0265","0.0249","0.0249","0.025275","0.02575","0.02625","0.0272","0.028475","0.028975","0.0294","0.0306" },
new string[] { "0.0265","0.02495","0.025","0.0254","0.0259","0.026425","0.02735","0.028625","0.029125","0.029588","0.030775" },
new string[] { "0.0265","0.025","0.025075","0.025475","0.025975","0.026525","0.027475","0.028775","0.029275","0.02975","0.03095" },
new string[] { "0.0265","0.024975","0.02505","0.02545","0.025975","0.026525","0.027475","0.0288","0.0293","0.029775","0.030975" },
new string[] { "0.0265","0.02475","0.024675","0.025075","0.0256","0.02615","0.027125","0.028475","0.028975","0.029425","0.030625" },
new string[] { "0.0265","0.0248","0.0248","0.02525","0.025825","0.0264","0.0274","0.02875","0.02925","0.0297","0.0309" },
new string[] { "0.0265","0.024775","0.024775","0.025225","0.0258","0.0264","0.027375","0.028725","0.029225","0.0297","0.0309" },
new string[] { "0.0265","0.02483","0.02483","0.0253","0.02593","0.02658","0.02755","0.0289","0.0294","0.02988","0.03108" },
new string[] { "0.0265","0.024825","0.02485","0.025375","0.026075","0.026725","0.0277","0.02905","0.02955","0.030025","0.031225" },
new string[] { "0.0265","0.024725","0.024775","0.0254","0.026125","0.02675","0.027725","0.029075","0.029575","0.030025","0.031225" },
new string[] { "0.0265","0.024725","0.02485","0.0255","0.02625","0.026875","0.0279","0.029275","0.029775","0.030225","0.031425" },
new string[] { "0.0265","0.024725","0.02492","0.02574","0.0265","0.027175","0.02825","0.02975","0.030288","0.030738","0.031938" },
new string[] { "0.0265","0.024725","0.024925","0.025725","0.026525","0.0272","0.028275","0.0297","0.030225","0.030675","0.031875" },
new string[] { "0.0265","0.02465","0.024875","0.025625","0.026375","0.027","0.02805","0.029475","0.03","0.03045","0.03165" },
new string[] { "0.0265","0.0247","0.024975","0.02575","0.0265","0.027225","0.028275","0.029725","0.030225","0.0307","0.0319" },
new string[] { "0.0265","0.02465","0.024925","0.025675","0.026425","0.027125","0.028175","0.0296","0.030125","0.030575","0.031775" },
new string[] { "0.0265","0.024525","0.02475","0.025375","0.026","0.0265","0.027575","0.029","0.029525","0.029975","0.031175" },
new string[] { "0.0263","0.024575","0.024775","0.02545","0.026025","0.026625","0.027675","0.029075","0.0296","0.030075","0.031275" },
new string[] { "0.0262","0.024625","0.024875","0.025575","0.026175","0.026775","0.027825","0.029225","0.02975","0.030225","0.031425" },
new string[] { "0.0261","0.0246","0.0249","0.0256","0.026225","0.026825","0.027875","0.02925","0.029775","0.03025","0.03145" },
new string[] { "0.0246","0.0243","0.02485","0.0256","0.026275","0.0269","0.02795","0.0293","0.029825","0.030325","0.031525" },
new string[] { "0.0246","0.0243","0.02485","0.0256","0.026275","0.0269","0.02795","0.0293","0.029825","0.030325","0.031525" },
new string[] { "0.0243","0.02425","0.024825","0.025625","0.026325","0.02695","0.027925","0.02925","0.029775","0.030275","0.031475" },
new string[] { "0.0242","0.024025","0.0247","0.0256","0.026425","0.02705","0.02805","0.029325","0.02985","0.03035","0.03155" },
new string[] { "0.0242","0.02405","0.024775","0.0257","0.026525","0.02715","0.028125","0.0294","0.0299","0.0304","0.0316" },
new string[] { "0.0242","0.02405","0.02485","0.0258","0.026625","0.02725","0.0282","0.029475","0.029975","0.030475","0.031675" },
new string[] { "0.0241","0.023975","0.02475","0.02575","0.026575","0.027175","0.0281","0.029375","0.0299","0.0304","0.0316" },
new string[] { "0.0241","0.023925","0.024625","0.0256","0.02635","0.026925","0.02785","0.02915","0.029675","0.030175","0.031375" },
new string[] { "0.024","0.023775","0.02445","0.02535","0.026075","0.026625","0.02755","0.02885","0.029375","0.029875","0.031075" },
new string[] { "0.024","0.023675","0.02435","0.0252","0.0259","0.02645","0.02735","0.028575","0.0291","0.029625","0.030825" },
new string[] { "0.024","0.02365","0.024325","0.0252","0.02595","0.0265","0.0274","0.0286","0.029125","0.02965","0.03085" },
new string[] { "0.024","0.023575","0.02425","0.025125","0.02585","0.026375","0.027325","0.028525","0.02905","0.029575","0.030775" },
new string[] { "0.024","0.0236","0.02425","0.02515","0.02585","0.0264","0.02735","0.028575","0.0291","0.029625","0.030825" },
new string[] { "0.0236","0.02345","0.024075","0.025025","0.025825","0.026425","0.027425","0.0287","0.029225","0.029725","0.030925" },
new string[] { "0.0236","0.023475","0.024175","0.025175","0.02605","0.026675","0.02775","0.029025","0.02955","0.030075","0.031275" },
new string[] { "0.0235","0.023425","0.0242","0.0252","0.026075","0.0267","0.027775","0.02905","0.029575","0.0301","0.0313" },
new string[] { "0.0235","0.023225","0.023925","0.024925","0.0258","0.02645","0.027475","0.028775","0.0293","0.029825","0.031025" },
new string[] { "0.0235","0.023225","0.023925","0.024925","0.0258","0.02645","0.027475","0.028775","0.0293","0.029825","0.031025" },
new string[] { "0.0235","0.023225","0.023925","0.024925","0.0258","0.02645","0.027475","0.028775","0.0293","0.029825","0.031025" },
new string[] { "0.0235","0.023225","0.023925","0.024925","0.0258","0.02645","0.027475","0.028775","0.0293","0.029825","0.031025" },
new string[] { "0.0235","0.0231","0.023825","0.0248","0.025775","0.02645","0.027525","0.02885","0.029375","0.0299","0.0311" },
new string[] { "0.0235","0.022625","0.023275","0.024175","0.0251","0.025825","0.026875","0.0282","0.028725","0.02925","0.03045" },
new string[] { "0.0235","0.022575","0.02325","0.024175","0.02515","0.02595","0.02705","0.02845","0.028975","0.0295","0.0307" },
new string[] { "0.0235","0.022425","0.023125","0.024","0.025025","0.025875","0.027","0.028425","0.02895","0.029475","0.030675" },
new string[] { "0.0235","0.02235","0.023","0.023875","0.024875","0.025725","0.02685","0.02825","0.028775","0.0293","0.0305" },
new string[] { "0.0235","0.022325","0.02295","0.0238","0.024775","0.025575","0.026725","0.02815","0.028725","0.029275","0.0306" },
new string[] { "0.0235","0.02235","0.02295","0.0238","0.024775","0.025575","0.026725","0.02815","0.028725","0.029275","0.0306" },
new string[] { "0.0235","0.022275","0.0228","0.0236","0.024475","0.0252","0.02635","0.027775","0.02835","0.028925","0.03025" },
new string[] { "0.0235","0.022325","0.0228","0.02355","0.0244","0.025125","0.026275","0.0277","0.028325","0.02895","0.030275" },
new string[] { "0.0235","0.02235","0.022775","0.023525","0.024375","0.02505","0.026175","0.0276","0.028225","0.0289","0.030325" },
new string[] { "0.0235","0.022375","0.022775","0.023475","0.02425","0.0249","0.026","0.027375","0.028075","0.02875","0.030175" },
new string[] { "0.0235","0.022375","0.022775","0.023438","0.0242","0.024825","0.025875","0.027225","0.0279","0.028625","0.030075" },
new string[] { "0.0235","0.022425","0.02275","0.0234","0.02415","0.02475","0.025825","0.02715","0.027875","0.028575","0.03" },
new string[] { "0.0235","0.02225","0.022525","0.02315","0.023875","0.024475","0.02555","0.026925","0.02765","0.02835","0.029775" },
new string[] { "0.0235","0.0218","0.022","0.02255","0.023275","0.02385","0.024925","0.026325","0.02705","0.027825","0.02925" },
new string[] { "0.0235","0.02175","0.022","0.02255","0.02335","0.024025","0.02515","0.0266","0.027325","0.0281","0.029525" },
new string[] { "0.0235","0.02175","0.022","0.02255","0.02335","0.024025","0.02515","0.0266","0.027325","0.0281","0.029525" },
new string[] { "0.0235","0.02175","0.022025","0.022575","0.0234","0.024125","0.02525","0.0267","0.027425","0.0282","0.029625" },
new string[] { "0.0231","0.0217","0.0221","0.022725","0.023575","0.02435","0.0255","0.02695","0.027675","0.02845","0.029875" },
new string[] { "0.023","0.02175","0.022175","0.0228","0.0236","0.024375","0.025475","0.026875","0.027625","0.028375","0.029925" },
new string[] { "0.023","0.02175","0.022175","0.0228","0.0236","0.024375","0.025475","0.026875","0.027625","0.028375","0.029925" },
new string[] { "0.0229","0.02165","0.0219","0.022475","0.023275","0.02405","0.025175","0.0266","0.02735","0.0281","0.0297" },
new string[] { "0.0228","0.0217","0.021825","0.0224","0.023175","0.023925","0.02505","0.026475","0.027225","0.027975","0.029575" },
new string[] { "0.0228","0.021825","0.022075","0.02265","0.0234","0.02415","0.025275","0.0267","0.0274","0.0281","0.0297" },
new string[] { "0.0218","0.02155","0.02205","0.022675","0.02345","0.02415","0.0253","0.026725","0.027425","0.028125","0.029725" },
new string[] { "0.0217","0.0212","0.021625","0.02215","0.0228","0.0234","0.024575","0.026","0.0267","0.0274","0.029" },
new string[] { "0.0217","0.0211","0.021425","0.02195","0.02255","0.02315","0.024325","0.02575","0.02645","0.02715","0.02875" },
new string[] { "0.0216","0.021175","0.021575","0.022125","0.022775","0.0234","0.024575","0.026","0.0267","0.0274","0.02895" },
new string[] { "0.0215","0.0211","0.02145","0.022","0.0226","0.0232","0.024375","0.0258","0.0265","0.0272","0.02875" },
new string[] { "0.0215","0.02105","0.02145","0.022","0.022625","0.0232","0.024375","0.0258","0.0265","0.0272","0.02875" },
new string[] { "0.0214","0.021","0.021325","0.02185","0.02245","0.023","0.02415","0.025575","0.02625","0.02695","0.0285" },
new string[] { "0.0214","0.021","0.02125","0.021725","0.0223","0.02285","0.024","0.0255","0.0261","0.02675","0.028325" },
new string[] { "0.0214","0.02105","0.02135","0.021875","0.022475","0.02305","0.0242","0.02565","0.026275","0.02695","0.028475" },
new string[] { "0.0214","0.021025","0.0213","0.021775","0.022425","0.022975","0.0241","0.025525","0.026075","0.026675","0.0282" },
new string[] { "0.0214","0.021","0.0212","0.021675","0.0223","0.02285","0.0239","0.0253","0.02585","0.02645","0.027975" },
new string[] { "0.0214","0.020775","0.021025","0.021475","0.02205","0.022575","0.023625","0.025","0.02555","0.0261","0.027625" },
new string[] { "0.0214","0.020425","0.020575","0.021025","0.0216","0.022125","0.023175","0.02455","0.0251","0.02565","0.027175" },
new string[] { "0.0214","0.020275","0.0203","0.0207","0.02135","0.02195","0.023075","0.024525","0.025075","0.025625","0.02715" },
new string[] { "0.0214","0.02015","0.020125","0.0205","0.021125","0.0217","0.022825","0.02425","0.0248","0.02535","0.026875" },
new string[] { "0.0214","0.020125","0.0201","0.0205","0.021175","0.021775","0.022925","0.02435","0.0249","0.02545","0.026975" },
new string[] { "0.0214","0.020025","0.019975","0.0204","0.0211","0.02175","0.0229","0.0244","0.02495","0.0255","0.027025" },
new string[] { "0.0214","0.02005","0.020075","0.020575","0.021325","0.022025","0.023275","0.024825","0.025375","0.025925","0.02745" },
new string[] { "0.0214","0.02015","0.02025","0.02075","0.0215","0.02215","0.023375","0.024925","0.025425","0.02595","0.027475" },
new string[] { "0.0214","0.020625","0.02085","0.021375","0.02205","0.022675","0.0238","0.025275","0.025775","0.026325","0.02785" },
new string[] { "0.0214","0.020725","0.021088","0.021638","0.022325","0.022938","0.024075","0.025575","0.026025","0.026575","0.028125" },
new string[] { "0.0214","0.0208","0.0212","0.0218","0.0225","0.023125","0.02425","0.02575","0.02625","0.02685","0.028375" },
new string[] { "0.0214","0.0208","0.021175","0.021775","0.022475","0.023125","0.024275","0.025775","0.026275","0.0269","0.028425" },
new string[] { "0.0214","0.020725","0.021025","0.02165","0.02235","0.023025","0.024175","0.0257","0.0262","0.026825","0.02835" },
new string[] { "0.0214","0.02065","0.020875","0.021475","0.022175","0.022825","0.023975","0.0255","0.026","0.026625","0.02815" },
new string[] { "0.0214","0.0205","0.020725","0.02135","0.02205","0.022725","0.023875","0.0254","0.0259","0.026525","0.02805" },
new string[] { "0.0214","0.020225","0.020375","0.021","0.0217","0.022375","0.023525","0.02505","0.02555","0.0262","0.027725" },
new string[] { "0.0214","0.0202","0.02035","0.020925","0.02165","0.022325","0.023475","0.025","0.0255","0.026125","0.02765" },
new string[] { "0.0214","0.02005","0.02005","0.020575","0.021275","0.0219","0.02305","0.024575","0.025075","0.0257","0.027225" },
new string[] { "0.0213","0.020025","0.020025","0.02045","0.021075","0.021675","0.022825","0.02435","0.02485","0.025475","0.027" },
new string[] { "0.0213","0.020075","0.02","0.020375","0.020925","0.021475","0.0226","0.02415","0.02465","0.025275","0.0268" },
new string[] { "0.0213","0.0202","0.0202","0.020575","0.021125","0.02165","0.022775","0.02435","0.02485","0.025475","0.027" },
new string[] { "0.0213","0.02005","0.019975","0.0203","0.02075","0.02125","0.02235","0.02385","0.02435","0.024975","0.0266" },
new string[] { "0.0213","0.0201","0.02","0.0203","0.020725","0.0212","0.022275","0.0237","0.0242","0.024825","0.02645" },
new string[] { "0.0213","0.020175","0.02015","0.0205","0.02095","0.02145","0.022525","0.023975","0.0245","0.025125","0.0268" },
new string[] { "0.0213","0.0204","0.02065","0.021075","0.02165","0.022225","0.023325","0.0248","0.025325","0.02595","0.027625" },
new string[] { "0.0213","0.02055","0.0209","0.02135","0.021925","0.0225","0.0236","0.025075","0.02555","0.02615","0.027825" },
new string[] { "0.0213","0.02055","0.0209","0.021375","0.021975","0.0226","0.023675","0.025125","0.0256","0.0262","0.027875" },
new string[] { "0.0213","0.020925","0.02135","0.022025","0.022725","0.02345","0.024525","0.02595","0.02645","0.02705","0.028725" },
new string[] { "0.0213","0.0204","0.020725","0.021375","0.02205","0.02275","0.023825","0.025225","0.025725","0.026325","0.028" },
new string[] { "0.0213","0.020475","0.02085","0.0215","0.022225","0.022925","0.023975","0.025375","0.025875","0.026475","0.02815" },
new string[] { "0.0213","0.0203","0.0205","0.021025","0.02175","0.02245","0.0235","0.024875","0.025375","0.026","0.027675" },
new string[] { "0.0213","0.0203","0.02045","0.020975","0.0217","0.0224","0.02345","0.024825","0.025325","0.02595","0.027625" },
new string[] { "0.0213","0.020325","0.02055","0.02105","0.02175","0.022425","0.023475","0.02485","0.02535","0.02595","0.0276" },
new string[] { "0.0213","0.02035","0.0205","0.021","0.021675","0.022325","0.023375","0.024725","0.025225","0.02585","0.027475" },
new string[] { "0.0213","0.02055","0.020825","0.0213","0.02195","0.0226","0.023625","0.0249","0.025375","0.02595","0.027575" },
new string[] { "0.0213","0.02065","0.020975","0.021525","0.0222","0.022875","0.024","0.025275","0.025775","0.026325","0.0279" },
new string[] { "0.0213","0.020625","0.020975","0.0215","0.022175","0.022875","0.023975","0.025275","0.025775","0.026275","0.02785" },
new string[] { "0.0213","0.0206","0.020875","0.02135","0.02195","0.022575","0.0236","0.0249","0.0254","0.025925","0.02745" },
new string[] { "0.0213","0.020575","0.02085","0.021325","0.021875","0.022475","0.023525","0.02495","0.02545","0.025975","0.0275" },
new string[] { "0.0213","0.0206","0.0208","0.021275","0.021825","0.022425","0.023475","0.024875","0.025375","0.0259","0.027425" },
new string[] { "0.0213","0.0206","0.0208","0.021275","0.021825","0.022425","0.023475","0.024875","0.025375","0.0259","0.027425" },
new string[] { "0.0213","0.020575","0.02085","0.021325","0.021875","0.022475","0.023525","0.024925","0.025425","0.02595","0.027475" },
new string[] { "0.0213","0.02055","0.020775","0.0212","0.0217","0.02225","0.02325","0.024575","0.02515","0.025675","0.0272" },
new string[] { "0.0213","0.0204","0.020525","0.021","0.021525","0.022075","0.023075","0.0244","0.024975","0.0255","0.027025" },
new string[] { "0.0213","0.0204","0.020525","0.021","0.021525","0.022075","0.023075","0.0244","0.024975","0.0255","0.027025" },
new string[] { "0.0213","0.0204","0.020525","0.021","0.021525","0.022075","0.023075","0.0244","0.024975","0.0255","0.027025" },
new string[] { "0.0213","0.02055","0.020775","0.02125","0.0218","0.022375","0.0234","0.02475","0.025325","0.025825","0.02735" },
new string[] { "0.0213","0.020325","0.020475","0.02095","0.021475","0.022025","0.02305","0.0244","0.024975","0.025475","0.027" },
new string[] { "0.0213","0.020075","0.0201","0.020475","0.02095","0.02145","0.02245","0.023825","0.024425","0.024925","0.02645" },
new string[] { "0.0213","0.01995","0.019975","0.020375","0.02085","0.021375","0.022375","0.023725","0.024325","0.0248","0.0263" },
new string[] { "0.0213","0.02","0.019975","0.02035","0.02085","0.02135","0.022325","0.023675","0.024275","0.02475","0.02625" },
new string[] { "0.0213","0.02","0.019925","0.02025","0.020725","0.0212","0.022125","0.023425","0.02405","0.024525","0.026025" },
new string[] { "0.0213","0.019625","0.019475","0.01965","0.02005","0.02045","0.02135","0.0226","0.023225","0.0237","0.0252" },
new string[] { "0.0213","0.019675","0.0196","0.01975","0.0201","0.02045","0.021325","0.022525","0.02315","0.023575","0.025075" },
new string[] { "0.0213","0.01935","0.019175","0.0193","0.0196","0.019925","0.020725","0.021875","0.02255","0.022975","0.024475" },
new string[] { "0.0213","0.019875","0.019825","0.020025","0.02035","0.02065","0.0214","0.02255","0.023225","0.023625","0.025125" },
new string[] { "0.0213","0.019775","0.019675","0.019775","0.01995","0.0202","0.02075","0.02165","0.022325","0.022725","0.02425" },
new string[] { "0.0213","0.0199","0.01985","0.019975","0.020175","0.02045","0.02105","0.021975","0.02265","0.023025","0.02455" },
new string[] { "0.0213","0.0199","0.0198","0.01995","0.020075","0.02035","0.02095","0.02185","0.022525","0.0229","0.024425" },
new string[] { "0.0213","0.02","0.01995","0.020125","0.0203","0.0206","0.0212","0.02215","0.022825","0.0232","0.024725" },
new string[] { "0.0213","0.020125","0.020075","0.020275","0.0205","0.0208","0.0214","0.0224","0.023075","0.02345","0.024975" },
new string[] { "0.0213","0.019925","0.0197","0.019775","0.019925","0.02015","0.020725","0.02175","0.0224","0.022775","0.0243" },
new string[] { "0.0213","0.0199","0.01965","0.019725","0.0198","0.02","0.02055","0.021575","0.022225","0.0226","0.024125" },
new string[] { "0.0213","0.019925","0.019675","0.0197","0.0198","0.02","0.02055","0.021575","0.022175","0.02255","0.024075" },
new string[] { "0.0212","0.01975","0.019425","0.01945","0.019575","0.01975","0.0203","0.0212","0.021825","0.0222","0.023725" },
new string[] { "0.0212","0.019725","0.0194","0.019425","0.019475","0.01965","0.0201","0.020975","0.0216","0.021975","0.023475" },
new string[] { "0.0212","0.0196","0.019275","0.0193","0.01945","0.01965","0.02015","0.021025","0.02165","0.021975","0.023425" },
new string[] { "0.0212","0.019625","0.01925","0.019325","0.01945","0.019625","0.020125","0.021025","0.02165","0.021975","0.023425" },
new string[] { "0.0212","0.01935","0.018875","0.018925","0.019075","0.01925","0.01975","0.02065","0.021275","0.0216","0.02305" },
new string[] { "0.0212","0.0195","0.019125","0.0192","0.019375","0.019575","0.02015","0.0211","0.021725","0.02205","0.0235" },
new string[] { "0.0212","0.019575","0.01925","0.01935","0.019525","0.01975","0.02035","0.02135","0.021975","0.0223","0.02375" },
new string[] { "0.0212","0.01955","0.01915","0.01925","0.019425","0.01965","0.020225","0.0212","0.021825","0.02215","0.0236" },
new string[] { "0.0212","0.0196","0.019225","0.019375","0.019625","0.019888","0.020438","0.0214","0.022025","0.02235","0.0238" },
new string[] { "0.0212","0.020175","0.01995","0.02015","0.0203","0.020575","0.021125","0.02215","0.022725","0.02311","0.02455" },
new string[] { "0.0212","0.020185","0.019985","0.020163","0.020378","0.02065","0.0212","0.022178","0.0228","0.023138","0.024573" },
new string[] { "0.0212","0.020325","0.020175","0.020375","0.020595","0.02085","0.02145","0.022425","0.02305","0.023405","0.0248" },
new string[] { "0.0212","0.020175","0.02","0.0202","0.020425","0.02075","0.021275","0.02225","0.022875","0.0232","0.024625" },
new string[] { "0.0212","0.020325","0.020325","0.020625","0.020925","0.021275","0.02185","0.022875","0.02355","0.023825","0.025313" },
new string[] { "0.0212","0.02015","0.02004","0.02025","0.0205","0.020763","0.021223","0.02219","0.022813","0.02315","0.024525" },
new string[] { "0.0212","0.0201","0.019975","0.0202","0.02045","0.0207","0.021175","0.022125","0.02275","0.023075","0.0245" },
new string[] { "0.0212","0.0201","0.019975","0.0202","0.02045","0.0207","0.021175","0.022125","0.02275","0.023075","0.0245" },
new string[] { "0.0212","0.0201","0.019975","0.0202","0.02045","0.0207","0.021175","0.022125","0.02275","0.023075","0.0245" },
new string[] { "0.0212","0.020223","0.020173","0.02045","0.02075","0.02105","0.021588","0.02255","0.023178","0.0235","0.02495" },
new string[] { "0.021","0.02005","0.020025","0.0204","0.020775","0.021075","0.021625","0.022625","0.02325","0.023575","0.025025" },
new string[] { "0.021","0.019925","0.019838","0.020025","0.0204","0.020675","0.0212","0.022175","0.02285","0.023125","0.024625" },
new string[] { "0.021","0.0199","0.0198","0.0201","0.02043","0.02068","0.02122","0.02225","0.02287","0.0232","0.02463" },
new string[] { "0.021","0.019825","0.019725","0.02","0.0203","0.02055","0.0211","0.022125","0.022725","0.023075","0.024525" },
new string[] { "0.021","0.0197","0.01945","0.019775","0.0201","0.02035","0.02095","0.022","0.022625","0.02295","0.0244" },
new string[] { "0.021","0.01955","0.019378","0.0197","0.020078","0.02043","0.02108","0.0222","0.02283","0.02315","0.02457" },
new string[] { "0.021","0.019465","0.01925","0.01952","0.02","0.020373","0.02114","0.0223","0.022938","0.023263","0.024703" },
new string[] { "0.021","0.0194","0.019115","0.019425","0.0199","0.020288","0.021038","0.022188","0.022775","0.023125","0.024575" },
new string[] { "0.021","0.01915","0.01885","0.01915","0.0196","0.02","0.02075","0.021925","0.022513","0.022888","0.024338" },
new string[] { "0.021","0.019063","0.018778","0.019088","0.019778","0.02028","0.02105","0.022285","0.0229","0.02325","0.02469" },
new string[] { "0.021","0.01915","0.018938","0.01923","0.019888","0.0204","0.0212","0.022463","0.02305","0.0234","0.02485" },
new string[] { "0.021","0.019","0.01863","0.018875","0.019385","0.01984","0.02065","0.021875","0.022475","0.022825","0.02428" },
new string[] { "0.0191","0.018225","0.018225","0.0187","0.019325","0.019875","0.02075","0.02205","0.022675","0.023025","0.024475" },
new string[] { "0.019","0.01805","0.01805","0.0185","0.01915","0.0197","0.0206","0.022","0.02265","0.023","0.02445" },
new string[] { "0.0189","0.018","0.01795","0.01835","0.01895","0.019438","0.020275","0.021525","0.022175","0.022525","0.023975" },
new string[] { "0.0188","0.018025","0.018","0.0184","0.01895","0.01945","0.020275","0.02155","0.02225","0.0226","0.02405" },
new string[] { "0.0187","0.017875","0.01785","0.01825","0.018775","0.019225","0.019975","0.02115","0.021875","0.022275","0.023725" },
new string[] { "0.0187","0.0176","0.017525","0.017875","0.01835","0.018775","0.0195","0.020625","0.02135","0.021775","0.023225" },
new string[] { "0.0186","0.01731","0.017188","0.017578","0.018075","0.018575","0.01945","0.02068","0.0214","0.021823","0.023273" },
new string[] { "0.0186","0.017275","0.017175","0.01755","0.01805","0.01855","0.0194","0.02065","0.021375","0.021825","0.023275" },
new string[] { "0.0186","0.0173","0.01715","0.01755","0.01805","0.018525","0.01938","0.0206","0.021315","0.0218","0.023225" },
new string[] { "0.0186","0.0172","0.017025","0.0174","0.0179","0.0184","0.019175","0.0204","0.021125","0.021625","0.023075" },
new string[] { "0.0186","0.017225","0.017025","0.017425","0.01795","0.018425","0.01925","0.0205","0.02125","0.02175","0.0232" },
new string[] { "0.0186","0.0172","0.01695","0.01735","0.017913","0.0184","0.0192","0.020475","0.0212","0.0217","0.02315" },
new string[] { "0.0185","0.0169","0.01665","0.017125","0.0177","0.01825","0.019075","0.02035","0.0211","0.0216","0.02305" },
#endregion
new string[] { "0.0185","0.016825","0.016575","0.017025","0.017625","0.018225","0.019075","0.0204","0.021175","0.0217","0.02315" }
};
string[] dateString = { "20130701","20130702","20130703","20130704","20130705","20130708","20130709","20130710","20130711","20130712","20130715","20130716",
#region data
"20130717","20130718","20130719","20130722","20130723","20130724","20130725","20130726","20130729","20130730","20130731","20130801",
"20130802","20130805","20130806","20130807","20130808","20130809","20130812","20130813","20130814","20130815","20130816","20130819",
"20130820","20130821","20130822","20130823","20130826","20130827","20130828","20130829","20130830","20130902","20130903","20130904",
"20130905","20130906","20130909","20130910","20130911","20130912","20130913","20130916","20130917","20130918","20130919","20130920",
"20130923","20130924","20130925","20130926","20130927","20130930","20131001","20131002","20131003","20131004","20131007","20131008",
"20131009","20131010","20131011","20131014","20131015","20131016","20131017","20131018","20131021","20131022","20131023","20131024",
"20131025","20131028","20131029","20131030","20131031","20131101","20131104","20131105","20131106","20131107","20131108","20131111",
"20131112","20131113","20131114","20131115","20131118","20131119","20131120","20131121","20131122","20131125","20131126","20131127",
"20131128","20131129","20131202","20131203","20131204","20131205","20131206","20131209","20131210","20131211","20131212","20131213",
"20131216","20131217","20131218","20131219","20131220","20131223","20131224","20131225","20131226","20131227","20131230","20131231",
"20140101","20140102","20140103","20140106","20140107","20140108","20140109","20140110","20140113","20140114","20140115","20140116",
"20140117","20140120","20140121","20140122","20140123","20140124","20140127","20140128","20140129","20140130","20140131","20140203",
"20140204","20140205","20140206","20140207","20140210","20140211","20140212","20140213","20140214","20140217","20140218","20140219",
"20140220","20140221","20140224","20140225","20140226","20140227","20140228","20140303","20140304","20140305","20140306","20140307",
"20140310","20140311","20140312","20140313","20140314","20140317","20140318","20140319","20140320","20140321","20140324","20140325",
"20140326","20140327","20140328","20140331","20140404","20140407","20140408","20140409","20140410","20140411","20140414","20140415",
"20140416","20140417","20140418","20140421","20140422","20140423","20140424","20140425","20140428","20140429","20140430","20140501",
"20140502","20140505","20140506","20140507","20140508","20140509","20140512","20140513","20140514","20140515","20140516","20140519",
"20140520","20140521","20140522","20140523","20140526","20140527","20140528","20140529","20140530","20140602","20140603","20140604",
"20140605","20140609","20140610","20140611","20140612","20140613","20140616","20140617","20140618","20140619","20140620","20140623",
"20140624","20140625","20140626","20140627","20140630","20140701","20140702","20140703","20140704","20140707","20140708","20140709",
"20140710","20140711","20140714","20140715","20140716","20140717","20140718","20140721","20140722","20140723","20140724","20140725",
"20140728","20140729","20140730","20140731","20140801","20140804","20140805","20140806","20140807","20140808","20140811","20140812",
"20140813","20140814","20140815","20140818","20140819","20140820","20140821","20140822","20140825","20140826","20140827","20140828",
"20140829","20140901","20140902","20140903","20140904","20140905","20140908","20140909","20140910","20140911","20140912","20140915",
"20140916","20140917","20140918","20140919","20140922","20140923","20140924","20140925","20140926","20140929","20140930","20141001",
"20141002","20141003","20141006","20141007","20141008","20141009","20141010","20141013","20141014","20141015","20141016","20141017",
"20141020","20141021","20141022","20141023","20141024","20141027","20141028","20141029","20141030","20141031","20141103","20141104",
"20141105","20141106","20141107","20141110","20141111","20141112","20141113","20141114","20141117","20141118","20141119","20141120",
"20141121","20141124","20141125","20141126","20141127","20141128","20141201","20141202","20141203","20141204","20141205","20141208",
"20141209","20141210","20141211","20141212","20141215","20141216","20141217","20141218","20141219","20141222","20141223","20141224",
"20141225","20141226","20141229","20141230","20141231","20150101","20150102","20150105","20150106","20150107","20150108","20150109",
"20150112","20150113","20150114","20150115","20150116","20150119","20150120","20150121","20150122","20150123","20150126","20150127",
"20150128","20150129","20150130","20150202","20150203","20150204","20150205","20150206","20150209","20150210","20150211","20150212",
"20150213","20150216","20150217","20150218","20150219","20150220","20150223","20150224","20150225","20150226","20150227","20150302",
"20150303","20150304","20150305","20150306","20150309","20150310","20150311","20150312","20150313","20150316","20150317","20150318",
#endregion
"20150319","20150320","20150323","20150324","20150325","20150326","20150327","20150330","20150604"
};
int rateListLength = rateList.Length;
int dateLength = dateString.Length;
clsTB.CURVE_CD = "IRSKRW";
for (int i = 0; i < dateLength; i++)
{
clsTB.REF_DT = dateString[i];
for (int depo = 0; depo < depositeTenor.Length; depo++)
{
clsTB.TENOR = depositeTenor[depo];
clsTB.TENOR_SEQ = depo + 1;
clsTB.RATE = Convert.ToDouble(rateList[i][depo]);
clsTB.RATE_TYP = 1;
clsTB.Insert();
}
for (int swap = 0; swap < swapTenor.Length; swap++)
{
clsTB.TENOR = swapTenor[swap];
clsTB.TENOR_SEQ = swap + depositeTenor.Length + 1;
clsTB.RATE = Convert.ToDouble(rateList[i][swap+1]);
clsTB.RATE_TYP = 2;
clsTB.Insert();
}
}
}
// static
public static YieldCurve GetYieldCurve_DB(DateTime refereceDate, string curveID, clsHDAT_CURVEDATA_TB.RATE_TYP_Type type)
{
YieldCurve yc = new YieldCurve();
yc.loadCurveData(refereceDate,curveID,type);
return yc;
}
public void CurveData(DateTime refDate)
{
string refDateStr = refDate.ToString("yyyyMMdd");
//string fileName = @"D:\data_etl\IRCURVE_" + refDateStr + ".TXT";
string fileName = @"C:\batch\IRCURVE_" + refDateStr + ".TXT";
/* Download a File */
this.FtpConnector_.download("/marketdata/curve/IRCURVE_" + refDateStr + ".TXT" , fileName);
List<string> tenorList = new List<string>()
{
"1D", "3M", "6M","9M", "12M", "18M" , "24M", "30M" , "36M", "48M",
"60M", "84M", "120M", "180M", "240M"
};
DataSet ds = TextToDataSet.Convert(fileName, "testTB", "|");
// db 에 올림.
clsHDAT_CURVEDATA_TB clstb = new clsHDAT_CURVEDATA_TB();
clstb.REF_DT = refDateStr;
clstb.DeleteDate();
foreach (DataRow dr in ds.Tables[0].Select())
{
if (dr[0].ToString() != "")
{
clstb.CURVE_CD = dr[2].ToString();
if (dr[1].ToString() == "Y") { clstb.RATE_TYP = (int)clsHDAT_CURVEDATA_TB.RATE_TYP_Type.YTM; }
else if (dr[1].ToString() == "S") { clstb.RATE_TYP = (int)clsHDAT_CURVEDATA_TB.RATE_TYP_Type.SPOT; }
else { clstb.RATE_TYP = (int)clsHDAT_CURVEDATA_TB.RATE_TYP_Type.YTM; }
for (int i = 0; i < tenorList.Count; i++)
{
clstb.TENOR = tenorList[i];
clstb.TENOR_SEQ = i+1;
clstb.RATE = Math.Round(Convert.ToDouble(dr[i+3].ToString()) / 100, 5);
clstb.Insert();
}
}
}
}
public clsHDAT_CURVEDATA_TB Clone()
{
try
{
clsHDAT_CURVEDATA_TB cloneTB = new clsHDAT_CURVEDATA_TB();
cloneTB._REF_DT = this._REF_DT;
cloneTB._CURVE_CD = this._CURVE_CD;
cloneTB._TENOR = this._TENOR;
cloneTB._TENOR_SEQ = this._TENOR_SEQ;
cloneTB._RATE_TYP = this._RATE_TYP;
cloneTB._RATE = this._RATE;
return cloneTB;
}
catch(Exception ex)
{
throw new Exception(ex.Message);
}
}
public static clsHDAT_CURVEDATA_TB Create(DataRow dr)
{
try
{
clsHDAT_CURVEDATA_TB tb = new clsHDAT_CURVEDATA_TB();
tb._REF_DT = Convert.ToString(dr[0]);
tb._CURVE_CD = Convert.ToString(dr[1]);
tb._TENOR = Convert.ToString(dr[2]);
tb._TENOR_SEQ = Convert.ToInt32(dr[3]);
tb._RATE_TYP = Convert.ToInt32(dr[4]);
tb._RATE = Convert.ToDouble(dr[5]);
return tb;
}
catch(Exception ex)
{
throw new Exception(ex.Message);
}
}
public void curveData(CurveDefInfo curveDefInfo,
CurveShift curveShift,
DateTime preDate,
DateTime nextDate)
{
clsHDAT_CURVEDATA_TB clstb = new clsHDAT_CURVEDATA_TB();
//clstb.CURVE_CD = curveDefInfo.Name_;
//DataTable tb = clstb.Select();
int seq = 1;
clstb.REF_DT = nextDate.ToString("yyyyMMdd");
clstb.CURVE_CD = curveDefInfo.Name_;
for (int i = 0; i < curveDefInfo.Tenor_.Count; i++)
{
clstb.TENOR = curveDefInfo.Tenor_[i];
clstb.TENOR_SEQ = seq;
clstb.RATE = curveDefInfo.InitialCurve_[i];
clstb.RATE_TYP = (int)clsHDAT_CURVEDATA_TB.RATE_TYP_Type.SWAP;
seq += 1;
clstb.Insert();
}
}
public void build_curveHistoryData(DateTime startDate, DateTime endDate,bool withClear)
{
CalendarManager cm = new CalendarManager(DateTime.Now, CalendarManager.CountryType.SOUTH_KOREA);
clsHDAT_CURVEDATA_TB clstb = new clsHDAT_CURVEDATA_TB();
CurveShift curveShift = new CurveShift();
foreach (CurveDefInfo cdi in this.sampleCurve_)
{
clstb.CURVE_CD = cdi.Name_;
if (withClear)
{
clstb.DeleteIndex();
clstb.REF_DT = startDate.ToString("yyyyMMdd");
for (int i = 0; i < cdi.Tenor_.Count; i++)
{
clstb.TENOR = cdi.Tenor_[i];
clstb.TENOR_SEQ = i+1;
clstb.RATE_TYP = (int)clsHDAT_CURVEDATA_TB.RATE_TYP_Type.SWAP;
clstb.RATE = cdi.InitialCurve_[i];
}
}
clstb.Insert();
DateTime roopDate = startDate;
DateTime nextDate = cm.adjust(roopDate, "1D");
while (nextDate < endDate)
{
clstb.REF_DT = roopDate.ToString("yyyyMMdd");
nextDate = cm.adjust(roopDate, "1D");
this.curveData(cdi, curveShift, roopDate, nextDate);
roopDate = nextDate;
}
}
}