Volume-box construction with named spreadsheet macros

Two ways to store the builder

Spreadsheet automation for this construction can be stored either as a recorded keystroke sequence for repetitive layout work or as a command-macro that calculates and branches while each volume-box is built.

Command steps are typed as ordinary cell text and become executable only when enclosed in brace delimiters.

Named-labels and the working-block

A named-label can be bound to a single cell or to the working-block, a four-column array whose first cell is treated as the array origin.

Named-labels keep the construction readable and stay valid after rows or columns are inserted, whereas hard-coded coordinates can later point at the wrong cell.

How the command-macro starts

Execution starts by supplying the first command cell, by name or by address, through the spreadsheet macro-execute command or its assigned hot key.

A generated name-to-address table, or a label typed beside the bound cell, is used to recover locations when the builder is copied or a constant must be changed.

Spending volume into a volume-box

Each input bar supplies date, low, high, and volume. The command sequence initializes temporary high and low ticks from the cell-pointer, then stores those extremes as the upper-tick and lower-tick.

The loop repeatedly subtracts the volume-increment and advances a row offset until remaining volume is exhausted. After that loop returns, the builder writes the closing vertical side of the volume-box at the advanced row offset and then stores the starting row for the next volume-box.