Candlestick and OHLC Charts

Candlestick and OHLC (Open-High-Low-Close) charts are financial chart types that show price movements for an asset over a specific period. Use these charts to visualize the open, high, low, and close values, making it easier to analyze trends, volatility, and market behavior.

Example use cases

example

• Stock performance: Visualize daily opening, closing, high, and low prices for securities, stocks, or commodities.
• Currency analysis: Track fluctuations in exchange rates over time for comparison and forecasting.

Candlestick and OHLC type

	Chart	Description
	Candlestick	Shows open, high, low, and close prices with color-coded bars that highlight trends and market sentiment.
	OHLC	Uses tick marks to plot open, high, low, and close prices for each period, offering a clean view of price direction.

Create a candlestick or OHLC chart

1. Select Data Models and Views from the navigation panel.
2. Right-click the data model you want to use and select New View from the context menu.
3. In the Select a View dialog, select Candlestick or OHLC from the Financial category.
4. Enter a Name for the view. To assign names in other languages, select the translation icon next to the text box.
5. Select the fields you want to include for each section.
6. (Optional) Toggle Sample Mode to preview the data using a sample dataset.
7. Click Confirm. The new view opens with your initial settings.
8. Customize the view by using the view organizer, content area, and Toolbar.
9. In the Toolbar panel, select Save or Save As to save your changes.

Candlestick and OHLC settings

Setting	Description
Name	Enter a descriptive name for the worksheet. Select the translation icon to add labels for different languages—ideal for multilingual environments.
Sample Mode	Enable to open the worksheet in sample mode.
Define the Levels to be Used in Drill Down	Select which fields support drill-down functionality in the chart.
Opening values come from	Select the field that provides the first recorded value for each time interval.
High values come from	Select the field that contains the maximum value reached during each interval.
Low values come from	Select the field that contains the minimum value recorded during the interval.
Closing values come from	Select the field that provides the final recorded value for each time interval.