Work it out
The starting values are an illustration, not a suggested trade or allocation.
Your inputs are not sent to a server or stored by this calculator.
Worked example
The first two rows become O 100 H 105 L 99 C 103 V 30. The third row forms a clearly marked partial second bar.
Use one row format consistently
Each row must contain open, high, low, close and volume, in that order. The input format is intentionally explicit; some exchange APIs return low and high before open. Reorder those fields before pasting.
Rows must already be oldest first. This tool has no timestamp column and does not sort, infer missing intervals or establish the timezone of a session boundary.
How a larger candle is constructed
The aggregate opens at the first input open and closes at the final input close. Its high is the maximum of all input highs; its low is the minimum of all input lows. Volume is the sum of the supplied volumes.
Averaging the closes would produce a different statistic, not the closing price. Summing volume is meaningful only if all rows use the same volume unit and cover distinct intervals.
Align the sequence before grouping
Grouping starts with the first pasted row. If you want five-minute bars from one-minute data, first align that row with the intended five-minute boundary and confirm there are no gaps.
The output is labelled complete by row count, not complete by calendar time. Five rows with a missing minute can still pass the row-count check and represent a different time span.
Recognize the final partial bar
If the row count is not divisible by the selected group size, the last output is explicitly marked partial. It remains in the output so that no data disappears silently.
For comparisons, decide whether to exclude the partial bar or mark it visibly. Do not compare it with a fully completed bar as though both cover the same interval.
What the aggregate cannot tell you
OHLC loses the ordering of events inside a bar. If both a target and a stop fall inside its range, the bar alone cannot prove which happened first.
The calculator checks that highs and lows contain the open and close, but a structurally valid row can still come from bad data. Exchange histories can omit periods without trades; check the source before interpreting gaps.
What this tool does not calculate
- Sequential row aggregation only, without timestamp alignment or gap detection.
- Maximum 500 input rows and 100 rows per group; volumes must use one consistent unit.
Common questions
Can I paste an exchange API response directly?
Only if you first convert it to the required OHLCV column order and chronological row order. Raw JSON arrays are not accepted.
Does the tool detect missing minutes?
No. There are no timestamps in the input. Confirm continuity and boundary alignment before aggregation.
Can an aggregate reveal which price was hit first?
No. High and low do not encode the path or ordering of trades within the bar.
Sources & method
An original calculation tool built with AI assistance. Its method and limits are documented here, and calculation examples are checked with automated tests.
Visit the main page
The main page describes this site and its existing channel route. This educational tool does not endorse a trade or a signal provider.
Visit the main page