Skip to content
M.Trade

DateTime and OHLC Completion

Completes blank Open, High, Low, and Close cells using the previous row’s closing price.

Syntax

Section titled “Syntax”
MT_CompleteDT_OHLC(Range)

Array formula.

Parameters

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

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