public List <double> volatilityList(DateTime startDate, DateTime endDate, Underlying under, string type) { HistoryVolCalculator histVolCal = new HistoryVolCalculator(); OracleDataBaseConnect connect = new OracleDataBaseConnect(); connect.DBSetting_ = DBSettingInfoManger.dbSetting("MRO"); string queryName = "Underlying"; connect.addQuery(queryName, ""); connect.excute(); List <double> resultVol = new List <double>(); foreach (DataRow item in connect.ResultDataSet_.Tables[queryName].Rows) { double vol = Convert.ToDouble(item["Value"].ToString()); resultVol.Add(vol); } histVolCal.ValueList_ = resultVol; histVolCal.historyCalVol(); return(histVolCal.ValueList_); }
public static DataBaseConnect CreateDBConnet(string p) { DataBaseConnect conn = new OracleDataBaseConnect(); conn.DBSetting_ = DBSettingInfoManger.dbSetting(p); return conn; }
public List<double> volatilityList(DateTime startDate,DateTime endDate, Underlying under, string type) { HistoryVolCalculator histVolCal = new HistoryVolCalculator(); OracleDataBaseConnect connect = new OracleDataBaseConnect(); connect.DBSetting_ = DBSettingInfoManger.dbSetting("MRO"); string queryName = "Underlying"; connect.addQuery(queryName,""); connect.excute(); List<double> resultVol = new List<double>(); foreach (DataRow item in connect.ResultDataSet_.Tables[queryName].Rows) { double vol = Convert.ToDouble(item["Value"].ToString()); resultVol.Add(vol); } histVolCal.ValueList_ = resultVol; histVolCal.historyCalVol(); return histVolCal.ValueList_; }
public static OracleDataBaseConnect CreateOracleDBConnet(string p) { OracleDataBaseConnect conn = new OracleDataBaseConnect(); conn.DBSetting_ = DBSettingInfoManger.dbSetting(p); return(conn); }
private DataSet connectDB() { DataSet dataSet = new DataSet(); string query = ""; OracleDataBaseConnect dbConnect = new OracleDataBaseConnect(); dbConnect.DBSetting_ = DBSettingInfoManger.dbSetting("MRO"); dbConnect.addQuery("OptionPositionHist", query); dbConnect.excute(); return dbConnect.ResultDataSet_; }
private DataSet connectDB() { DataSet dataSet = new DataSet(); string query = ""; OracleDataBaseConnect dbConnect = new OracleDataBaseConnect(); dbConnect.DBSetting_ = DBSettingInfoManger.dbSetting("MRO"); dbConnect.addQuery("OptionPositionHist", query); dbConnect.excute(); return(dbConnect.ResultDataSet_); }
public List <double> loadHistory(string itemCode, DateTime startDate, DateTime endDate) { OracleDataBaseConnect conn = OracleDataBaseConnect.CreateOracleDBConnet("Local"); QueryStr query = new QueryStr(fileInfo1_); query.VariableMap_.Add("stockID", itemCode); query.VariableMap_.Add("startDate", startDate.ToString("yyyyMMdd")); query.VariableMap_.Add("endDate", endDate.ToString("yyyyMMdd")); conn.addQuery("Test", query.getQuery()); conn.excute(); List <double> valueList = new List <double>(); List <string> datestr = new List <string>(); foreach (DataRow item in conn.ResultDataSet_.Tables["Test"].Rows) { valueList.Add(Convert.ToDouble(item["CURR_PRICE"].ToString())); datestr.Add(item["STD_DATE"].ToString()); } return(Result_); }
//public ObservableCollection<Instrument> getPosition() //{ // loadedPosition_ = new List<string>(); // ObservableCollection<Instrument> position = new ObservableCollection<Instrument>() ; // DataTable table = positionDataSet_.Tables["Position"]; // foreach (DataRow row in table.Rows) // { // Instrument inst = this.buildInstrument(row["KR_CD"].ToString()); // //if (inst.Underlying_ != null) // //{ // // position.Add(inst); // //} // } // return position; //} public void updateDB() { OracleDataBaseConnect conn = new OracleDataBaseConnect(); //conn.addQuery( }