An OHLC chart displays a series of candlestick or bar markers that represent information about the price movement of a stock over a period of time. The price movement is determined by the open, high, low, and close mark values of the stock price which create the layout of the marker.
Additionally, you can add colors to the markers depending on the movement of the price for this period. If the close level is lower than the open level, it's recognized as a bearish pattern and the color or the fill or the marker changes. In this way, it is easily distinguished from the bullish pattern where the close level is higher than the open level.
The following image shows an example of a Candlestick OHLC chart:
You can modify the appearance of the OHLC series markers to cover the two most used types of OHLC charts, Candlestick and Bar.
Candlestick marker—The body of the Candlestick marker represents the open and close values of the stock price. The vertical lines (shadows or wicks) represent the high and low values. Based only on the shape of the marker, it is hard to tell if the stock price is rising or falling for the given period. In this case, you can add color to the marker body by using the conditional formatting rules of the data point.
Bar marker—The Bar markers represent the information about OHLC levels of the price using only lines. The low and high values are shown with a vertical line, and the open and close values are displayed with a horizontal lines. The horizontal line on the left side of the vertical line represents the opening price and the line on the right side represents the closing price. Although the bar marker doesn't need to be colored to understand the trend of the price, you can still apply additional conditional formatting for easier reading of the chart data.
In this section, you will create a Candlestick chart.
To add a new Graph report item to the report, refer to the article getting started with the Graph report item.
To define the Candlestick categories:
- On the Arrange graph fields page, drag the date column to the Categories box.
Drag the open, high, low, and close fields to their respective boxes in the bottom-right corner.
If you click the Set default datapoint styling checkbox, the wizard will add conditional formatting rules that will change the datapoint color depending on the open-close values.
Click the Finish button or set up additional properties of the DateTime scale. Click Finish. As a result, when you close the wizard, the newly created chart will appear.
Format the axis labels, set their angle, and add additional styling if necessary. The following image shows a possible layout of your chart:
The marker width is automatically calculated based on the following properties:
SpacingSlotCountproperty of the X scale.
MinMarkerWidthproperty of the series, which determines the minimum width of the marker, measured in
Unit, for example,
1cm, and so on.
By default, the wizard sets the
6px. Note the gaps between 07.07.2017 and 10.07.2017 where there are no data points.
Since you are using a DateTime field to create the categories, the wizard will automatically create a
DateTimeScale for your X axis. The
DateTime scale represents the values in a continuous domain which is the reason for you to see axis labels for 08.07.2017 and 09.07.2017 even if there is no data for these dates.
If you do not want to have such gaps, use a
CategoryScale for your X axis.