← THE CHARTSPOD LEDGEROPEN TERMINAL →
CHARTSPOD · FORMULA LAB

ChartsPod Formula Lab: Validate a Custom Series With Hand Calculations

A custom series is a hypothesis about the market written as a formula. Before trusting it, check a few values by hand.

By ChartsPod Editorial Team · Reviewed by ChartsPod Research
Published · Updated · 5 min read

Short answer

Validate a custom series in ChartsPod's Formula Lab by picking three to five specific bars, computing the expected value by hand or in a spreadsheet from the same inputs, and comparing with the plotted value. Check edge cases: the first bars (warm-up), bars with zero volume or missing data, and the live unfinished bar. Fix units and look-back definitions before comparing. ChartsPod's docs describe Tables and Formula Lab as moving from a watchlist to reproducible quantitative comparisons.

Hand-check procedure

Validating a custom seriesValidating a custom series. Steps: 1. Write the formula — In words first; 2. Pick 3–5 bars — Incl. edge cases; 3. Compute by hand — Same inputs; 4. Compare — Plotted vs expected; 5. Document — Formula and checks1Write theformulaIn words first2Pick 3–5 barsIncl. edge cases3Compute by handSame inputs4ComparePlotted vs expected5DocumentFormula and checks
Five checked bars catch most formula errors. Original ChartsPod editorial graphic.
BarInputsExpectedPlottedMatch?
Normal barclose, volumeyour valuechart value✓/✗
First bar after warm-uplook-back complete?
Zero-volume bardivision by zero?
Live barunfinished

Worked example

Formula idea: volume-weighted return over 3 bars = Σ(return × volume) / Σ(volume). Illustrative bars: returns +1%, −0.5%, +0.2% with volumes 100, 300, 200. Expected = (1×100 − 0.5×300 + 0.2×200) / 600 = (100 − 150 + 40)/600 = −0.0167%.

Illustrative inputs: volume by barIllustrative inputs: volume by bar: Bar 1 (+1.0%) 100 vol; Bar 2 (−0.5%) 300 vol; Bar 3 (+0.2%) 200 vol.ILLUSTRATIVE INPUTS: VOLUME BY BARBar 1 (+1.0%)100 volBar 2 (−0.5%)300 volBar 3 (+0.2%)200 vol
The heavy bar 2 turns a positive simple average into a negative weighted value. Original ChartsPod editorial graphic.

Control names in the terminal can change between releases. If a label differs from this guide, look for the setting that does the job described.

Document the series

Write the formula in plain language at the top of the series' notes: inputs, units, window, and what it is supposed to measure. Include the bars you hand-checked and their values. When you revisit it months later, you will know what it does without reverse-engineering it.

If the series feeds a screen or backtest, version it. A small formula change can alter every result downstream.

Pitfalls

  • Using future data (look-ahead) in a rolling window.
  • Mixing base and quote volume.
  • Treating missing as zero.
  • Comparing live-bar values with closed-bar values.

Build and hand-check a custom series in Formula Lab.

Open the ChartsPod terminal

Check several bars by hand, including edge cases, before using a custom series in screens or backtests.

Related: ChartsPod Backtesting: Set Fees and Slippage Before Comparing Results, ChartsPod Screener Results: Explain the Rule Behind Each Match.

Compare Formula Lab across Binance, Bybit, OKX and Hyperliquid markets.

Open markets in ChartsPod

Questions readers ask

What is Formula Lab?

ChartsPod's tool for building custom series and quantitative comparisons.

How many bars should I check?

Three to five, including warm-up, zero-volume and live bars.

Why does my series differ from my spreadsheet?

Usually different units, look-back alignment or missing-data handling.

Sources and methodology

ChartsPod capabilities were checked against its public overview, documentation index, markets and indicator pages on 17 October 2026. Exact control names inside the terminal can change between releases, so this guide describes what to set and check rather than quoting menu labels. Venue availability is shown per tool in the terminal. Worked examples use illustrative numbers.

  1. ChartsPod documentation — guides for order flow, derivatives, alerts, backtests, journal and workspaces.
  2. TradingView Pine Script: Repainting — live vs historical calculation.

This article explains research tools and workflows. It is not financial advice, does not recommend buying or selling any asset and does not predict prices. Crypto derivatives carry a risk of rapid and total loss of margin.

CHARTSPOD EDITORIAL EDITION · RESEARCH AND EDUCATION ONLY · NOT FINANCIAL ADVICE.