Skip to content
M.Trade

HLC Completion with Volume

Completes blank High, Low, and Close cells using the previous row’s closing price. Blank volume cells are set to zero.

Syntax

Section titled “Syntax”
MT_CompleteHLCV(Range)

Array formula.

Parameters

Section titled “Parameters”
  • range range Range containing High, Low, Close, and Volume.

Return Values

Section titled “Return Values”
  • High decimal Completed high price
  • Low decimal Completed low price
  • Close decimal Completed closing price
  • Volume decimal Volume