[{"id":"a20f26ac-cd31-4e4d-9454-1e035b0f1587","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"3604b8ce-1da0-413f-8274-7df0f7173573","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"7fce7040-1bb1-4a61-9fb7-2e19d569de50","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"0eb72dd3-8f8f-4039-93a8-500bbde2301e","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"ac046cee-82b9-4edf-a642-ae6d7cb21ebf","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"75b66fd4-b740-443d-bc6e-1782048b60a6","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"dde44832-bb5c-45f3-8ebf-3badbc613cd9","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"43de3664-261b-4cf9-9945-fb519251f4c7","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"2f064d57-b088-4bc5-a628-4e0d7e1a0c65","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"f290406b-ced1-4c52-abad-979160a79f6b","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"1864834b-08ce-43f1-891b-c3cca6e04e95","tags":[{"product":null,"links":null,"id":"4d7b6a40-ab32-4c71-a381-58f3ffd2653e","name":"new","color":"#ed7422","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"f96cfec1-420c-4ca7-ab0a-cab482731073","tags":[{"product":null,"links":null,"id":"4d7b6a40-ab32-4c71-a381-58f3ffd2653e","name":"new","color":"#ed7422","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"3f2ea860-c764-43d8-ae3f-6e3b0314ce67","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"81eb70e8-f770-4384-9167-bc7c755ad052","tags":[{"product":null,"links":null,"id":"4d7b6a40-ab32-4c71-a381-58f3ffd2653e","name":"new","color":"#ed7422","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"d0dff477-9f56-483a-a9fc-cab648905b41","tags":[{"product":null,"links":null,"id":"4d7b6a40-ab32-4c71-a381-58f3ffd2653e","name":"new","color":"#ed7422","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"793a62d7-460d-4699-9304-edb2941268ac","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"2d6ebfad-f7d1-4cc5-8ba1-fdace3472056","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"c8c7b5d5-f5bd-4b68-a12f-3aae9804a844","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"577a09da-dea1-42db-812f-4eeaa9274ece","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"8ddd80d5-886f-41b8-8e3f-f73aa8146c8d","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"e0909540-8bde-4587-bb4d-02445746db2a","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"464b8e03-462d-4aed-8818-05d32ec3bf00","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"f235557b-9781-471f-bf03-38bae6e3e953","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"fd5d021d-0210-4d74-ba42-1a39ef14a385","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"548568fe-dbd1-4da5-a489-d9b3edf75329","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"a0c823ed-e22b-493b-aded-4d201c0fa480","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"d19bc9cd-ff53-4b0d-ab7e-a68c1497c4c6","tags":[{"product":null,"links":null,"id":"4d7b6a40-ab32-4c71-a381-58f3ffd2653e","name":"new","color":"#ed7422","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"94759fce-692f-4779-b5f3-fce5c58f242c","tags":[{"product":null,"links":null,"id":"4d7b6a40-ab32-4c71-a381-58f3ffd2653e","name":"new","color":"#ed7422","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"27658163-a479-432f-a192-dbed286beb3e","tags":[{"product":null,"links":null,"id":"4d7b6a40-ab32-4c71-a381-58f3ffd2653e","name":"new","color":"#ed7422","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]}]
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.
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.
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.
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.
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:
The Data Values
section allows configuring Data Values.
The Data Categories
section allows you to set the Category Encoding.
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:
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.
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.
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.
As a result, the output of the chart will be like this: