Skip to content
M.Trade

DateTime and OHLCV Completion

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_CompleteDT_OHLCV(Range)

Array formula.

Parameters

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

Return Values

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