Chart > Data Model > Values Data Groupings > Values Data Groupings  Calculated Series 
fig. 1  Values Data Groupings  Calculated Series tab
The Calculated Series are line or area series the values of which are calculated by a certain formula. The input values for the formula are the values of the master series to which the calculated series is attached. Calculated Series are very useful if you want to quickly display certain trendlines or other line or stock studies.
Calculated Series are added and removed from the Values Data Groupings  Calculated Series tab. Each calculated series has the following properties.
The general properties of the calculated series are:
Visible  controls the visibility of the calculated series.
Label  controls the label of the calculated series. The label is usually shown in the legend.
Show As  controls the way in which the calculated series are visualized. Possible values are:
Line  the calculated series are displayed as line.
Area  the calculated series are displayed as an area.
Smooth Line  the calculated series are displayed as a smooth line.
Smooth Area  the calculated series are displayed as a smooth area.
Formula  controls the formula that is used to extract values from the master series. The web part defines the following formulas:
Formula  Description  Parameters 

Statistical  General 

Min  Calculates the minimal of all master series values.  
Max  Calculates the maximum of all master series values.  
Median  Calculates the median of all master series values.  
Cumulative  Calculates the cumulative sum of the elements in the master series values. Each element of the result is equal to the previous element of the result plus the current element of master series values.  
Sum  Calculates the sum of all master series values.  
Average  Calculates the average of all master series values.  
Exponential Average  Calculates the exponential average of all master series values.  Weight  the 'weight' parameter is the exponential weight  a constant between 0 and 1. 
Root Mean Square 
Calculates the RMS of the of the master series values. The RMS is calculated via the following formula:


Standard Deviation  Standard deviation is used to indicate volatility, and measures the difference between values and their average. The function calculates the standard deviation for the elements in the master series values array. If the 'period' parameter is supplied the function calculates a "moving" standard deviation with the specified period (standard deviation with simple moving average).  Period  the 'period' defines the period for the function  it must be a constant greater or equal to 1. 
Linear Regression  Calculates the linear regression of the master series values. The calculation takes into account the X values of master series. If the master series is an XY scatter, you have the option to control whether the regression line is draw from the min to max X value (if UseXMinMax is checked) or from the first to the last item in the data set.  UseXMinMax  if the master series is an XY scatter, determines whether the regression line is drawn from min to the max x value or from the first to the last X value of the master series. 
Polynomial Regression  Calculates the polynomial regression of the master series values. The calculation takes into account the X values of master series. You have the option to control the polynomial order and thus create polynomial interpolations of second, third and higher degrees.  Polynomial Order  an integer value larger or equal to 2, that defines the degree of the polynomial regression. 
Statistical  Range Indicators  
Bollinger Bands 
Bollinger bands are displayed at a given number of standard deviations from a moving average of a price. Since standard deviation is a measure of volatility, the bands are selfadjusting: widening during volatile markets and contracting during calmer periods. Bollinger Bands were created by John Bollinger. To display the two Bollinger bands you can use two line series (one for the upper band and one for the lower band) or a single HiLow series. Mr. Bollinger recommends using 20 for the number of periods in the moving average, and using 2 standard deviations. He has also found that moving averages of less then 10 periods do not work very well. 
Period  the 'period' defines the period for the function  it must be a constant greater or equal to 1. Deviation  the 'deviation' defines the number of standard deviations the band is offset from the simple moving average of 'values'. For the upper band this must be a positive value and for the lower band  a negative value. 
Envelopes  Price envelopes are plotted at a specified percentage above and below a moving average. They are used to indicate overbought and oversold levels. The shift percentage should be set so that about 90% of price activity is contained within the bands. Adjust the band width if volatility increases over time. 
Period  the 'period' defines the period for the function  it must be a constant greater or equal to 1. Shift  the 'shift' defines the offset from the simple moving average of 'values' in percents. For the upper band this must be a positive value and for the lower band  a negative value. 
Statistical  Moving Averages 

