Typical Price (TP)


Calculates the typical price, which is the average of the high, low, and close prices for a given period.

Function Syntax

=TP(data)  
  • data (array):
    Range of columns containing the date, Open, high, Low, close, volume data.

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

Output Example

Below is an example of the resulting array when applying the custom =TP() function

tp return array