Candlestick chart is a perfect choice for tracking and visualizing financial data. It is widely used in trading and usually describes price movements.
Let’s check it together!
Candlestick chart (also known as a Japanese candlestick chart or K-line) usually contains all the important info to follow trading trends and patterns over a period of time.
It consists of a different parts:
Body - this part represents the open & close price;
Candle wick - visualizes high & low price.
By default, the body is filled if the open price is higher than the close price - bearish market. And vice versa, the body is empty for the bullish market.
Candlestick chart can be found underneath the ‘Financial charts’ section. By drag & dropping it onto canvas, data can be added to the five dataslots - ‘Open’, ‘High’, ‘Low’, ‘Close’ and ‘Time’.
Columns with data type ‘date time’ are a perfect fit for this slot.
The column added to it defines the displayed time frame or period for which the chart shows data.
In the example below, the day level of a date column is used. Of course, other levels are also possible depending on your data - years, quarters, weeks, months, hours or even seconds.
Columns with data type ‘numeric’ or ‘currency’ are a perfect fit for this slot.
Simply drag and drop your data to the chart!
In the setting of the chart you can change the color of lower (‘bearish’ market) and higher (‘bullish’ market) categories. By default those are assigned red and green color accordingly.
Choose among a few options to fill candlestick - ‘default’, ‘always’ or ‘never’.
This chart can be filtered via the Brush filter by default. You can use this filter by clicking and dragging on an area of the chart. The "Clear filter" button will return the dashboard to the initial, unfiltered state. You can also disable the "Brush filter" in the "Interactivity" section of the chart settings.
One similar chart to the candlestick chart is the open-high-low-close.