Skip to content
M.Trade

OHLC Completion with Volume

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

Syntax

Section titled “Syntax”
MT_CompleteOHLCV(Range)

Array formula.

Parameters

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

Return Values

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