Overview

Median prices are mid-point values of daily prices, and therefore can be used as a filter to help identify trends. They are also used as a daily average price which is very useful if you want a more simple "view" of prices.

Note
We recommend that you read Using Financial Formulas before proceeding any further. Using Financial Formulas provides a detailed explanation on how to use formulas, and also explains the various options available to you when applying a formula.

Figure 1: The Median Price, which is the daily average between Hi and Low prices.

Applying a Median Price

All formulas are calculated using the FormulaFinancial method, which accepts the following types of arguments: a formula name; input value(s); output value(s), and parameter(s) that are specific to the type of formula being applied.

Also, before applying the FormulaFinancial method, make sure that all data points have their XValue property set, and that their series' XValueIndexedproperty has been set to false.

The following table indicates what sort of FormulaFinancial method arguments to use when calculating a Median Price, and also supplies a description of what these parameters mean:

A line chart is a good choice when displaying a median price series.

Financial Interpretation: This indicator is good solution if we want to replace a stock chart with a single line chart. The Median Price is merely the daily average of Hi and Low prices.

Calculation: The Median price is calculated using the following formula:

Median price is the daily average of high and low prices.

Example

This example demonstrates how to calculate the Median price.

Visual Basic	Copy Code
Imports Dundas.Charting.WebControl ... With Chart1.DataManipulator ' Calculates Median Price. .FormulaFinancial(FinancialFormula.MedianPrice,"Series1:Y,Series1:Y2","Series2:Y") End With

C#	Copy Code
using Dundas.Charting.WebControl; ... // Calculates Median Price. Chart1.DataManipulator.FormulaFinancial(FinancialFormula.MedianPrice,"Series1:Y,Series1:Y2","Series2:Y");

See Also