Post
Ask Question
Sing Ku

Sing Ku

  • NA
  • 6
  • 536

How to Create Chart with huge data

Dec 4 2020 9:48 AM

Hello,

I would like to make a multi Series chart in vb.net how many of the series depends on the department and the data gathered from a data table which is collected from a grid view. The sourcecode of generate chart show as follows:

  1. Protected Sub btn_Int_Click(sender As Object, e As EventArgs) Handles btn_Int.Click  
  2. Label001.Visible = False  
  3. Label37.Visible = True  
  4. Label39.Visible = True  
  5. Label48.Visible = True  
  6. Label51.Visible = False  
  7. Label52.Visible = False  
  8. Label37.Text = "The Chart of " & Label38.Text & " by Number of Incidents "  
  9. Label48.Text = "From" & " " & Label42.Text & " " & "to" & " " & Label45.Text  
  10. If DropDownList13.SelectedIndex = -1 Then  
  11. Label39.Text = Label40.Text  
  12. Else  
  13. Label39.Text = Label40.Text & Label41.Text  
  14. End If  
  15. btn_Print.Visible = True  
  16. RateChart.Visible = True  
  17. Dim dtInt As DataTable = New DataTable("dtInts")  
  18. For Each cell As TableCell In gvInt.HeaderRow.Cells  
  19. dtInt.Columns.Add(cell.Text.Trim())  
  20. Next  
  21. For Each row As GridViewRow In gvInt.Rows  
  22. dtInt.Rows.Add()  
  23. For i As Integer = 0 To row.Cells.Count = -1  
  24. Dim j As Integer = i  
  25. dtInt.Rows(row.RowIndex)(j) = row.Cells(j).Text.Trim()  
  26. Next  
  27. Next  
  28. Dim departments As List(Of String) = New List(Of String)()  
  29. departments = (From p In dtInt.AsEnumerable() Select p.Field(Of String)("Department")).Distinct().ToList()  
  30. If RateChart.Series.Count() = 1 Then  
  31. RateChart.Series.Remove(RateChart.Series(0))  
  32. End If  
  33. For Each department As String In departments.ToList()  
  34. Dim department1 As String = department  
  35. Dim X As Integer()  
  36. X = (From p In dtInt.AsEnumerable()  
  37. Where p.Field(Of String)("Department") = department1  
  38. Order By p.Field(Of String)("Period_Shown")  
  39. Select Convert.ToInt32(p.Field(Of String)("Period_Shown"))).ToArray()  
  40. Dim Y As Decimal()  
  41. Y = (From p In dtInt.AsEnumerable()  
  42. Where p.Field(Of String)("Department") = department1  
  43. Order By p.Field(Of String)("Period_Shown")  
  44. Select Convert.ToDecimal(p.Field(Of String)("Rate_Int"))).ToArray()  
  45. departments.Add(department1)  
  46. RateChart.Series.Add(New Series(department1))  
  47. RateChart.Series(department1).IsValueShownAsLabel = True  
  48. RateChart.Series(department1).BorderWidth = 3  
  49. RateChart.Series(department1).ChartType = SeriesChartType.Line  
  50. RateChart.Series(department1).Points.DataBindXY(X, Y)  
  51. Next  
  52. RateChart.Legends(0).Enabled = True  
  53. End Sub 
The data table is shown as follow:
 
