## SQL Reporting Services Chart Calculated Series, Trendlines & Moving Averages

Nevron Chart for SQL Reporting Services (SSRS) comes with enhanced support for calculated series (trend lines), for the quick and easy creation of sophisticated data analysis in your SSRS report projects.

Calculated Chart Series help end-users to analyze data, identify the nature of a sequence of observations, and to predict future values using historical observations. Calculated series are attached to a master series and display a trendline or formula that is based on the master series values.

The calculated series also feature full control over their appearance, chart area, display on axes, data labels, data labels layout, markers, action and formula specific parameters.

#### Min

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.

#### Max

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.

#### Median

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.

#### Cumulative

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.

#### Sum

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

#### Average

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

#### Exponential Average

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

#### Root Mean Square

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

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.

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

#### Bollinger Bands

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

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.

#### Simple Moving Average

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.

#### Weighted Moving Average

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.

#### Exponential Moving Average

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

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

#### Median Price

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

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

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.

#### Positive Direction Indicator

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.

#### Negative Direction 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).

#### Directional Movement Index

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.

#### Average Directional 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.

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.

#### Average True Range

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.

#### Chaikins Volatility

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.

#### Commodity Channel Index

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.

#### Detrended Price Oscillator

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.

#### Mass Index

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.

#### 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 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]

#### 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]

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

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

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.

#### 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 )

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

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

True Range is usually used with OHLC charts.

#### William's %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.

## Customer Quotes: We needed a solution that could produce a bar graph with overlaid SEM bars. After some research, we determined that Nevron Chart for SSRS component was the right fit, allowing us to easily produce a graph such as this.

Nevron has been very helpful and responsive to our needs. We are pleased with the product and hope to expand its use in our systems in the future. David Miller, Manager Software Development
Medical Council of Canada