Stock Charts with Excel

Stock Charts with Excel

Stock Charts reflect the price movement of a stock over time. The use of this chart is to predict future stock price movements, which is called expert analysis. Stock market analysts argue that repetition on the chart is inevitable for stock price movements on the graph and this is the basis for reference investors to bring success.

  • Step 1: Look at the volume of shares traded as well as the price movement. Identify stocks with increasing prices that have increased trading volume. This shows that the demand for these stocks is rising, and the ability of the stock price will increase. Note, avoid buying stocks that are falling prices but increased trading volume.
  • Step 2: Find out how to determine the support price. The price of a stock may fall to a certain level, then increase and then decrease to a certain level previously. We call this a support level because the stock price will not fall below this price. If the stock price drops below the support level, it will likely continue to fall and reach a new low.
  • Step 3: Determine the ceiling price of the stock. The ceiling price is the price that the stock is trying to overcome. It is likely to reach this price level and then gradually decline back to the original level. A stock that surpasses its ceiling price is considered a positive sign, which indicates that it will continue to rise.
  • Step 4: Study the stock price increase/decrease index. Each day, subtract the number of advancing shares, subtract the amount of promoting stock if the result is a positive number, it means that the increase/decrease index will increase. If the effect continues like this, this is a positive sign and vice versa.
  • Step 5: Understand the cycle of votes. Stocks will fluctuate between a support price and a ceiling. Buy the stock when it falls to the support level and start rising, sell the stock when it reaches the ceiling price, and start falling.

Stock Charts with Excel

  • In general, a security table consists of stock insurance dates, stock volumes, opening prices, closing prices, highest and lowest prices.
  • In this case, you need to create a Volume-Open-High-Low-Close chart.
  • Step 1: Select the data area, click Insert> Other Charts> Volume-Open-High-Low-Close.
  • Tips: In Excel 2013, click the Insert arrow> See All Charts, in the Insert Chart dialog box, select Stock> Volume-Open-High-Low-Close in the All Charts tab, click OK to close the dialog box.

=> We have inserted a Stock Chart that includes all stock data into Excel.

  • Step 2: In the default chart layout, the data may overlap. To view the chart more conveniently, you can format the Y axis.
  • Tips: In Excel 2013, reset the Maximum value in the Format Axis table.
  • Step 3: In the Format Axis dialog box, select the Fixed checkbox in the Maximum section, type the more significant number in the box until the data is no longer overlapping.
  • Step 4: Close the dialog box.
  • Tips: There are four types of Stock Charts in Excel, you can create a chart that suits your needs.