DepartmentPeriod_ShownRate_Int
DMG 2015_Jan 0.00
DMG 2015_Feb 0.00
DMG 2015_Mar 0.00
DMG 2015_Apr 0.00
DMG 2015_May 0.00
DMG 2015_Jun 0.00
DMG 2015_Jul 0.63
DMG 2015_Aug 0.93
DMG 2015_Sep 0.89
DMG 2015_Oct 0.47
DMG 2015_Nov 0.49
DMG 2015_Dec 0.49
DMG 2016_Jan 0.34
DMG 2016_Feb 0.41
DMG 2016_Mar 0.46
DMG 2016_Apr 0.20
DMG 2016_May 0.49
DMG 2016_Jun 0.43
DMG 2016_Jul 0.28
DMG 2016_Aug 0.77
DMG 2016_Sep 0.73
DMG 2016_Oct 0.70
DMG 2016_Nov 1.03
DMG 2016_Dec 0.47
DMG 2017_Jan 0.61
DMG 2017_Feb 0.35
DMG 2017_Mar 0.45
DMG 2017_Apr 0.66
DMG 2017_May 0.87
DMG 2017_Jun 0.71
DMG 2017_Jul 0.49
DMG 2017_Aug 0.51
DMG 2017_Sep 0.41
DMG 2017_Oct 0.40
DMG 2017_Nov 0.34
DMG 2017_Dec 0.50
DMG 2018_Jan 0.64
DMG 2018_Feb 0.46
DMG 2018_Mar 0.60
DMG 2018_Apr 0.82
DMG 2018_May 0.69
DMG 2018_Jun 0.71
DMG 2018_Jul 0.73
DMG 2018_Aug 0.95
DMG 2018_Sep 0.45
DMG 2018_Oct 0.53
DMG 2018_Nov 0.80
DMG 2018_Dec 0.41
DMG 2019_Jan 0.56
DMG 2019_Feb 0.44
DMG 2019_Mar 0.23
DMG 2019_Apr 1.03
DMG 2019_May 0.65
DMG 2019_Jun 0.36
DMG 2019_Jul 0.48
DMG 2019_Aug 0.78
DMG 2019_Sep 0.62
DMG 2019_Oct 0.72
DMG 2019_Nov 0.64
DMG 2019_Dec 0.54
DMG 2020_Jan 0.69
MGW_11A 2015_Jan 0.00
MGW_11A 2015_Feb 0.00
MGW_11A 2015_Mar 0.00
MGW_11A 2015_Apr 0.00
MGW_11A 2015_May 0.00
MGW_11A 2015_Jun 0.00
MGW_11A 2015_Jul 0.80
MGW_11A 2015_Aug 1.68
MGW_11A 2015_Sep 2.52
MGW_11A 2015_Oct 0.00
MGW_11A 2015_Nov 0.92
MGW_11A 2015_Dec 1.67
MGW_11A 2016_Jan 0.00
MGW_11A 2016_Feb 0.00
MGW_11A 2016_Mar 0.00
MGW_11A 2016_Apr 0.00
MGW_11A 2016_May 0.00
MGW_11A 2016_Jun 0.00
MGW_11A 2016_Jul 0.76
MGW_11A 2016_Aug 0.00
MGW_11A 2016_Sep 0.77
MGW_11A 2016_Oct 1.29
MGW_11A 2016_Nov 1.64
MGW_11A 2016_Dec 0.00
MGW_11A 2017_Jan 0.79
MGW_11A 2017_Feb 0.00
MGW_11A 2017_Mar 0.00
MGW_11A 2017_Apr 0.00
MGW_11A 2017_May 0.00
MGW_11A 2017_Jun 0.73
MGW_11A 2017_Jul 0.00
MGW_11A 2017_Aug 0.00
MGW_11A 2017_Sep 0.86
MGW_11A 2017_Oct 0.72
MGW_11A 2017_Nov 0.00
MGW_11A 2017_Dec 0.67
MGW_11A 2018_Jan 1.33
MGW_11A 2018_Feb 0.73
MGW_11A 2018_Mar 0.68
MGW_11A 2018_Apr 0.00
MGW_11A 2018_May 0.72
MGW_11A 2018_Jun 1.44
MGW_11A 2018_Jul 1.34
MGW_11A 2018_Aug 1.35
MGW_11A 2018_Sep 0.00
MGW_11A 2018_Oct 0.00
MGW_11A 2018_Nov 0.00
MGW_11A 2018_Dec 0.00
MGW_11A 2019_Jan 0.00
MGW_11A 2019_Feb 0.00
MGW_11A 2019_Mar 0.65
MGW_11A 2019_Apr 0.66
MGW_11A 2019_May 0.65
MGW_11A 2019_Jun 1.80
MGW_11A 2019_Sep 0.00
MGW_11A 2019_Oct 1.93
MGW_11A 2019_Nov 0.00
MGW_11A 2019_Dec 0.00
MGW_11A 2020_Jan 1.30
MGW_11B 2015_Jan 0.00
MGW_11B 2015_Feb 0.00
MGW_11B 2015_Mar 0.00
MGW_11B 2015_Apr 0.00
MGW_11B 2015_May 0.00
MGW_11B 2015_Jun 0.00
MGW_11B 2015_Jul 0.00
MGW_11B 2015_Aug 0.00
MGW_11B 2015_Sep 0.00
MGW_11B 2015_Oct 0.00
MGW_11B 2015_Nov 0.00
MGW_11B 2015_Dec 0.00
MGW_11B 2016_Jan 0.00
MGW_11B 2016_Feb 0.00
MGW_11B 2016_Mar 0.00
MGW_11B 2016_Apr 0.00
MGW_11B 2016_May 0.00
MGW_11B 2016_Jun 0.00
MGW_11B 2016_Jul 0.00
MGW_11B 2016_Aug 1.26
MGW_11B 2016_Sep 0.00
MGW_11B 2016_Oct 0.00
MGW_11B 2016_Nov 0.80
MGW_11B 2016_Dec 0.00
MGW_11B 2017_Jan 0.00
MGW_11B 2017_Feb 0.00
MGW_11B 2017_Mar 0.00
MGW_11B 2017_Apr 0.74
MGW_11B 2017_May 0.67
MGW_11B 2017_Jun 0.00
MGW_11B 2017_Jul 0.00
MGW_11B 2017_Aug 0.00
MGW_11B 2017_Sep 0.00
MGW_11B 2017_Oct 0.00
MGW_11B 2017_Nov 0.00
MGW_11B 2017_Dec 0.00
MGW_11B 2018_Jan 0.00
MGW_11B 2018_Feb 0.72
MGW_11B 2018_Mar 0.00
MGW_11B 2018_Apr 0.00
MGW_11B 2018_May 0.00
MGW_11B 2018_Jun 0.68
MGW_11B 2018_Jul 0.64
MGW_11B 2018_Aug 0.00
MGW_11B 2018_Sep 0.73
MGW_11B 2018_Oct 0.00
MGW_11B 2018_Nov 0.00
MGW_11B 2018_Dec 0.00
MGW_11B 2019_Jan 0.00
MGW_11B 2019_Feb 1.47
MGW_11B 2019_Mar 0.00
MGW_11B 2019_Apr 0.66
MGW_11B 2019_May 0.66
MGW_11B 2019_Jun 0.00
MGW_11B 2019_Jul 0.00
MGW_11B 2019_Aug 1.33
MGW_11B 2019_Sep 0.00
MGW_11B 2019_Oct 0.68
MGW_11B 2019_Nov 1.38
MGW_11B 2019_Dec 0.63
MGW_11B 2020_Jan 0.00
MGW_12A 2015_Jan 0.00
MGW_12A 2015_Feb 0.00
MGW_12A 2015_Mar 0.00
MGW_12A 2015_Apr 0.00
MGW_12A 2015_May 0.00
MGW_12A 2015_Jun 0.00
MGW_12A 2015_Jul 1.29
MGW_12A 2015_Aug 0.00
MGW_12A 2015_Sep 0.00
MGW_12A 2015_Oct 0.00
MGW_12A 2015_Nov 1.74
MGW_12A 2015_Dec 0.00
MGW_12A 2016_Jan 0.00
MGW_12A 2016_Feb 0.00
MGW_12A 2016_Mar 0.00
MGW_12A 2016_Apr 0.00
MGW_12A 2016_May 0.00
MGW_12A 2016_Jun 0.00
MGW_12A 2016_Jul 0.00
MGW_12A 2016_Aug 0.00
MGW_12A 2016_Sep 0.73
MGW_12A 2016_Oct 0.72
MGW_12A 2016_Nov 0.00
MGW_12A 2016_Dec 0.72
MGW_12A 2017_Jan 0.71
MGW_12A 2017_Feb 0.76
MGW_12A 2017_Mar 0.70
MGW_12A 2017_Apr 0.71
MGW_12A 2017_May 0.67
MGW_12A 2017_Jun 0.00
MGW_12A 2017_Jul 1.33
MGW_12A 2017_Aug 0.68
MGW_12A 2017_Sep 0.00
MGW_12A 2017_Oct 1.34
MGW_12A 2017_Nov 0.69
MGW_12A 2017_Dec 0.00
MGW_12A 2018_Jan 0.00
MGW_12A 2018_Feb 0.72
MGW_12A 2018_Mar 1.33
MGW_12A 2018_Apr 0.71
MGW_12A 2018_May 1.43
MGW_12A 2018_Jun 0.74
MGW_12A 2018_Jul 0.00
MGW_12A 2018_Aug 0.00
MGW_12A 2018_Sep 0.00
MGW_12A 2018_Oct 0.00
MGW_12A 2018_Nov 1.35
MGW_12A 2018_Dec 0.00
MGW_12A 2019_Jan 1.26
MGW_12A 2019_Feb 0.00
MGW_12A 2019_Mar 0.00
MGW_12A 2019_Apr 0.67
MGW_12A 2019_May 0.65
MGW_12A 2019_Jun 1.31
MGW_12A 2019_Jul 0.66
MGW_12A 2019_Aug 0.65
MGW_12A 2019_Sep 0.67
MGW_12A 2019_Oct 0.65
MGW_12A 2019_Nov 1.36
MGW_12A 2019_Dec 0.00
MGW_12A 2020_Jan 0.00
MGW_12B 2015_Jan 0.00
MGW_12B 2015_Feb 0.00
MGW_12B 2015_Mar 0.00
MGW_12B 2015_Apr 0.00
MGW_12B 2015_May 0.00
MGW_12B 2015_Jun 0.00
MGW_12B 2015_Jul 1.77
MGW_12B 2015_Aug 0.83
MGW_12B 2015_Sep 0.89
MGW_12B 2015_Oct 0.00
MGW_12B 2015_Nov 0.00
MGW_12B 2015_Dec 0.82
MGW_12B 2016_Jan 0.73
MGW_12B 2016_Feb 0.00
MGW_12B 2016_Mar 2.20
MGW_12B 2016_Apr 0.00
MGW_12B 2016_May 0.77
MGW_12B 2016_Jun 0.00
MGW_12B 2016_Jul 1.53
MGW_12B 2016_Aug 0.74
MGW_12B 2016_Sep 0.76
MGW_12B 2016_Oct 1.50
MGW_12B 2016_Nov 0.81
MGW_12B 2016_Dec 0.00
MGW_12B 2017_Jan 0.88
MGW_12B 2017_Feb 0.00
MGW_12B 2017_Mar 0.77
MGW_12B 2017_Apr 0.00
MGW_12B 2017_May 0.72
MGW_12B 2017_Jun 0.73
MGW_12B 2017_Jul 0.72
MGW_12B 2017_Aug 0.71
MGW_12B 2017_Sep 0.00
MGW_12B 2017_Oct 0.00
MGW_12B 2017_Nov 0.00
MGW_12B 2017_Dec 0.69
MGW_12B 2018_Jan 0.00
MGW_12B 2018_Feb 0.00
MGW_12B 2018_Mar 0.00
MGW_12B 2018_Apr 0.00
MGW_12B 2018_May 0.00
MGW_12B 2018_Jun 0.73
MGW_12B 2018_Jul 0.72
MGW_12B 2018_Aug 0.00
MGW_12B 2018_Sep 0.69
MGW_12B 2018_Oct 0.00
MGW_12B 2018_Nov 0.00
MGW_12B 2018_Dec 0.00
MGW_12B 2019_Jan 0.62
MGW_12B 2019_Feb 0.00
MGW_12B 2019_Mar 0.00
MGW_12B 2019_Apr 0.00
MGW_12B 2019_May 0.00
MGW_12B 2019_Jun 0.00
MGW_12B 2019_Jul 0.00
MGW_12B 2019_Aug 0.68
MGW_12B 2019_Sep 0.00
MGW_12B 2019_Oct 0.66
MGW_12B 2019_Nov 0.68
MGW_12B 2019_Dec 1.29
MGW_12B 2020_Jan 0.00
MGW_13A 2015_Jan 0.00
MGW_13A 2015_Feb 0.00
MGW_13A 2015_Mar 0.00
MGW_13A 2015_Apr 0.00
MGW_13A 2015_May 0.00
MGW_13A 2015_Jun 0.00
MGW_13A 2015_Jul 0.98
MGW_13A 2015_Aug 0.00
MGW_13A 2015_Sep 0.00
MGW_13A 2015_Oct 0.00
MGW_13A 2015_Nov 1.46
MGW_13A 2015_Dec 0.00
MGW_13A 2016_Jan 0.93
MGW_13A 2016_Feb 0.00
MGW_13A 2016_Mar 0.92
MGW_13A 2016_Apr 0.00
MGW_13A 2016_May 1.15
MGW_13A 2016_Jun 0.00
MGW_13A 2016_Jul 0.00
MGW_13A 2016_Aug 0.00
MGW_13A 2016_Sep 0.00
MGW_13A 2016_Oct 0.00
MGW_13A 2016_Nov 1.05
MGW_13A 2016_Dec 0.00
MGW_13A 2017_Jan 0.00
MGW_13A 2017_Feb 0.00
MGW_13A 2017_Mar 0.90
MGW_13A 2017_Apr 0.93
MGW_13A 2017_May 1.97
MGW_13A 2017_Jun 1.86
MGW_13A 2017_Jul 0.00
MGW_13A 2017_Aug 0.00
MGW_13A 2017_Sep 0.00
MGW_13A 2017_Oct 0.00
MGW_13A 2017_Nov 0.00
MGW_13A 2017_Dec 0.00
MGW_13A 2018_Jan 0.89
MGW_13A 2018_Feb 0.00
MGW_13A 2018_Mar 0.00
MGW_13A 2018_Apr 3.82
MGW_13A 2018_May 0.00
MGW_13A 2018_Jun 0.00
MGW_13A 2018_Jul 2.87
MGW_13A 2018_Aug 0.00
MGW_13A 2018_Sep 0.98
MGW_13A 2018_Oct 1.78
MGW_13A 2018_Nov 1.90
MGW_13A 2018_Dec 0.88
MGW_13A 2019_Jan 0.88
MGW_13A 2019_Feb 0.98
MGW_13A 2019_Mar 0.00
MGW_13A 2019_Apr 1.96
MGW_13A 2019_May 0.00
MGW_13A 2019_Jun 0.93
MGW_13A 2019_Jul 0.94
MGW_13A 2019_Aug 1.83
MGW_13A 2019_Sep 1.93
MGW_13A 2019_Oct 0.92
MGW_13A 2019_Nov 0.00
MGW_13A 2019_Dec 0.00
MGW_13A 2020_Jan 1.35
MGW_13B 2020_Jan 0.00
MGW_14B 2019_Jan 0.00
MGW_14B 2019_Feb 0.00
MGW_14B 2019_Mar 0.00
MGW_14B 2019_Apr 1.72
MGW_14B 2019_May 0.87
MGW_14B 2019_Jun 0.00
MGW_14B 2019_Jul 0.00
MGW_14B 2019_Aug 0.00
MGW_14B 2019_Sep 1.26
MGW_14B 2019_Oct 0.00
MGW_14B 2019_Nov 1.15
MGW_14B 2019_Dec 0.00
MGW_14B 2020_Jan 0.00
MGW_2C 2015_Jan 0.00
MGW_2C 2015_Feb 0.00
MGW_2C 2015_Mar 0.00
MGW_2C 2015_Apr 0.00
MGW_2C 2015_May 0.00
MGW_2C 2015_Jun 0.00
MGW_2C 2015_Jul 0.00
MGW_2C 2015_Aug 0.87
MGW_2C 2015_Sep 1.00
MGW_2C 2015_Oct 0.99
MGW_2C 2015_Nov 0.97
MGW_2C 2015_Dec 0.00
MGW_2C 2016_Jan 0.00
MGW_2C 2016_Feb 1.81
MGW_2C 2016_Mar 0.00
MGW_2C 2016_Apr 0.00
MGW_2C 2016_May 0.96
MGW_2C 2016_Jun 0.00
MGW_2C 2016_Jul 0.00
MGW_2C 2016_Aug 1.01
MGW_2C 2016_Sep 0.92
MGW_2C 2016_Oct 2.68
MGW_2C 2016_Nov 0.94
MGW_2C 2016_Dec 0.00
MGW_2C 2017_Jan 0.00
MGW_2C 2017_Feb 0.00
MGW_2C 2017_Mar 0.00
MGW_2C 2017_Apr 0.00
MGW_2C 2017_May 0.84
MGW_2C 2017_Jun 0.00
MGW_2C 2017_Jul 0.81
MGW_2C 2017_Aug 1.72
MGW_2C 2017_Sep 1.79
MGW_2C 2017_Oct 0.00
MGW_2C 2017_Nov 1.73
MGW_2C 2017_Dec 0.80
MGW_2C 2018_Jan 0.76
MGW_2C 2018_Feb 0.00
MGW_2C 2018_Mar 2.39
MGW_2C 2018_Apr 2.60
MGW_2C 2018_May 0.83
MGW_2C 2018_Jun 0.00
MGW_2C 2018_Jul 0.83
MGW_2C 2018_Aug 0.88
MGW_2C 2018_Sep 0.00
MGW_2C 2018_Oct 0.77
MGW_2C 2018_Nov 0.00
MGW_2C 2018_Dec 0.00
MGW_2C 2019_Jan 0.00
MGW_2C 2019_Feb 0.00
MGW_2C 2019_Mar 0.00
MGW_2C 2019_Apr 0.83
MGW_2C 2019_May 0.00
MGW_2C 2019_Jun 0.00
MGW_2C 2019_Jul 0.00
MGW_2C 2019_Aug 0.81
MGW_2C 2019_Sep 0.86
MGW_2C 2019_Oct 0.00
MGW_2C 2019_Nov 0.00
MGW_2C 2019_Dec 1.63
MGW_2C 2020_Jan 0.87
MGW_2D 2015_Jan 0.00
MGW_2D 2015_Feb 0.00
MGW_2D 2015_Mar 0.00
MGW_2D 2015_Apr 0.00
MGW_2D 2015_May 0.00
MGW_2D 2015_Jun 0.00
MGW_2D 2015_Jul 0.00
MGW_2D 2015_Aug 0.73
MGW_2D 2015_Sep 1.50
MGW_2D 2015_Oct 0.74
MGW_2D 2015_Nov 0.00
MGW_2D 2015_Dec 0.00
MGW_2D 2016_Jan 0.00
MGW_2D 2016_Feb 1.52
MGW_2D 2016_Mar 0.00
MGW_2D 2016_Apr 0.00
MGW_2D 2016_May 0.00
MGW_2D 2016_Jun 0.75
MGW_2D 2016_Jul 0.00
MGW_2D 2016_Aug 1.47
MGW_2D 2016_Sep 0.00
MGW_2D 2016_Oct 0.00
MGW_2D 2016_Nov 1.51
MGW_2D 2016_Dec 0.00
MGW_2D 2017_Jan 1.47
MGW_2D 2017_Feb 0.81
MGW_2D 2017_Mar 0.00
MGW_2D 2017_Apr 0.74
MGW_2D 2017_May 2.13
MGW_2D 2017_Jun 0.00
MGW_2D 2017_Jul 0.00
MGW_2D 2017_Aug 0.00
MGW_2D 2017_Sep 0.00
MGW_2D 2017_Oct 0.70
MGW_2D 2017_Nov 0.72
MGW_2D 2017_Dec 0.00
MGW_2D 2018_Jan 1.40
MGW_2D 2018_Feb 0.78
MGW_2D 2018_Mar 1.40
MGW_2D 2018_Apr 0.00
MGW_2D 2018_May 1.43
MGW_2D 2018_Jun 1.47
MGW_2D 2018_Jul 1.42
MGW_2D 2018_Aug 0.71
MGW_2D 2018_Sep 1.48
MGW_2D 2018_Oct 0.72
MGW_2D 2018_Nov 0.74
MGW_2D 2018_Dec 0.00
MGW_2D 2019_Jan 1.39
MGW_2D 2019_Feb 0.00
MGW_2D 2019_Mar 0.00
MGW_2D 2019_Apr 1.41
MGW_2D 2019_May 0.00
MGW_2D 2019_Jun 0.00
MGW_2D 2019_Jul 0.69
MGW_2D 2019_Aug 0.69
MGW_2D 2019_Sep 0.72
MGW_2D 2019_Oct 0.00
MGW_2D 2019_Nov 0.00
MGW_2D 2019_Dec 0.69
MGW_2D 2020_Jan 0.69
MGW_5AM 2020_Jan 0.00
MGW_5B 2015_Jan 0.00
MGW_5B 2015_Feb 0.00
MGW_5B 2015_Mar 0.00
MGW_5B 2015_Apr 0.00
MGW_5B 2015_May 0.00
MGW_5B 2015_Jun 0.00
MGW_5B 2015_Jul 0.00
MGW_5B 2015_Aug 1.58
MGW_5B 2015_Sep 0.00
MGW_5B 2015_Oct 0.00
MGW_5B 2015_Nov 0.00
MGW_5B 2015_Dec 1.79
MGW_5B 2016_Jan 0.00
MGW_5B 2016_Feb 0.00
MGW_5B 2016_Mar 0.77
MGW_5B 2016_Apr 0.00
MGW_5B 2016_May 0.00
MGW_5B 2016_Jun 0.00
MGW_5B 2016_Jul 0.00
MGW_5B 2016_Aug 0.83
MGW_5B 2016_Sep 1.70
MGW_5B 2016_Oct 0.00
MGW_5B 2016_Nov 0.00
MGW_5B 2016_Dec 0.00
MGW_5B 2017_Jan 0.00
MGW_5B 2017_Feb 0.00
MGW_5B 2017_Mar 0.00
MGW_5B 2017_Apr 0.00
MGW_5B 2017_May 0.00
MGW_5B 2017_Jun 0.00
MGW_5B 2017_Jul 0.71
MGW_5B 2017_Aug 0.00
MGW_5B 2017_Sep 0.76
MGW_5B 2017_Oct 0.76
MGW_5B 2017_Nov 0.00
MGW_5B 2017_Dec 2.13
MGW_5B 2018_Jan 0.64
MGW_5B 2018_Feb 1.48
MGW_5B 2018_Mar 0.67
MGW_5B 2018_Apr 0.00
MGW_5B 2018_May 0.00
MGW_5B 2018_Jun 0.00
MGW_5B 2018_Jul 0.00
MGW_5B 2018_Aug 1.49
MGW_5B 2018_Sep 0.00
MGW_5B 2018_Oct 0.00
MGW_5B 2018_Nov 0.00
MGW_5B 2018_Dec 0.65
MGW_5B 2019_Jan 0.65
MGW_5B 2019_Feb 0.00
MGW_5B 2019_Mar 0.64
MGW_5B 2019_Apr 0.00
MGW_5B 2019_May 1.33
MGW_5B 2019_Jun 0.00
MGW_5B 2019_Jul 0.70
MGW_5B 2019_Aug 0.68
MGW_5B 2019_Sep 0.00
MGW_5B 2019_Oct 0.00
MGW_5B 2019_Nov 0.78
MGW_5B 2019_Dec 0.00
MGW_5B 2020_Jan 3.02
MGW_5D 2015_Jan 0.00
MGW_5D 2015_Feb 0.00
MGW_5D 2015_Mar 0.00
MGW_5D 2015_Apr 0.00
MGW_5D 2015_May 0.00
MGW_5D 2015_Jun 0.00
MGW_5D 2015_Jul 0.00
MGW_5D 2015_Aug 0.00
MGW_5D 2015_Sep 0.00
MGW_5D 2015_Oct 0.00
MGW_5D 2015_Nov 0.00
MGW_5D 2015_Dec 0.00
MGW_5D 2016_Jan 0.00
MGW_5D 2016_Feb 0.00
MGW_5D 2016_Mar 0.00
MGW_5D 2016_Apr 0.00
MGW_5D 2016_May 0.00
MGW_5D 2016_Jun 0.00
MGW_5D 2016_Jul 0.00
MGW_5D 2016_Aug 0.00
MGW_5D 2016_Sep 0.00
MGW_5D 2016_Oct 0.00
MGW_5D 2016_Nov 2.89
MGW_5D 2016_Dec 0.00
MGW_5D 2017_Jan 0.00
MGW_5D 2017_Feb 1.51
MGW_5D 2017_Mar 0.00
MGW_5D 2017_Apr 0.00
MGW_5D 2017_May 1.21
MGW_5D 2017_Jun 4.98
MGW_5D 2017_Jul 0.00
MGW_5D 2017_Aug 0.00
MGW_5D 2017_Sep 2.57
MGW_5D 2017_Oct 0.00
MGW_5D 2017_Nov 0.00
MGW_5D 2017_Dec 2.44
MGW_5D 2018_Jan 1.23
MGW_5D 2018_Feb 1.29
MGW_5D 2018_Mar 0.00
MGW_5D 2018_Apr 1.16
MGW_5D 2018_May 0.00
MGW_5D 2018_Jun 1.21
MGW_5D 2018_Jul 0.00
MGW_5D 2018_Aug 2.32
MGW_5D 2018_Sep 0.00
MGW_5D 2018_Oct 1.15
MGW_5D 2018_Nov 0.00
MGW_5D 2018_Dec 0.00
MGW_5D 2019_Jan 0.00
MGW_5D 2019_Feb 0.00
MGW_5D 2019_Mar 0.00
MGW_5D 2019_Apr 0.00
MGW_5D 2019_May 0.00
MGW_5D 2019_Jun 0.00
MGW_5D 2019_Jul 1.13
MGW_5D 2019_Aug 0.00
MGW_5D 2019_Sep 1.21
MGW_5D 2019_Oct 1.11
MGW_5D 2019_Nov 1.21
MGW_5D 2019_Dec 1.11
MGW_5D 2020_Jan 0.00
MGW_6A 2015_Jan 0.00
MGW_6A 2015_Feb 0.00
MGW_6A 2015_Mar 0.00
MGW_6A 2015_Apr 0.00
MGW_6A 2015_May 0.00
MGW_6A 2015_Jun 0.00
MGW_6A 2015_Jul 0.00
MGW_6A 2015_Aug 1.52
MGW_6A 2015_Sep 0.82
MGW_6A 2015_Oct 0.00
MGW_6A 2015_Nov 0.00
MGW_6A 2015_Dec 0.00
MGW_6A 2016_Jan 1.81
MGW_6A 2016_Feb 0.00
MGW_6A 2016_Mar 1.61
MGW_6A 2016_Apr 0.00
MGW_6A 2016_May 0.83
MGW_6A 2016_Jun 1.74
MGW_6A 2016_Jul 0.00
MGW_6A 2016_Aug 1.66
MGW_6A 2016_Sep 1.66
MGW_6A 2016_Oct 0.78
MGW_6A 2016_Nov 1.25
MGW_6A 2016_Dec 1.63
MGW_6A 2017_Jan 2.41
MGW_6A 2017_Feb 0.80
MGW_6A 2017_Mar 0.78
MGW_6A 2017_Apr 1.46
MGW_6A 2017_May 0.68
MGW_6A 2017_Jun 0.00
MGW_6A 2017_Jul 0.00
MGW_6A 2017_Aug 0.70
MGW_6A 2017_Sep 0.00
MGW_6A 2017_Oct 0.00
MGW_6A 2017_Nov 0.00
MGW_6A 2017_Dec 0.00
MGW_6A 2018_Jan 0.00
MGW_6A 2018_Feb 0.00
MGW_6A 2018_Mar 0.00
MGW_6A 2018_Apr 0.00
MGW_6A 2018_May 0.74
MGW_6A 2018_Jun 0.00
MGW_6A 2018_Jul 0.72
MGW_6A 2018_Aug 0.76
MGW_6A 2018_Sep 0.00
MGW_6A 2018_Oct 0.00
MGW_6A 2018_Nov 0.74
MGW_6A 2018_Dec 0.00
MGW_6A 2019_Jan 0.00
MGW_6A 2019_Feb 0.74
MGW_6A 2019_Mar 0.00
MGW_6A 2019_Apr 0.72
MGW_6A 2019_May 0.00
MGW_6A 2019_Jun 0.00
MGW_6A 2019_Jul 0.00
MGW_6A 2019_Aug 0.00
MGW_6A 2019_Sep 0.00
MGW_6A 2019_Oct 0.68
MGW_6A 2019_Nov 0.00
MGW_6A 2019_Dec 0.00
MGW_6A 2020_Jan 0.69
MGW_6B 2015_Jan 0.00
MGW_6B 2015_Feb 0.00
MGW_6B 2015_Mar 0.00
MGW_6B 2015_Apr 0.00
MGW_6B 2015_May 0.00
MGW_6B 2015_Jun 0.00
MGW_6B 2015_Jul 1.54
MGW_6B 2015_Aug 1.52
MGW_6B 2015_Sep 1.58
MGW_6B 2015_Oct 0.86
MGW_6B 2015_Nov 0.00
MGW_6B 2015_Dec 0.00
MGW_6B 2016_Jan 0.00
MGW_6B 2016_Feb 0.00
MGW_6B 2016_Mar 0.00
MGW_6B 2016_Apr 0.00
MGW_6B 2016_May 0.00
MGW_6B 2016_Jun 1.47
MGW_6B 2016_Jul 0.00
MGW_6B 2016_Aug 0.77
MGW_6B 2016_Sep 1.57
MGW_6B 2016_Oct 0.79
MGW_6B 2016_Nov 0.78
MGW_6B 2016_Dec 2.21
MGW_6B 2017_Jan 0.00
MGW_6B 2017_Feb 0.76
MGW_6B 2017_Mar 0.71
MGW_6B 2017_Apr 0.73
MGW_6B 2017_May 0.00
MGW_6B 2017_Jun 2.17
MGW_6B 2017_Jul 0.69
MGW_6B 2017_Aug 1.46
MGW_6B 2017_Sep 0.00
MGW_6B 2017_Oct 0.72
MGW_6B 2017_Nov 0.71
MGW_6B 2017_Dec 0.00
MGW_6B 2018_Jan 0.65
MGW_6B 2018_Feb 0.00
MGW_6B 2018_Mar 0.00
MGW_6B 2018_Apr 1.42
MGW_6B 2018_May 2.08
MGW_6B 2018_Jun 1.44
MGW_6B 2018_Jul 0.68
MGW_6B 2018_Aug 2.66
MGW_6B 2018_Sep 0.69
MGW_6B 2018_Oct 0.65
MGW_6B 2018_Nov 2.15
MGW_6B 2018_Dec 0.65
MGW_6B 2019_Jan 1.29
MGW_6B 2019_Feb 0.72
MGW_6B 2019_Mar 0.00
MGW_6B 2019_Apr 2.71
MGW_6B 2019_May 0.66
MGW_6B 2019_Jun 0.00
MGW_6B 2019_Jul 0.66
MGW_6B 2019_Aug 1.92
MGW_6B 2019_Sep 1.99
MGW_6B 2019_Oct 2.57
MGW_6B 2019_Nov 1.37
MGW_6B 2019_Dec 1.29
MGW_6B 2020_Jan 0.00
MGW_9B 2015_Jan 0.00
MGW_9B 2015_Feb 0.00
MGW_9B 2015_Mar 0.00
MGW_9B 2015_Apr 0.00
MGW_9B 2015_May 0.00
MGW_9B 2015_Jun 0.00
MGW_9B 2015_Jul 1.56
MGW_9B 2015_Aug 1.82
MGW_9B 2015_Sep 3.11
MGW_9B 2015_Oct 2.80
MGW_9B 2015_Nov 0.95
MGW_9B 2015_Dec 1.54
MGW_9B 2016_Jan 0.77
MGW_9B 2016_Feb 1.49
MGW_9B 2016_Mar 0.00
MGW_9B 2016_Apr 2.27
MGW_9B 2016_May 2.26
MGW_9B 2016_Jun 0.78
MGW_9B 2016_Jul 0.80
MGW_9B 2016_Aug 1.53
MGW_9B 2016_Sep 0.00
MGW_9B 2016_Oct 0.75
MGW_9B 2016_Nov 1.70
MGW_9B 2016_Dec 0.72
MGW_9B 2017_Jan 0.72
MGW_9B 2017_Feb 0.00
MGW_9B 2017_Mar 1.47
MGW_9B 2017_Apr 2.46
MGW_9B 2017_May 2.06
MGW_9B 2017_Jun 0.00
MGW_9B 2017_Jul 1.32
MGW_9B 2017_Aug 0.69
MGW_9B 2017_Sep 0.00
MGW_9B 2017_Oct 0.00
MGW_9B 2017_Nov 0.00
MGW_9B 2017_Dec 0.00
MGW_9B 2018_Jan 1.27
MGW_9B 2018_Feb 0.00
MGW_9B 2018_Mar 0.65
MGW_9B 2018_Apr 1.41
MGW_9B 2018_May 0.70
MGW_9B 2018_Jun 0.72
MGW_9B 2018_Jul 0.00
MGW_9B 2018_Aug 1.53
MGW_9B 2018_Sep 0.71
MGW_9B 2018_Oct 1.30
MGW_9B 2018_Nov 2.63
MGW_9B 2018_Dec 2.48
MGW_9B 2019_Jan 0.62
MGW_9B 2019_Feb 1.44
MGW_9B 2019_Mar 1.26
MGW_9B 2019_Apr 0.65
MGW_9B 2019_May 2.52
MGW_9B 2019_Jun 1.26
MGW_9B 2019_Jul 1.30
MGW_9B 2019_Aug 0.66
MGW_9B 2019_Sep 0.67
MGW_9B 2019_Oct 0.00
MGW_9B 2019_Nov 0.68
MGW_9B 2019_Dec 0.64
MGW_9B 2020_Jan 1.38
MGW_CCU 2015_Jan 0.00
MGW_CCU 2015_Feb 0.00
MGW_CCU 2015_Mar 0.00
MGW_CCU 2015_Apr 0.00
MGW_CCU 2015_May 0.00
MGW_CCU 2015_Jun 0.00
MGW_CCU 2015_Jul 0.00
MGW_CCU 2015_Aug 0.00
MGW_CCU 2015_Sep 0.00
MGW_CCU 2015_Oct 0.00
MGW_CCU 2015_Nov 0.00
MGW_CCU 2015_Dec 0.00
MGW_CCU 2016_Jan 0.00
MGW_CCU 2016_Feb 0.00
MGW_CCU 2016_Mar 0.00
MGW_CCU 2016_Apr 0.00
MGW_CCU 2016_May 0.00
MGW_CCU 2016_Jun 0.00
MGW_CCU 2016_Jul 0.00
MGW_CCU 2016_Aug 0.00
MGW_CCU 2016_Sep 0.00
MGW_CCU 2016_Oct 0.00
MGW_CCU 2016_Nov 0.00
MGW_CCU 2016_Dec 0.00
MGW_CCU 2017_Jan 0.00
MGW_CCU 2017_Feb 0.00
MGW_CCU 2017_Mar 0.00
MGW_CCU 2017_Apr 0.00
MGW_CCU 2017_May 0.00
MGW_CCU 2017_Jun 0.00
MGW_CCU 2017_Jul 0.00
MGW_CCU 2017_Aug 0.00
MGW_CCU 2017_Sep 0.00
MGW_CCU 2017_Oct 0.00
MGW_CCU 2017_Nov 0.00
MGW_CCU 2017_Dec 0.00
MGW_CCU 2018_Jan 0.00
MGW_CCU 2018_Feb 0.00
MGW_CCU 2018_Mar 0.00
MGW_CCU 2018_Apr 0.00
MGW_CCU 2018_May 0.00
MGW_CCU 2018_Jun 0.00
MGW_CCU 2018_Jul 0.00
MGW_CCU 2018_Aug 0.00
MGW_CCU 2018_Sep 0.00
MGW_CCU 2018_Oct 0.00
MGW_CCU 2018_Nov 0.00
MGW_CCU 2018_Dec 0.00
MGW_CCU 2019_Jan 0.00
MGW_CCU 2019_Feb 0.00
MGW_CCU 2019_Mar 0.00
MGW_CCU 2019_Apr 0.00
MGW_CCU 2019_May 0.00
MGW_CCU 2019_Jun 0.00
MGW_CCU 2019_Jul 0.00
MGW_CCU 2019_Aug 0.00
MGW_CCU 2019_Sep 0.00
MGW_CCU 2019_Oct 0.00
MGW_CCU 2019_Nov 0.00
MGW_CCU 2019_Dec 0.00
MGW_CCU 2020_Jan 0.00
MGW_MANE 2018_Oct 16.13
MGW_MANE 2018_Nov 0.00
MGW_MANE 2018_Dec 0.00
MGW_MANE 2019_Jan 0.00
MGW_MANE 2019_Feb 0.00
MGW_MANE 2019_Mar 0.00
MGW_MANE 2019_Apr 4.20
MGW_MANE 2019_May 0.00
MGW_MANE 2019_Jun 0.00
MGW_MANE 2019_Jul 0.00
MGW_MANE 2019_Aug 0.00
MGW_MANE 2019_Sep 0.00
MGW_MANE 2019_Oct 0.00
MGW_MANE 2019_Nov 0.00
MGW_MANE 2019_Dec 0.00
MGW_MANE 2020_Jan 0.00
 
It seems to fail to create it :
 

Answers (2)