Candlestick Chart
Analyze price movements showing open, high, low, and close values.
About Candlestick Chart
Candlestick charts are a style of financial chart used to describe price movements of a security, derivative, or currency. Each 'candlestick' typically shows one day, showing the opening, high, low, and closing (OHLC) prices.
How to Use
- Paste financial data — include Date, Open, High, Low, and Close columns.
- Auto-detection — the tool identifies the OHLC columns and sets the axis scale.
- Analyze trends — green candles indicate a price increase, while red indicates a decrease.
- Toggle zoom — use the data zoom slider to inspect specific time periods closely.
- Export — download as a high-density PNG or native PowerPoint chart.
Common Use Cases
- Stock Market Analysis — track daily or weekly price movements of equities.
- Crypto Trading — visualize volatility and price trends for digital assets.
- Commodity Tracking — monitor price fluctuations for gold, oil, or agricultural products.
- Forex Research — analyze currency pair performance over time.
Technical Details
Powered by Apache ECharts. Features high-performance large-scale data rendering and real-time zoom interaction.
Frequently Asked Questions
- Does it support volume data?
- Currently, we focus on OHLC price action. Volume bars and moving average overlays are planned for a future update.
- What data is a candlestick chart best suited for?
- Candlestick charts are the standard visualization for financial time series data with Open, High, Low, and Close (OHLC) values per time period — such as daily stock prices, cryptocurrency trading data, commodity futures, or forex exchange rates. They reveal price trends, momentum, and reversal patterns at a glance.
- How do I export my candlestick chart to PowerPoint?
- Click 'Download PPTX'. The chart is exported as a high-resolution image embedded in a PowerPoint slide, preserving candlestick colors (green for up, red for down), wicks, and the time axis. This is ideal for financial analysis decks, investment committee presentations, and trading strategy reports.
- How should I format data for a candlestick chart?
- Prepare five columns: Date (in YYYY-MM-DD or MM/DD/YYYY format), Open, High, Low, and Close (all numeric). Optionally include a Volume column for a volume bar chart below the candlesticks. Paste from Excel with headers in the first row, sorted chronologically from oldest to newest.
- Is my data processed securely?
- Yes. All candlestick chart rendering happens client-side in your browser. Your OHLC price data is never uploaded to any server, making this tool safe for proprietary trading data, backtesting datasets, and pre-publication financial research.
- Can I plot technical indicators like moving averages on the candlestick chart?
- The current candlestick chart renders OHLC (Open, High, Low, Close) bars and optionally volume. Adding computed technical indicators such as SMA, EMA, or Bollinger Bands requires pre-calculating those values in a spreadsheet and adding them as additional data columns. The chart will then plot them as overlay lines. For more advanced interactive TA charting with live data, a dedicated tool like TradingView is better suited — this tool excels at creating static chart images for reports and presentations.
Chart Data in PNG — Resume Editing
What is embedded chart data?
PNG exports and shared links may include your original chart data and settings. Anyone with the file or complete link may recover them.
How to use it
- Export your chart to PNG
- Keep the PNG file
- Drop or paste it into the "Resume Chart from PNG" tool any time you need to edit it again
- Your chart restores exactly as you left it — make changes and export again
Why this is better than static images
Other chart tools export PNG images that are final — once exported, you cannot edit them without redoing the work from scratch.
- No need to save the source spreadsheet separately — the PNG IS your backup
- Share a PNG with a colleague and they can restore and edit it without the original data
- Years later, if you need to update a chart, open the PNG and resume — no searching for old files
- For archival: keep PNGs alongside your reports and presentations; they are fully self-contained
Is it secure?
PNG exports and shared links may include your original chart data and settings. Anyone with the file or complete link may recover them.
Embed URL — Interactive Chart for Presentations
What is the Embed URL?
The Embed URL opens a clean, interactive version of your chart in a browser — showing only the chart with no tool interface, no settings panel, and no export buttons. Tooltips and hover interactions work fully. The chart data is encrypted in the URL, just like the Recovery Link.
Where to find it
- Click the "🔗 Embed URL" button on the chart tool page — it copies the URL to your clipboard instantly
- The embed URL is also saved below the slide boundary in your exported PPTX file, labeled "Embed URL — interactive view"
Using the Embed URL in Other Tools
The Embed URL works anywhere that supports iframes or URL embeds:
- Notion — paste the URL as an embed block (type /embed in Notion)
- Confluence — use the HTML macro or iframe macro with the embed URL
- SharePoint — embed via the Embed web part
Any website or intranet page — use a standard HTML iframe:
<iframe
src="YOUR_EMBED_URL"
width="800"
height="500"
frameborder="0"
allowfullscreen>
</iframe>Note on self-hosted deployments: If your organisation uses the self-hosted version of Lokaltools on your intranet, embed URLs point to your internal domain. These will only work for viewers on your company network or VPN — which may be exactly what your IT security team requires.
Chart Colors — Brand-Consistent Palettes in Seconds
Most charting tools give you a fixed color palette you cannot change, or require you to manually pick every color one by one. Lokaltools uses a three-step color system that starts from your company's brand color and builds a complete, harmonious palette automatically.
Step 1 — Brand Anchor
Enter your company's primary brand color as a hex code (e.g. #0066CC) in the Brand Anchor field. This is typically your main logo color, primary button color, or the dominant color from your brand guidelines. The brand anchor color is used as the starting point for all palette generation. Every color in your chart traces back to this single input — so your chart always feels on-brand without manual color selection.
Step 2 — Harmony
The Harmony dropdown selects the color theory rule used to generate the remaining chart colors from your brand anchor. Each harmony produces a different relationship between colors.
| Harmony | What it produces | Best for |
|---|---|---|
| Analogous | Colors adjacent on the color wheel — subtle, cohesive | Single-theme data, when colors should feel similar |
| Complementary | Two colors directly opposite — high contrast | Two-series comparisons, positive vs negative |
| Triadic (Balanced) | Three evenly spaced colors — vivid but balanced | Most business charts, 3-6 data series |
| Split Complementary | One anchor + two colors flanking its complement | Good contrast without full complementary tension |
| Tetradic | Four colors forming a rectangle on the wheel — rich | Charts with 4+ series needing maximum distinction |
Triadic (Balanced) is the default and works well for most business presentations. Switch to Analogous for a more subtle, conservative look, or Complementary when you want two data series to visually contrast strongly (e.g. budget vs actual).
Step 3 — Generated Swatches (Manual Override)
Below the harmony selector, the tool displays 5–6 generated color swatches — these are the actual colors that will appear on your chart. If any individual color does not work, click that swatch to open a color picker and replace it with any color you choose. Manual overrides are preserved in the recovery link.
Background mode (Light / Dark toggle): switches the palette lightness to suit your slide background. This adjusts the generated colors automatically so they remain readable.
Tips for Brand Color Usage
- Finding your exact brand hex code: Check your company's brand guidelines PDF, or right-click your company logo on the website → Inspect → find the CSS color value.
- When to use Analogous vs Triadic: Use Analogous when your chart has one dominant message and you want colors to feel unified. Use Triadic when each series represents a genuinely different thing (e.g. Revenue, Cost, Profit).
- Matching exported chart colors to your PowerPoint template: The PPTX Exact export preserves colors pixel-perfectly — what you see in the browser is exactly what appears in your PowerPoint slide.
Frequently Asked Questions
- Does this tool work offline?
- Yes — once the page has loaded, the tool works fully without an internet connection. The only exception is the Embed URL interactive view, which requires the chart tool page to be reachable when the embed is displayed.
- Can I use this for confidential or sensitive data?
- Yes. Your data is processed entirely in your browser using WebAssembly. It is never sent to Lokaltools servers or any third party. This makes the tool suitable for financial data, patient data, legal documents, and any other sensitive information.
- What data formats can I paste?
- Copy cells directly from Excel, Google Sheets, or Apple Numbers and paste — the tool auto-detects the format. CSV file upload is also supported. Data copied from web pages or PDFs may not paste correctly — clean it in Excel first.
- How do I find my company's brand hex color?
- Check your company's brand guidelines document or open your company website, right-click the logo or a branded button, select "Inspect", and look for a CSS color value starting with #.
- Can I save my brand color so I don't have to re-enter it every time?
- The brand anchor color is saved in the Recovery Link along with all other chart settings. Export your chart, then use the Recovery Link next time to restore your brand color automatically.
- Is the embedded chart data permanent?
- Yes. The embedded data is stored in the PNG file itself — not on any server — so there is no expiry. As long as you have the PNG file, you can restore and edit your chart.
- Can I share the PNG with a colleague?
- Yes — anyone with the PNG file can restore and edit the chart using the "Resume Chart from PNG" tool. Treat the PNG like a shared document: share only with people who should have access to the underlying data.
- What is the difference between embedded PNG data and Embed URL?
- Embedded PNG data contains your full chart state encrypted in the PNG file — you can drop it into the "Resume Chart from PNG" tool to edit and re-export. The Embed URL opens a view-only interactive chart with no editing capability.
Privacy & Security
This tool runs entirely in your browser. Your data follows this path: Your spreadsheet → Your browser → Your exported file. Nothing else. No upload step. No server processing. No analytics on your data content.
Chart PNG exports may contain the original chart data and settings as recoverable metadata. Recovery and embed links contain data and the key needed to open it in the URL fragment. Anyone with the file or complete link may recover that data. Share only with intended recipients. A fragment is normally omitted from HTTP requests, but JavaScript and services you share a link with can read it.
For organisations requiring formal confirmation: Lokaltools cannot read your data, does not store your data, and has no technical mechanism to access your data even if legally compelled to do so. This is not a policy — it is an architectural fact.
Technical Details
Powered by Apache ECharts for high-performance canvas rendering, PapaParse for intelligent CSV and tab-separated data parsing, and PptxGenJS for native OOXML chart objects. Magic link encryption uses the browser's built-in Web Crypto API (AES-256-GCM) with pako compression — no external encryption library required. All processing is 100% client-side. No data is transmitted at any point.
Local processing
Our local file, text and chart tools process content on your device using JavaScript, browser APIs and, where needed, WebAssembly. Our usage events do not include filenames, file contents, input text, chart values, raw errors, emails or license references. Network lookup tools (such as DNS, WHOIS, IP and speed tests) contact external services for their stated purpose. Loading the website, fonts, libraries and models also makes network requests. WebAssembly itself does not prevent network access.