Simple Moving Average  A Moving Average is an indicator that shows the average value of a security's price over a period of time. A simple, or arithmetic, moving average is calculated by adding the price of the security for a number of time periods (e.g., 12 days) and then dividing this total by the number of time periods. The result is the average price of the security over the time period. Simple moving averages give equal weight to each daily price. 
Period  the 'period' defines the period for the function  it must be a constant greater or equal to 1. 
Weighted Moving Average  A Moving Average is an indicator that shows the average value of a security's price over a period of time. A weighted moving average is designed to put more weight on recent data and less weight on past data. A weighted moving average is calculated by multiplying each of the previous day's data by a weight (the weight is the index of the data). 
Period  the 'period' defines the period for the function  it must be a constant greater or equal to 1. 
Exponential Moving Average 
A Moving Average is an indicator that shows the average value of a security's price over a period of time. An exponential (or exponentially weighted) moving average is calculated by applying a percentage of today's price to yesterday's moving average value. Exponential moving averages place more weight on recent prices. The formula of the exponential moving average is:

Period  the 'period' defines the period for the function  it must be a constant greater or equal to 1. 
Modified Moving Average 
A Moving Average is an indicator that shows the average value of a security's price over a period of time. The Modified Moving Average is actually the same as the Exponential Moving Average, but with one difference  the exponential percentage is calculated with the following formula:


Financial  Price Indicators 

Median Price 
Median Price is the midpoint of the trading range. It can be used as a filter for trend indicators. The median price for each day is calculated using the following formula: MP = (high + low) / 2 

Typical Price 
Typical Price is an approximation of average price for each period and can be used as a filter for moving average systems. The formula of the Typical Price is: TP = (close + high + low) / 3 

WeightedClose 
The Weighted Close indicator calculates the daily average of Hi, Low and Close prices. It is designed to put more weight on the Close values. The formula of the Weighted Close is: WC = (2 * close + high + low) / 4 

Financial  Directional Movement 

Positive Direction Indicator  The +DI function is a part of the Directional Movement System developed by J. Welles Wilder. The system consists of three lines:  The Positive Direction Indicator (+DI) summarizes upward trend movement;  The Negative Direction Indicator (DI) summarizes downward trend movement;  The Average Directional Movement Index (ADX) indicates whether the market is trending or ranging. For internal calculations the DI_POS function uses the modified moving average. 
Period  the 'period' defines the period for the function  it must be a constant greater or equal to 1. 
Negative Direction Indicator  The DI function is a part of the Directional Movement System developed by J. Welles Wilder. The system consists of three lines:  The Positive Direction Indicator (+DI) summarizes upward trend movement;  The Negative Direction Indicator (DI) summarizes downward trend movement;  The Average Directional Movement Index (ADX) indicates whether the market is trending or ranging. For internal calculations the DI_NEG function uses the modified moving average. 
Period  the 'period' defines the period for the function  it must be a constant greater or equal to 1. 
Directional Movement Index  The Average Directional Movement is a part of the Directional Movement System developed by J. Welles Wilder. The system consists of three lines:  The Positive Direction Indicator (+DI) summarizes upward trend movement;  The Negative Direction Indicator (DI) summarizes downward trend movement;  The Average Directional Movement Index (ADX) indicates whether the market is trending or ranging. Declining ADX shows that the market is losing direction. When ADX falls below both +DI and DI it signals a lifeless market. When ADX rises above both +DI and DI it signals that the market is becoming overheated. The ADX is defined as a moving average of the Directional Movement Index. By default, the Modified Moving Average is used for smoothing with a period of 14 days. You can use another type of moving average by changing the original formula. 
Period  the 'period' defines the period for the function  it must be a constant greater or equal to 1. 
Average Directional Movement  The Average Directional Movement is a part of the Directional Movement System developed by J. Welles Wilder. The system consists of three lines:  The Positive Direction Indicator (+DI) summarizes upward trend movement;  The Negative Direction Indicator (DI) summarizes downward trend movement;  The Average Directional Movement Index (ADX) indicates whether the market is trending or ranging. Declining ADX shows that the market is losing direction. When ADX falls below both +DI and DI it signals a lifeless market. When ADX rises above both +DI and DI it signals that the market is becoming overheated. The ADX is defined as a moving average of the Directional Movement Index. By default, the Modified Moving Average is used for smoothing with a period of 14 days. You can use another type of moving average by changing the original formula. 
Period  the 'period' defines the period for the function  it must be a constant greater or equal to 1. 
Financial  Technical Indicators 

