Skip to content
M.Trade

Date/Time and OHLCV Completion

Completes blank Open, High, Low, and Close cells using the previous row’s closing price. Combines the date and time into a single cell. If the time cell is blank, it is treated as 0:0. Blank volume cells are set to zero.

Syntax

Section titled “Syntax”
MT_CompleteDPlusT_OHLCV(Range)

Array formula.

Parameters

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

Return Values

Section titled “Return Values”
  • DateTime DateTime Combined 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