Stock Charts (Report Builder and SSRS)
Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).
A stock chart is specifically designed for financial or scientific data that uses up to four values per data point. These values align with the high, low, open and close values that are used to plot financial stock data. This chart type displays opening and closing values by using markers, which are typically lines or triangles. In the following example, the opening values are shown by the markers on the left, and the closing values are shown by the markers on the right.
An example of a stock chart is available as a sample SQL Server 2016 Report Builder report. For more information about downloading this sample report and others, see SQL Server 2016 Report Builder and Report Designer sample reports.
You can create and modify report definitions (.rdl) in Report Builder and in Report Designer in SQL Server Data Tools. Each authoring environment provides different ways to create, open, and save reports and related items. For more information, see Designing Reports in Report Designer and Report Builder (SSRS) on the Web at microsoft.com.
When presenting many stock data points, such as annual stock price trend, it is difficult to distinguish each open, close, high and low value of each data point. In this scenario, consider using a line chart instead of a stock chart.
When axis labels are generated, labeling usually begins at zero. In general, stock prices do not fluctuate to the same degree as other data sets. For this reason, you may want to disable the axis labels from starting at zero, in order to get a better view of your data. To do this, set IncludeZero to false in the Axis Properties dialog box or the Properties window. For more information about how the chart generates axis labels, see Formatting Axis Labels on a Chart (Report Builder and SSRS).
Reporting Services provides many calculated formulas for use with stock charts, including Price Indicator, Relative Strength Index, MACD and more.