Creating a Candle Chart

A candle chart displays four different measures, “low,” “high,” “opening,” and “closing,” and is most often used to plot trading information. A candle chart is functionally similar to a stock chart.

To create a candle chart that displays the averaged high, low, opening, and closing prices by quarter, follow the steps below:

1. Create a new Viewsheet based on the 'Stock History' > 'Stock Prices' query.

2. Add a new Chart component to the Viewsheet, and open the Chart Editor.

3. Drag the 'Date' field from the 'Stock Prices' data block to the 'X' region of the Data panel.

4. Press the 'Edit Dimension' button next to the 'Date' field, and choose 'Quarter' from the 'Level' menu. Then press the green 'Apply' button.

 

5. Drag the 'High' field of the 'Stock Prices' query to the 'Y' region of the Data panel.

6. Press the 'Select Chart Style' button in the Data panel, and select the 'Candle' style. Press the green 'Apply' button.

 

Note that the Data panel now provides binding regions for 'High', 'Close', 'Open', and 'Low'.

 

7. Drag the 'Close/Last', 'Open', and 'Low' measures from the 'Stock Prices' data block to the appropriate regions of the Data panel, as shown below.

 

8. Press the 'Edit Measure' button next to the 'High' field, and choose 'Average' from the 'Aggregate' menu. Then press the green 'Apply' button.

 

9. Repeat the above step to set the aggregate to 'Average' for the other measures: 'Close/Last', 'Open', and 'Low'.

10. Preview the chart.

 

11. To observe the structure of the chart more closely, use the Zoom tool to view a more limited date range.

 

Note that for each quarter, the values of each of the measures (High, Low, Close/Last, Open) have been independently averaged. The “high” and “low” measures are represented by the extremes of the candle “wick,” and the “open” and “close” measures are represented by the extremes of the candle “body.” Candles for which the “open” measure exceeds the value of the “close” measure are shown filled. Candles for which the “close” measure exceeds the value of the “open” measure are shown unfilled.

 

See Also

Setting a Chart Style for an Individual Dataset, to set dataset-specific styles.

<< Creating a Pie Chart © 1996-2013 InetSoft Technology Corporation (v11.5) Creating a Table-Chart Hybrid >>