What this helps you see
Encode Open, High, Low and Close fields in that order.
A practical use case
Show open, high, low and close in the required order and keep the reporting interval explicit.
Free example data and exact column mapping
The figure uses the downloadable CSV with the exact column mapping below. Public snapshots retain their data notes and transformations. Constructed teaching scenarios are identified in the method notes; they are not customer results. Editorial layouts may combine comparisons from the same records.
The free example contains 20 observations and these columns: Quarter, Open, High, Low, Close. Keep the header row and preserve one observation per row. The table below shows the first records; the CSV retains the full example.
Yahoo Finance · stored monthly-close snapshot, 2020–2024
Quarterly OHLC aggregated from the three monthly closing observations, not daily OHLC.
| Quarter | Open | High | Low | Close |
|---|---|---|---|---|
| 2020 Q1 | 3225.52001953125 | 3225.52001953125 | 2584.590087890625 | 2584.590087890625 |
| 2020 Q2 | 2912.429931640625 | 3100.2900390625 | 2912.429931640625 | 3100.2900390625 |
| 2020 Q3 | 3271.1201171875 | 3500.31005859375 | 3271.1201171875 | 3363 |
| 2020 Q4 | 3269.9599609375 | 3756.070068359375 | 3269.9599609375 | 3756.070068359375 |
| 2021 Q1 | 3714.239990234375 | 3972.889892578125 | 3714.239990234375 | 3972.889892578125 |
| 2021 Q2 | 4181.169921875 | 4297.5 | 4181.169921875 | 4297.5 |
How to use it in Datamon
- Sign in with Google, create a visualization and import the free CSV in Data. Check numeric columns, date order, decimal separator and missing values against the example table.
- In Visualize, choose Candlestick. Connect the required columns exactly as listed below, then inspect at least two marks against the data. Optional roles are available only when the chosen type exposes them.
- Keep the observation unit and reporting period explicit. Select the figure size before adjusting text, and check the chart at the size your reader will see.
Column mapping
- Categories / observation labels
- Quarter
- Open, High, Low, Close (in order)
- Open, High, Low, Close
How to read the example
Compare positions and values with the table, then inspect the legend or size encoding where used. A visual pattern is a description of the displayed observations. It does not by itself identify a cause, justify extrapolation, or repair missing data.
Refine and export the result
In Refine, edit the title, subtitle, axis descriptions, source and supported series settings. Use color to identify a comparison rather than to decorate every mark. Export SVG, PNG, JPEG, PDF or PowerPoint and inspect the actual file; save an editable project backup for revisions.
Limits and common mistakes
Range views require a stated meaning for every bound. Keep measures in the same unit and preserve their required order. A displayed interval may be an observed range, supplied scenario band or another quantity; its shape does not define statistical confidence.
This visualization is experimental in Datamon. Its current renderer and input contract are shown here, but validate the result with your own data before using it in a report. Specialized settings can differ from the stable chart types.
What is free and what needs an account?
Reading this guide and downloading its CSV and chart images are free. Datamon currently has no paid checkout or subscription plans in this deployment. Creating and saving an editable visualization requires Google sign-in. Provider-backed AI, cloud analysis, publishing and video depend on configured services; this guide does not promise unlimited free connected services.
Questions before you start
Can I visualize candlestick with a free example?
Yes. The CSV and preview images on this page are free to download. Follow the field mapping and steps above. Sign in to create and save the editable project; connected-service availability is separate.
Can I replace the example with my own data?
Yes. Preserve the observation unit and the required numeric, category or geographic fields. Recompute any derived values, update the unit and source, and compare the output with known rows before sharing.
Sources and further reading
Report a correction or an access barrier: Email the editorial contact.
Open Datamon