Average True Range 
Average True Range is an indicator from J. Welles Wilder that measures commitment by comparing the range for each successive day. The True Range indicator is the greatest of the following: The Average True Range is a moving average (typically 14days) of the True Range. 
Period  the 'period' defines the period for the function  it must be a constant greater or equal to 1. 
Chaikins Volatility  The Chaikin Volatility function determines the volatility of a security using the percentage change in a moving average of the high versus low price over a given time period. It is most useful in conjunction with a moving average system or price envelopes. 
Period  the rate of change period. The recommended value is 10.

Commodity Channel Index  The Commodity Channel Index measures the position of price in relation to its moving average. It is used to highlight when the market is overbought/oversold or to signal when a trend is weakening. The indicator is similar in concept to Bollinger Bands but is presented as an indicator line rather than as a range. The Commodity Channel Index was developed by Donald Lambert. 
Period  the 'period' defines the period for the function  it must be a constant greater or equal to 1. 
Detrended Price Oscillator  The Detrended Price Oscillator compares the closing price (or any other price) to a prior moving average. This indicator attempts to eliminate the trend in prices. Detrended prices allow you to more easily identify cycles and overbought/oversold levels. 
Period  the 'period' defines the period for the function  it must be a constant greater or equal to 1. 
Mass Index  The Mass Index was designed to identify trend reversals by measuring the narrowing and widening of the trading range (high  low prices). As the range widens the Mass Index increases; as the range narrows the Mass Index decreases. The Mass Index was invented by Donald Dorsey. 
Period  is the accumulation period. The recommended value is 25

Momentum 
The Momentum indicator measures the amount that a security's price has changed over a given time span. It can be used as a trendfollowing oscillator similar to the MACD or as a leading indicator. The formula of the momentum is: Momentum[n] = values[n]  values[n  period] 
Period  the 'period' defines the period for the function  it must be a constant greater or equal to 1. 
Momentum Division 
The Momentum Division function is similar to the Momentum indicator. It calculates the ratio between a current value and the value, which is 'period' days before the current value. The formula of the Momentum Division is: MomentumDiv[n] = 100 * values[n] / values[n  period] 
Period  the 'period' defines the period for the function  it must be a constant greater or equal to 1. 
Moving Average Convergence Divergence 
The Moving Average Convergence Divergence (MACD) is a trend following momentum indicator that shows the relationship between two moving averages of prices. It is calculated by subtracting the value of a 26day exponential moving average from a 12day exponential moving average. The MACD proves most effective in wideswinging trading markets. In a market which is accelerating upwards, the short moving average will rise faster than the longer moving average. This will lead to a rising MACD. In a market which is accelerating downwards, the short moving average will fall faster than the longer moving average. This will lead to a falling MACD. The MACD was developed by Gerald Appel. 

Performance  The Performance indicator displays a security's price performance as a percentage. This is sometimes also called a normalized chart, as it enables to compare shares with differing price levels. The Performance indicator compares a current price value with the value from the first time period.  
Rate Of Change 
The Rate of Change indicator monitors market momentum. It calculates the market's rate of change relative to previous trading intervals. The Rate of Change indicator is calculated using the following formula: ROC = ((Today's value  Value n periods ago) / (Value n periods ago)) * 100 