Create a Scatter Chart in Excel with Excel Office Component

  • So we have a rough look at the features and uses of the Stock Chart with Excel. Perhaps now you will want to create a Scatter Chart for yourself. However, creating a Stock Chart with Excel on the .NET platform will have a lot of difficulties when it is necessary to use a lot of different knowledge and tools.
  • No need to worry anymore cause you now have the full support of the Excel Office Component, making it easier than ever to create charts with Excel.
  • We will show you how to create yourself an Excel Stock Chart step-by-step, so please stick with us ;)
  • First, please create your own Dataset, which is an original Excel file, and we will proceed to draw a Radar chart based on this amount of data. To do this with the .NET platform, follow these simple steps:
  • C# Version:
        sheet.Range["B3"].Text = "Precipitation,in.";
        sheet.Range["C3"].Text = "Temperature,deg.F";

        sheet.Range["A4"].Text = "Jan";
        sheet.Range["A5"].Text = "Feb";
        sheet.Range["A6"].Text = "March";
        sheet.Range["A7"].Text = "Apr";
        sheet.Range["A8"].Text = "May";
        sheet.Range["A9"].Text = "June";
        sheet.Range["A10"].Text = "July";
        sheet.Range["A11"].Text = "Aug";
        sheet.Range["A12"].Text = "Sept";
        sheet.Range["A13"].Text = "Oct";
        sheet.Range["A14"].Text = "Nov";
        sheet.Range["A15"].Text = "Dec";

        sheet.Range["B4"].Number = 10.9;
        sheet.Range["B5"].Number = 8.9;
        sheet.Range["B6"].Number = 8.6;
        sheet.Range["B7"].Number = 4.8;
        sheet.Range["B8"].Number = 3.2;
        sheet.Range["B9"].Number = 1.4;
        sheet.Range["B10"].Number = 0.6;
        sheet.Range["B11"].Number = 0.7;
        sheet.Range["B12"].Number = 1.7;
        sheet.Range["B13"].Number = 5.4;
        sheet.Range["B14"].Number = 9.0;
        sheet.Range["B15"].Number = 10.4;

        sheet.Range["C4"].Number = 47.5;
        sheet.Range["C5"].Number = 48.7;
        sheet.Range["C6"].Number = 48.9;
        sheet.Range["C7"].Number = 50.2;
        sheet.Range["C8"].Number = 53.1;
        sheet.Range["C9"].Number = 56.3;
        sheet.Range["C10"].Number = 58.1;
        sheet.Range["C11"].Number = 59.0;
        sheet.Range["C12"].Number = 58.5;
        sheet.Range["C13"].Number = 55.4;
        sheet.Range["C14"].Number = 51.1;
        sheet.Range["C15"].Number = 47.8;
        sheet.UsedRange.AutofitColumns();
        
  • VB Version:
        sheet.Range("B3").Text = "Precipitation,in."
        sheet.Range("C3").Text = "Temperature,deg.F"

        sheet.Range("A4").Text = "Jan"
        sheet.Range("A5").Text = "Feb"
        sheet.Range("A6").Text = "March"
        sheet.Range("A7").Text = "Apr"
        sheet.Range("A8").Text = "May"
        sheet.Range("A9").Text = "June"
        sheet.Range("A10").Text = "July"
        sheet.Range("A11").Text = "Aug"
        sheet.Range("A12").Text = "Sept"
        sheet.Range("A13").Text = "Oct"
        sheet.Range("A14").Text = "Nov"
        sheet.Range("A15").Text = "Dec"

        sheet.Range("B4").Number = 10.9
        sheet.Range("B5").Number = 8.9
        sheet.Range("B6").Number = 8.6
        sheet.Range("B7").Number = 4.8
        sheet.Range("B8").Number = 3.2
        sheet.Range("B9").Number = 1.4
        sheet.Range("B10").Number = 0.6
        sheet.Range("B11").Number = 0.7
        sheet.Range("B12").Number = 1.7
        sheet.Range("B13").Number = 5.4
        sheet.Range("B14").Number = 9.0
        sheet.Range("B15").Number = 10.4

        sheet.Range("C4").Number = 47.5
        sheet.Range("C5").Number = 48.7
        sheet.Range("C6").Number = 48.9
        sheet.Range("C7").Number = 50.2
        sheet.Range("C8").Number = 53.1
        sheet.Range("C9").Number = 56.3
        sheet.Range("C10").Number = 58.1
        sheet.Range("C11").Number = 59.0
        sheet.Range("C12").Number = 58.5
        sheet.Range("C13").Number = 55.4
        sheet.Range("C14").Number = 51.1
        sheet.Range("C15").Number = 47.8
        sheet.UsedRange.AutofitColumns()
  • To create a new Excel file for storing output data - that is, a Scatter Chart, you can use the WorkbookManager class in our Excel Office Component library.
  • C# Version: WorkbookManager manager = new WorkbookManager();
  • VB Version: Dim manager As New WorkbookManager()
  • Once you've created a WorkbookManager, you can add new workbooks as well as specify the version of the newly created workbook.
  • Add a new workbook
  • C# Version: Workbook workbook = manager.Workbooks.Add();
  • VB Version: Dim workbook As Workbook = manager.Workbooks.Add()
  • Declare a new version
  • C# Version: workbook.Version = SaveAsFormat;
  • VB Version: workbook.Version = SaveAsFormat
  • You can then create yourself a new sheet:
  • C# Version: IWorksheet sheet = workbook.Worksheets[0];
  • VB Version: Dim sheet As IWorksheet = workbook.Worksheets(0)
  • After this step, everything is ready; you can now create your chart with the necessary attributes.
  • Add a new Chart
  • C# Version: IChart chart = workbook.Charts.Add();
  • VB Version: Dim sheet As IWorksheet = workbook.Worksheets(0)
  • Declare properties
  • C# Version:
        IChart chart = workbook.Charts.Add();
        chart.Name = "Radar Chart";
        chart.ChartTitle = "Radar Chart - Sales by Region";

        chart.DataRange = sheet.Range["A3:C15"];
  • VB Version:
        Dim chart As IChart = workbook.Charts.Add()
        chart.Name = "Radar Chart"
        chart.ChartTitle = "Radar Chart - Sales by Region"

        chart.DataRange = sheet.Range("A3:C15")
  • Select chart category and location:
  • C# Version:
        switch (Type)
        {
            case 0:
                chart.ChartType = ChartType.Stock_HighLowClose;
                break;

            case 1:
                chart.ChartType = ChartType.Stock_OpenHighLowClose;
                break;

            case 2:
                chart.ChartType = ChartType.Stock_VolumeHighLowClose;
                break;

            case 3:
                chart.ChartType = ChartType.Stock_VolumeOpenHighLowClose;
                break;

        }

        chart.IsSeriesInRows = true;
        chart.Legend.Position = ExcelLegendPosition.Bottom;
        chart.Legend.IsVerticalLegend = false;
  • VB Version:
      Select Case Type
            Case 0
                chart.ChartType = ChartType.Stock_HighLowClose

            Case 1
                chart.ChartType = ChartType.Stock_OpenHighLowClose

            Case 2
                chart.ChartType = ChartType.Stock_VolumeHighLowClose

            Case 3
                chart.ChartType = ChartType.Stock_VolumeOpenHighLowClose

        End Select

        chart.IsSeriesInRows = True
        chart.Legend.Position = ExcelLegendPosition.Bottom
        chart.Legend.IsVerticalLegend = False
  • And with the Activate() command, your Radar chart creation is complete.
  • C# Version: chart.Activate();
  • VB Version: chart.Activate()

The full source code of this example is also available in our Excel package.

A live demo for Stock Charts is also available on our site. If you also need Excel functionality, check out our Excel online demos.

45-Day Money Back Guarantee

We will refund your full money in 45 days
if you are not satisfied with our products

Buy Now
You have successfully subcribed to our mailing list.
Dont miss out Get update on new articles and other opportunities Subscribe