Typical Price (TP)

The Typical Price (TP) is a simple statistical measure that calculates the arithmetic average of the high, low, and closing prices for a given period. Its purpose is to provide a single, more representative price point for that period, rather than relying solely on the closing price. This value is not typically used as a standalone indicator but serves as a foundational building block for more complex indicators, most notably the Money Flow Index (MFI), which uses Typical Price to calculate raw money flow.

TP

=TP(data)

Example Usage

=TP(A2:F500)

Parameters

Parameter Type Description Status
data
Range
Range of columns containing the date, Open, high, Low, close, volume data.
 Required

Returns

A two-column array of dates and their corresponding TP values.

Typical Price Formula Result in Google Sheets