Relative Strength Index 
Relative Strength Index (RSI) is a popular momentum oscillator developed by J. Welles Wilder. The Relative Strength Index compares upward movements in closing price to downward movements over a selected period. The RSI ranges between 0 and 100. The formula of the RSI is: RSI[n] = 100  (100 / (1 + U[n] / D[n])) where: Relative Strength Index is smoother than the Momentum or Rate of Change oscillators and is not as susceptible to distortion from unusually high or low prices at the start of the window. 
Period  the 'period' defines the period for the function  it must be a constant greater or equal to 1. 
Stochastic Oscillator 
The Stochastic Oscillator compares where a security's price closed relative to its price range over a given time period. The Simple Stochastic Indicator (%K) is calculated using the following formula: %K = 100 * (Today's close  LL) / (HH  LL) LL is the current lowest low value for the given time period. HH is the current highest high value for the given time period. The Smoothed Stochastic Indicator (%D) is calculated as a Moving Average of %K. For example you can use the following expression: SMA( STOCHASTIC(close; high; low; 10); 10 ) 
Period  the 'period' defines the period for the function  it must be a constant greater or equal to 1. 
TRIX  The TRIX indicator is based on a triple exponential moving average of the closing price and is designed to filter out insignificant cycles and show the prevailing trend of the stock. Triple smoothing reduces volatility and minimizes the chance of false signals. 
Period  the 'period' defines the period for the function  it must be a constant greater or equal to 1. 
True Range  The True Range indicator is the greatest of the following:  High for the day minus Low for the day.  The absolute value of: High for the day minus Close for the previous day.  The absolute value of: Low for the day minus Close for the previous day. 

Williams Percent R  William's %R is a momentum indicator, designed to measure overbought and oversold levels. This indicator is similar to the Stochastic %K indicator, except that Williams %R is plotted using negative values ranging from 0 to 100. This indicator was developed by Larry Williams. 
Period  the 'period' defines the period for the function  it must be a constant greater or equal to 1. 
Note that all financial functions need a stock series (chart) to be displayed correctly. The statistical functions are generally operating on the Values of the respective series. When applied to a stock function the statistical functions use the stock Close values.) 
Show On Series Chart Area  when set to true the calculated series are displayed on the chart area on which the master series are displayed. When set to false the calculated series are displayed on the chart area specified by the Chart Area combo. By default set to true.
Chart Area  lets you choose the chart area on which to display the calculated series. Only applicable if Show On Series Chart Area is false.
Y Axes  lets you specify the Y axis on which to scale the calculated series.
Z Order  controls the Z order of the calculated series in regards to the master series and the other series in the respective chart area. Possible values are:
Behind All Series  the calculated series appears "behind" all series in the chart area.
Behind Series  the calculated series appears behind the master series in the chart area. If the calculated series is displayed on a chart area different than that of the master series, this setting is equivalent to Behind All Series.
Before Series  the calculated series appears before the master series in the chart area. If the calculated series is displayed on a chart area different than that of the master series, this setting is equivalent to Before All Series.
Before All Series  the calculated series appears before all series in the chart area.
Controls the appearance of the calculated series. Following is a description of the appearance settings:
Fill Style  specifies the filling of the data points associated with the calculated series.
Border Style  specifies the border/stroke style of the data points associated with the calculated series.
Shadow Style  specifies the shadow style of the data points associated with the calculated series.
Controls the calculated series legend representation. For more info see  Values Data Groupings  Legend.
Lets you choose the type of action associated with the calculated series. See Actions and Drill Down reportsActions and Drill Down reports for more info.
The action label of calculated series supports the <value> and <xvalue> (for XY scatters trendlines) templates. When these template strings are present in the aciton label (tooltip) the component will automatically split the trendline segments into smaller segments so that the tooltip reflects a more accurate value on the trendline. The InterpolationSteps controls the number of segments into which each trendline segment is split into. The higher the value the more accurate the tooltips will be.
The displayed value and xvalue are formatted with the formatting associated with the data labels values.