Spread WPF 15
GrapeCity.Windows.SpreadSheet.Data Namespace / SpreadOpenHighLowCloseSeries Class / CloseSeries Property
Example


In This Topic
    CloseSeries Property
    In This Topic
    Gets the close series.
    Syntax
    'Declaration
     
    Public ReadOnly Property CloseSeries As SpreadDataSeries
    'Usage
     
    Dim instance As SpreadOpenHighLowCloseSeries
    Dim value As SpreadDataSeries
     
    value = instance.CloseSeries
    public SpreadDataSeries CloseSeries {get;}

    Property Value

    The close series.
    Example
    This example sets the CloseSeries property.
    GrapeCity.Windows.SpreadSheet.Data.SpreadOpenHighLowCloseSeries open = new GrapeCity.Windows.SpreadSheet.Data.SpreadOpenHighLowCloseSeries();
    open.XValues = new GrapeCity.Windows.SpreadSheet.Data.DoubleSeriesCollection();
    open.XValues.Add(1);
    open.XValues.Add(2);
    open.XValues.Add(3);
    open.XValues.Add(4);
    open.XValues.Add(5);
    open.HighSeries.Values.AddRange(new double[] { 5, 7, 6, 8, 7, 9 });
    open.LowSeries.Values.AddRange(new double[] { 2, 4, 3, 5, 4, 6 });
    open.CloseSeries.Values.AddRange(new Double[] { 4, 6, 5, 7, 6, 8 });
    open.OpenSeries.Values.AddRange(new Double[] { 3, 8, 9, 10, 12, 6 });
    GrapeCity.Windows.SpreadSheet.Data.SpreadChart chart1 = new GrapeCity.Windows.SpreadSheet.Data.SpreadChart();
    chart1.ChartType = GrapeCity.Windows.SpreadSheet.Data.SpreadChartType.StockHighLowOpenClose;
    chart1.DataSeries.Add(open);
    chart1.Name = "Name";
    this.gcSpreadSheet1.ActiveSheet.Charts.Add(chart1);
    Dim open As New GrapeCity.Windows.SpreadSheet.Data.SpreadOpenHighLowCloseSeries()
    open.XValues = New GrapeCity.Windows.SpreadSheet.Data.DoubleSeriesCollection()
    open.XValues.Add(1)
    open.XValues.Add(2)
    open.XValues.Add(3)
    open.XValues.Add(4)
    open.XValues.Add(5)
    open.HighSeries.Values.AddRange(New Double() {5, 7, 6, 8, 7, 9})
    open.LowSeries.Values.AddRange(New Double() {2, 4, 3, 5, 4, 6})
    open.CloseSeries.Values.AddRange(New Double() {4, 6, 5, 7, 6, 8})
    open.OpenSeries.Values.AddRange(New Double() {3, 8, 9, 10, 12, 6})
    
    Dim chart1 As New GrapeCity.Windows.SpreadSheet.Data.SpreadChart()
    chart1.ChartType = GrapeCity.Windows.SpreadSheet.Data.SpreadChartType.StockHighLowOpenClose
    chart1.DataSeries.Add(open)
    chart1.Name = "Name"
    GcSpreadSheet1.ActiveSheet.Charts.Add(chart1)
    See Also