If you want to analyze some financial data over a period of time - an open-high-low-close chart would be very useful. You can easily track day-to-day changes of various financial metrics.
Let’s have a closer look at it together!
Open-high-low-close chart (also known as OHLC chart) is perfect to follow price changes over a certain period of time. A range of time is usually visualized on the x-axis. And y-axis is used to track value changes.
For each time point, two ranges are plotted:
the highest & lowest price - this two values will define the length of the line;
the open & close price - this values will be visualized as tick-marks on the line. Open price tick-mark will be positioned on the left of the line and close price - on the right.
Additionally each line is assigned a color according to the type of the market it represents - bullish (close price is higher than open) or bearish (the close price is lower).
Open-high-low-close 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! Based on your data lines with tick-marks will be plotted on 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.
Stroke width can also be regulated.
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.
A chart that is similar to the open-high-low-close chart is the candlestick chart.