Candlestick visualization

Candlestick visualizations are used in analysis to display the high, low, open, and closing prices of, for example, stock prices for a specific period. The wide part of the candlestick shows if the closing price was higher or lower than the opening price.

About this task

Note: The candlestick custom visualization is not supported in Microsoft Internet Explorer 11.

For more information about the candlestick custom visualization sample on IBM Accelerator Catalog, see https://community.ibm.com/accelerators/catalog/content/Candlestick.

Candlestick visualizations are supported as of IBM® Cognos® Analytics 11.1.7.

Note: This sample custom visualization provides a way to show how to use a candlestick visualization in IBM Cognos Analytics.
Note: This sample visualization was created to address specific requirements and does not include all the features, interactivity, and properties of an out-of-the-box Cognos visualization. However, Cognos Analytics delivers a full set of fully-featured and powerful visualizations that are ready to use.

For more information about custom visualizations, see Developing custom visualizations. For an excellent tutorial to get you started, see Custom visualizations - tutorial.

You can download the packed bundle (.zip file) and upload it directly into IBM Cognos Analytics.

The following steps demonstrate how to use the candlestick visualization and populate it with data.

Procedure

  1. Create a dashboard and click the Visualization Change visualization icon icon in the toolbar.
  2. Click the Custom tab.
    If there are no custom visuals available, then you can add a custom visual by clicking the Add a custom visual Add a custom visual icon on the Custom tab.
  3. From the Custom visuals pane, select the candlestick visualization.
  4. Use the Stock_Market_Performance.xlsx data source. You can get the sample data here: https://public.dhe.ibm.com/software/data/sw-library/cognos/mobile/C11/custom_visualizations/data/Stock_Market_Performance.xlsx.
  5. Create the candlestick visualization by dragging the following data items from the Stock_Market_Performance.xlsx data source in the Sources pane Data icon:
    • Drag Date onto the Categories field.
    • Drag High onto the High field.
    • Drag Low onto the Low field.
    • Drag Open onto the Open field.
    • Drag Close onto the Close field.
    Use the body properties to set the color, shape, and padding of the candle bodies.
    Funnel visualization