Easy Pivot Logo
  • Pricing

Manual

OverviewFolder SystemData Sources
Insight
Cross-Table / Pivot TableColumn / Line ChartAxis Style ConfigurationRadial BarPie ChartSunburst ChartTreemapMetric CardRanking BarBullet ChartWaterfall ChartBubble ChartFunnel ChartBoxplotCandlestick ChartHeatmapCircular Progress BarLiquid FillGaugeContrast Bar ChartRadar ChartSankey DiagramTree DiagramRelation DiagramWord CloudSVG MapArea MapAggregate Data Map3D MapDetail TableScatter Plot (Detailed Data)Latitude-Longitude Map (Local)Dynamic Ranking Bar Chart
Drill-down, Roll-upChart Fine-tuning Developer Mode
User and RoleRestful Interfaces

Integration

ChartsChart Detail

Candlestick Chart

Candlestick Chart

  1. Drawing a standard Candlestick chart requires four key metrics: Opening Price, Closing Price, Highest Price, and Lowest Price.
  2. If the data contains fewer than four metrics, the system will duplicate the last available metric to ensure the completeness of data required for the Candlestick chart.
  3. We recommend using directly calculated results to draw the Candlestick chart to ensure accuracy and performance.
  4. If computational performance allows, you can also use the Calculated Field function based on raw data, calculating opening and closing prices by grouping according to row dimensions and sorting by time, thereby generating the Candlestick chart. This method allows for more flexible data handling and is suitable for more complex analysis scenarios.

Moving Average Configuration

Moving averages in a Candlestick chart are a commonly used tool in technical analysis for observing price trend directions of financial products such as stocks, futures, and forex. Moving Average (MA) represents the average price over a certain period, smoothing price fluctuations and indicating trend direction.

Main Features

  1. Calculation Method The moving average is calculated by taking the average closing price over a specific past period (e.g., 5 days, 10 days, 20 days, etc.) and connecting these averages into a line.
  2. Common moving averages include: • Short-term MA: e.g., 5-day MA (MA5), 10-day MA, reflecting short-term trends. • Medium-term MA: e.g., 20-day MA, 50-day MA, reflecting medium-term trends. • Long-term MA: e.g., 120-day MA, 200-day MA, reflecting long-term trends.
  3. Configuration Method MA5 and MA10 are displayed by default. Users can input multiple MA configurations separated by English commas.

Focus Configuration

In a Candlestick chart, dataZoom is a commonly used feature for achieving localized focus and zoom on data, allowing users to concentrate on data from a specific time period within a larger range for analysis.

  • Default Focus Range: The percentage range that is focused on during initial loading.

Boxplot

Boxplot

Heatmap

Heatmap

On this page

Moving Average ConfigurationFocus Configuration
Log InStart Free