Median Price

Median Price is a simple indicator that calculates the midpoint between the High and Low prices for a given period. It is often used as a filter for trend analysis or as a component in more complex indicators like the Alligator.

MEDIAN_PRICE

=MEDIAN_PRICE(data)

Example Usage

=MEDIAN_PRICE(A2:E500)

Parameters

Parameter Type Description Status
data
Range
The input range of columns. Must include at least 5 columns (Date, Open, High, Low, Close) to ensure correct mapping.
 Required

Return Value

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

Median Price Formula Result in Google Sheets