//method to hide buttons, graphs etc. private void hide() { Mdgv.Hide(); ForecastMlbl.Hide(); numericUpDown1.Hide(); numericUpDown2.Hide(); ForecastRun.Hide(); ForecastP1.Hide(); label1.Hide(); label2.Hide(); ForecastP2.Hide(); ForecastP3.Hide(); }
//populates the Fitted ARIMA/ARCH/GARCH datagridview private void populatedatagridview() { bs1.DataSource = Modellist; Mdgv.Show(); ForecastMlbl.Show(); Mdgv.DataSource = bs1; Mdgv.AllowUserToAddRows = false; Mdgv.AutoGenerateColumns = false; DataGridViewColumn col1 = new DataGridViewTextBoxColumn(); col1.DataPropertyName = "Type"; col1.HeaderText = "Alg"; col1.Name = "Blah"; col1.Width = 50; Mdgv.Columns.Add(col1); DataGridViewColumn col2 = new DataGridViewTextBoxColumn(); col2.DataPropertyName = "P"; col2.HeaderText = "AR"; col2.Name = "AR Params"; col2.Width = 50; Mdgv.Columns.Add(col2); DataGridViewColumn col3 = new DataGridViewTextBoxColumn(); col3.DataPropertyName = "Q"; col3.HeaderText = "MA"; col3.Name = "MA Params"; col3.Width = 50; Mdgv.Columns.Add(col3); DataGridViewColumn col4 = new DataGridViewTextBoxColumn(); col4.DataPropertyName = "D"; col4.HeaderText = "Diff"; col4.Name = "Diff"; col4.Width = 50; Mdgv.Columns.Add(col4); DataGridViewColumn col5 = new DataGridViewTextBoxColumn(); col5.DataPropertyName = "Variance"; col5.HeaderText = "Var"; col5.Name = "Var"; col5.Width = 50; Mdgv.Columns.Add(col5); col5.DefaultCellStyle.Format = "n4"; DataGridViewColumn col6 = new DataGridViewTextBoxColumn(); col6.DataPropertyName = "Sumsquaredresiduals"; col6.HeaderText = "SS resid"; col6.Name = "SS resid"; col6.Width = 60; Mdgv.Columns.Add(col6); col6.DefaultCellStyle.Format = "n2"; DataGridViewColumn col7 = new DataGridViewTextBoxColumn(); col7.DataPropertyName = "Transformtype"; col7.HeaderText = "Transform"; col7.Name = "Transform"; col7.Width = 60; Mdgv.Columns.Add(col7); DataGridViewColumn col8 = new DataGridViewTextBoxColumn(); col8.DataPropertyName = "Transformshape"; col8.HeaderText = "Shape"; col8.Name = "Shape"; col8.Width = 60; col8.DefaultCellStyle.Format = "n2"; Mdgv.Columns.Add(col8); DataGridViewColumn col9 = new DataGridViewTextBoxColumn(); col9.DataPropertyName = "Transformscale"; col9.HeaderText = "Scale"; col9.Name = "Scale"; col9.Width = 60; DataGridViewColumn col10 = new DataGridViewTextBoxColumn(); col10.DataPropertyName = "archP"; col10.HeaderText = "Garch(p)"; col10.Name = "Garch(p)"; col10.Width = 60; //col9.DefaultCellStyle.Format = "n2"; Mdgv.Columns.Add(col10); DataGridViewColumn col11 = new DataGridViewTextBoxColumn(); col11.DataPropertyName = "archQ"; col11.HeaderText = "Garch(Q)"; col11.Name = "Garch(Q)"; col11.Width = 60; //col9.DefaultCellStyle.Format = "n2"; Mdgv.Columns.Add(col11); Mdgv.Columns["P"].Visible = false; Mdgv.Columns["Q"].Visible = false; Mdgv.Columns["Aic"].Visible = false; Mdgv.Columns["Bic"].Visible = false; Mdgv.Columns["Type"].Visible = false; Mdgv.Columns["Variance"].Visible = false; Mdgv.Columns["D"].Visible = false; Mdgv.Columns["Sumsquaredresiduals"].Visible = false; Mdgv.Columns["Transformtype"].Visible = false; Mdgv.Columns["Transformshape"].Visible = false; Mdgv.Columns["Transformscale"].Visible = false; Mdgv.Columns["archP"].Visible = false; Mdgv.Columns["archQ"].Visible = false; Mdgv.Columns["archAic"].Visible = false; Mdgv.Columns["Subtractmean"].Visible = false; //now we will determine which of the models has the lowest residual sum of squares int msize = modellist.Count(); int[] position = new int[msize]; double[] residss = new double[msize]; int minposition = 0; double minresidss = 100000000; for (int i = 0; i < msize; i++) { position[i] = i; residss[i] = modellist[i].Sumsquaredresiduals; if (residss[i] < minresidss) { minresidss = residss[i]; minposition = i; } } Mdgv.Rows[minposition].DefaultCellStyle.BackColor = Color.LightBlue; Mdgv.FirstDisplayedScrollingRowIndex = minposition; Mdgv.Rows[minposition].Cells[1].Selected = true; }