SSRS Chart Calculated Series (Trendlines)

Calculates the min value of all the elements in the input array, or the min value of every N successive elements in the input array.

Calculates the max value of all the elements in the input array, or the max value of every N successive elements in the input array.

This function calculates the median value for the data in the 'values' array. The median is the middle value in a distribution, above and below which lie an equal number of values.

The function calculates the cumulative sum of the elements in the input array. Each element of the result is equal to the previous element of the result plus the current element of the input array.

Calculates the sum of all the elements in the input array, or the sum of every N successive elements in the input array.

Calculates the average of the elements in the input array, or the average of every N successive elements in the input array.

The function calculates the exponential average of the input array. The formula is:
Result[n] = arg1[n] * weight + arg1[n-1] * (1 - weight)

The Root Mean Square (RMS), also known as the quadratic mean, is a statistical measure of the magnitude of a varying quantity. It can be calculated for a series of discrete values or for a continuously varying function. Its name comes from its definition as the square root of the mean of the squares of the values.

Standard deviation is used to indicate volatility. It measures the difference between values (Closing Price) and average. If the difference is larger, the standard deviation and volatility are higher. If the value (Closing price) is closer to the average price, the standard deviation and volatility are lower.

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.

Bollinger Bands are indicators that are plotted at standard deviation levels above and below a simple moving average. Since standard deviation is a measure of volatility, a large standard deviation is a good indicator for a volatile market, while a smaller standard deviation is an indicator of a calmer market.

Bollinger Bands are a good way to compare volatility and relative price levels over a period of time.

Envelopes are plotted above and below a moving average using a specified percentage. The Envelopes indicator is used to create signals for buying and selling. The percentage which will be used for calculating envelopes is specified by user and it depends on volatility of the market. If the market is more volatile the percentage is higher.

A Simple Moving Average is an average of data calculated over a period of time. The moving average is the most popular price indicator used in technical analyses, and can be used with any price: Hi, Low, Open, Close or it could be applied to other indicators. Moving average smoothes a data series which is very important in a volatile market. With a moving average it is much easier to spot a trend.

A Weighted Moving Average is the average of the data calculated over a period of time where the greater weights are attached to the most recent data. The weighting is calculated from the sum of days. The Weighted Moving Average can be used with any price: Hi, Low, Open, Close or it could be applied to other indicators. Weighted Moving Average smoothes a data series which is very important in a volatile market.

A Exponential Moving Average is an average of data calculated over a period of time where the most recent days have more weight. The exponential moving average can be used with any price: Hi, Low, Open, Close or it could be applied to other indicators. Exponential Moving average smoothes out data series, which is very important in a volatile market.

Nevron Chart has four types of moving averages: Simple, Weighted, Exponential and Modified. The most important difference between the various moving averages is how weights are applied.

Modified Moving Average (MMA) is a type of exponential moving average (EMA) where the weight given to older records decreases exponentially.

Median price is the mid-point value of daily prices. Median price can be used as a filter for trend indicators. It is also used as the daily average price which is very useful if we want a simpler view of prices.

Typical price is the average value of daily prices. Typical price can be used as a filter for trend indicators as well as the daily average price which is very useful if we want a simpler view of prices.

Weighted Close formula calculates the average value of daily prices. The only difference between Typical Price and Weighted Close is that the closing price has extra weight as the most important price. Weighted Close could be used as a filter for trend indicators, as well as being used as the daily average price which is very useful if we want a simpler view of prices.

The Positive Direction Indicator (+DI) summarizes upward trend movement.

The Positive Direction Indicator is a component of the average directional index that is used to measure the presence of an uptrend. When the +DI is sloping upward, it is a signal that the uptrend is getting stronger. This indicator is nearly always plotted along with the negative directional indicator.

The Negative Direction Indicator (-DI) summarizes downward trend movement.

The Negative Direction Indicator is a component of the average directional index (ADX) that is used to measure the presence of a downtrend. When the -DI is sloping upward, it is a signal that the strength of the downtrend is increasing. This indicator is almost always plotted with the positive directional indicator (+DI).

The Directional Movement Index (DMI) helps identify whether there is a definable trend in a market, and in which direction that trend is moving. The ADX function, which is a part of the Directional Movement System, is based on the DMI.

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.

The Average Directional Movement Index is an indicator used in technical analysis as an objective value for the strength of trend. ADX is non-directional so it will quantify a trend's strength regardless of whether it is up or down. ADX is usually plotted in a chart window along with two lines known as the DMI (Directional Movement Indicators). ADX is derived from the relationship of the DMI lines.

The Average True Range (ATR) 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:

- 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.

The Average True Range is a moving average (typically 14-days) of the True Range.

The Chaikins Volatility indicator measures the difference between High and Low prices. This formula is used to indicate the top or bottom of the market. This formula was developed by Marc Chaikin.

The Commodity Channel Index compares Prices with its moving averages. If the Commodity channel index is high, it means that the price is higher than its moving average, which is an indicator that the security is overbought. If the Commodity channel index is low, it means that the price is lower than its moving average which is an indicator that security is oversold.

The Detrended Price Oscillator is used to "remove" the trend from the price. Comparing Closing or any other price with it's moving average, the Detrende Price Oscillator eliminates cycles longer than moving average.

The Mass index is developed to predict trend reversal by comparing difference and range between High and Low prices. If the Mass index is going up, the range between High and low is bigger. If the Mass index is going down, the range between High and Low is smaller.

The Momentum indicator measures the amount that a security's price has changed over a given time span. It can be used as a trend-following oscillator similar to the MACD or as a leading indicator. The formula of the momentum is:
Momentum[n] = values[n] - values[n - period]

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]

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 26-day exponential moving average from a 12-day exponential moving average. The MACD proves most effective in wide-swinging 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.

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.

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 (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:

U[n] - average value of the upward price change for the given period
D[n] - average value of the downward price change for the given period

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.

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 )

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.

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.

True Range is usually used with OHLC charts.

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.