[{"id":"425f2be4-b65d-4cdf-b543-fb4397f51672","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"a1041c29-1f9f-497e-b577-3e673e487c51","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"c1e3b2a0-7159-4980-a5e1-4fbb04c7fcc1","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"128acbbc-5c49-416b-9c1f-91f679362b23","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"3bc7a653-1dd3-4a33-b35c-41b0ddc2f446","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"cecedb46-bf12-401c-a04c-5282e11b8274","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"2f1768df-3e8b-41c2-826e-93f1a82273d1","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"d9528848-3bae-42c1-8f6d-410a78341cef","tags":[{"product":null,"links":null,"id":"4d7b6a40-ab32-4c71-a381-58f3ffd2653e","name":"new","color":"#ed7422","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"2683b3de-5c23-429d-9a88-4917616d20ad","tags":[{"product":null,"links":null,"id":"4d7b6a40-ab32-4c71-a381-58f3ffd2653e","name":"new","color":"#ed7422","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"b96827a0-6bd4-4184-86a4-6fe503d0e4b4","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"96d2140c-5bb6-49b6-a4c7-4af4b7de2e52","tags":[{"product":null,"links":null,"id":"4d7b6a40-ab32-4c71-a381-58f3ffd2653e","name":"new","color":"#ed7422","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"11f27d32-9547-4a8c-9e88-5dd2bffffeda","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"d186bc7e-cbae-4d23-9cd9-a54880be8e4d","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"26754bf1-707e-4815-b6d3-dcdc87a59188","tags":[{"product":null,"links":null,"id":"4d7b6a40-ab32-4c71-a381-58f3ffd2653e","name":"new","color":"#ed7422","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"e4c0a89e-cceb-4863-a30a-dff94f1d8d08","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"c4f826a6-5d16-4399-8f1a-7b8449594941","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"ff2b9815-2596-47f7-8793-3585c9ee24a2","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"46851ce2-51a2-4af4-969d-9fe989997135","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"e3e87330-5250-4923-9cdf-e7e8afd353ab","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"a04db983-f77b-4ec6-857c-1c01afaed85a","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"434eed34-9059-46e4-88f9-15e47d09622c","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"30988f2a-ebd5-4a8c-b20e-54a11a528d30","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"a59719c8-0df2-44e1-b89c-9d8fa0312857","tags":[{"product":null,"links":null,"id":"4d7b6a40-ab32-4c71-a381-58f3ffd2653e","name":"new","color":"#ed7422","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"4be1ecee-287b-43a2-ba99-cfa89de88187","tags":[{"product":null,"links":null,"id":"4d7b6a40-ab32-4c71-a381-58f3ffd2653e","name":"new","color":"#ed7422","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"ea04cced-7866-48e5-a5fe-1e9f11004d59","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"ab17d080-0112-4ba4-8dae-ef367bec7b78","tags":[{"product":null,"links":null,"id":"4d7b6a40-ab32-4c71-a381-58f3ffd2653e","name":"new","color":"#ed7422","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]}]
        
(Showing Draft Content)

Candlestick, High-Low-Close, and High-Low-Open-Close Plots

The Candlestick, High-Low-Close, and High-Low-Open-Close plots are suitable to show price movements of a currency or other assets over time. These plots arrange time along the horizontal axis and encode data values into shapes representing the high, low, open, and close prices.

Candlestick

A Candlestick plot encodes price points using rectangles that indicate the open and the close values. If the open value is greater than the close value, then the rectangle is filled with the background color. The high and low values are shown by vertical lines projecting from the top and bottom of a rectangle. For instance, the Candlestick Demo shows movement of the stock price for a virtual company.



High-Low-Close

A High-Low-Close plot encodes price points using lines with a marker. The marker indicates the closing value. The upper and the lower ends of the line indicate the high and low values, respectively. For instance, the High-Low-Close Demo shows movement of stock price for a virtual company.



High-Low-Open-Close

A High-Low-Open-Close plot encodes price points using lines with two markers. The marker on the left side of a line indicates the open value, the marker on the right side - close value. The upper and the lower ends of the line indicate the high and low values, respectively. For instance, the High-Low-Open-Close Demo shows movement of the stock price for a virtual company.




You can configure these charts using the Candlestick, High Low Close or High Low Open Close plot template and its properties that we described in the following sections.


You can use the following demos to explore plot properties - open a link, toggle the Report explorer, select the Plot - Plot 1 node and use the Properties panel to modify the configuration.

You could also download the report files listed below and open them in the Standalone Report Designer.

Chart Wizard

If you add a chart into a report, set the plot type to CandleStick, High-Low-Close or High-Low-Open-Close on the first page of the Chart Wizard, and click the Next button, the wizard shows the plot settings page that looks like the following:


Chart Wizard for Financial Charts


The Data Values section allows configuring Data Values.

The Data Categories section allows you to set the Category Encoding.

Data Values

The Values collection of Candlestick, High-Low-Close, and High-Low-Open-Close plots determines the data values containing the price points you want to visualize. The collection items include the the Value property that should be three or four bound field references or more advanced expressions. These expressions have labels high, low, open and close that helps you to configure corresponding values. For instance, the Candlestick Demo has the following Data Value:



Category Encoding

The Category Encoding of Candlestick, High-Low-Close, and High-Low-Open-Close plots is a set of properties that determine the period over which the plot generates shapes representing those above Data Values.

  • The Category is usually a bound field reference that indicates the date. For instance, the High-Low-Close Demo is bound to the dataset containing the High, Low, Close, and Date fields for each data record. The plot's Category is set to {Date} expression.

  • The Category Sorting configuration determines the order of the category values appearance.

The Chart Wizard offers the simplified editor of the Category Encoding in the Data Categories section:

  • A single Category Expression displayed as Field is available.

  • The Sorting configuration of the Category Encoding displays the Sort direction property only. The Sort Expression is automatically set to the Field value.

Candlestick, High-Low-Close, and High-Low-Open-Close look-and-feel

The following properties allow you to fine-tune the outfit of shapes that form the Candlestick, High-Low-Close and High-Low-Open-Close plots. You can see their effect in action by modifying the configuration of any of the demos listed above.


The Opacity is a Number in percentage that determines the opacity of shapes. 100% means they are opaque, and 0% means that they are entirely transparent.


The Clipping Mode indicates the manner that the plot area draws the plot:

  • Fit value means that the plot area should use all the available space to fit the plot

  • Clip value means that the plot area cuts off on the edge of its right or bottom padding

  • None value equals to Fit

The Background Color Expression determines the fill color of the rectangles that indicate the close price to be less than the open price in the candlestick plot.


The Style section has the line properties that allow you to set up the color, style, and width of rectangles border for candlestick plot and of lines for high-low-close and high-low-open-close plots.

Dynamic Rules

The Rules configuration allows you to create if this then that rules based on one or more data conditions to apply to the plot appearance. A condition is an expression that may refer to one of the following values:

  • Chart!CurrentDataHigh—the value of the high point in the current Data Value

  • Chart!CurrentDataLow—the value of the low point in the current Data Value

  • Chart!CurrentDataOpen—the value of the open point in the current Data Value

  • Chart!CurrentDataClose—the value of the close point in the current Data Value

  • Chart!NextDataHigh—the value of the high point in the next Data Value

  • Chart!NextDataLow—the value of the low point in the next Data Value

  • Chart!NextDataOpen—the value of the open point in the next Data Value

  • Chart!NextDataClose—the value of the close point in the next Data Value

  • Chart!PreviousDataHigh—the value of the high point in the previous Data Value

  • Chart!PreviousDataLow—the value of the low point in the previous Data Value

  • Chart!PreviousDataOpen—the value of the open point in the previous Data Value

  • Chart!PreviousDataClose—the value of the close point in the previous Data Value

  • Chart!CurrentCategory - the current Category Encoding value

  • Chart!PreviousCategory - the previous Category Encoding value

  • Chart!NextCategory - the next Category Encoding value

A condition expression can also include references to report parameters and standard operators. The easiest way to build a condition is to use the expression editor that you can open by click on the box on the right side of the Condition property.


The following visual properties of CandleStick, High-Low-Close and High-Low-Open-Close plots can be applied when a condition is met:

  • The background color of a candle

  • The color of the candle's border

  • The width of the candle's border

  • The style of the candle's border

For instance, you can set the following rules for the plot in the CandleStick Plot Demo to paint data points that have Closing price higher than the Opening price.


image.png


As a result, the output of the chart will be like this:


image.png