# Article Archive For Keyword: SIDEBAR CALCULATING

• ### SIDEBAR: CALCULATING A RATE OF CHANGE OSCILLATOR

ARTICLE SYNOPSIS...CALCULATING A RATE OF CHANGE OSCILLATOR A rate of change oscillator (Roc) is calculated by dividing the price in the current time period by the price n periods ago. For example, a 10-day rate of change would be today's price divided by the price 10days

• ### SIDEBAR: CALCULATING AN 11-PERIOD CCI by Thom Hartle, Editor

ARTICLE SYNOPSIS...CALCULATING AN 11-PERIOD CCI by Thom Hartle, Editor The commodity channel index (CCI) can be calculated using any lookback period chosen by the trader. The Excel spreadsheet shown in sidebar Figure 1 is an 1 l-period CCI for the Dow Jones Industrial Ave

• ### SIDEBAR: CALCULATING BOLLINGER BANDS

ARTICLE SYNOPSIS...CALCULATING BOLLINGER BANDS An Excel spreadsheet is used to calculate Bollinger Bands for the DJIA. The actual formula for each cell is shown at the bottom of the column; the formula presented is specific for the location of that cell.

• ### SIDEBAR: CALCULATING MVI

ARTICLE SYNOPSIS...CALCULATING MVI The market volume impact (MVI) uses the daily net change of the Dow Jones Industrial Average and the total volume for the New York Stock Exchange. These two values are multiplied together to calculate MVI. The next step is to smooth MVI

• ### SIDEBAR: CALCULATING PERR

ARTICLE SYNOPSIS...CALCULATING PERR Price/earnings ratio reliability (PERR) is simply 100 ´ the R-square that measures the correlation between the logarithms of price and earnings. PERR is most easily visualized through scatter charts: Article Figure 2 shows Merck's high

• ### SIDEBAR: CALCULATING PREMIUM FAIR VALUE

ARTICLE SYNOPSIS...SIDEBAR: CALCULATING PREMIUM FAIR VALUE A risk-averse investor wants to invest in the stock market. How does he do it without risking loss? He can borrow funds, buy a portfolio of stocks equivalent to the S&P 500 index at the price of S and simultaneous

• ### SIDEBAR: CALCULATING RELATIVE STRENGTH

ARTICLE SYNOPSIS...CALCULATING RELATIVE STRENGTH Calculating relative strength performance in a spreadsheet is easy. Ours example, sidebar Figure 1, uses the closing price of Pepsico (column A) versus the closing price for the S&P 500 (column B). Any two items can be comp

• ### SIDEBAR: CALCULATING RSI

ARTICLE SYNOPSIS...CALCULATING RSI Calculate RSI by summing the up closes during the first 14 days and dividing by 14. This is the up average (Column E). Then sum the down closes during the first 14 days and divide by 14. This is the down average (Column F). All values ar

• ### SIDEBAR: CALCULATING STOCHASTICS by Technical Analysis, Inc.

ARTICLE SYNOPSIS...CALCULATING STOCHASTICS by Technical Analysis, Inc. Calculating %K and %D, with formulas for a spreadsheet.

• ### SIDEBAR: CALCULATING TEMA1 AND DEMA1 by Technical Analysis, Inc.

ARTICLE SYNOPSIS...CALCULATING TEMA1 AND DEMA1 by Technical Analysis, Inc. These Excel spreadsheets (sidebar Figures 1 and 2) present the calculation of TEMA1 (column H) and DEMA1 (column N). TEMA1 uses a multiple linear regression over a 52-week period of closing prices

• ### SIDEBAR: CALCULATING THE DEV- STOP by Technical Analysis, Inc.

ARTICLE SYNOPSIS...CALCULATING THE DEV- STOP by Technical Analysis, Inc. Calculating the DEV-stop.

• ### SIDEBAR: CALCULATING THE RSI by Technical Analysis, Inc.

ARTICLE SYNOPSIS...CALCULATING THE RSI by Technical Anlaysis, Inc. The RSI classic The first step in calculating a 14-period relative strength index (RSI) in a Microsoft Excel spreadsheet is determining the up momentum and the down momentum. This is performed in columns

• ### SIDEBAR: CALCULATING THE THRUST OSCILLATOR WITH THE TECHNICIAN

ARTICLE SYNOPSIS...CALCULATING THE THRUST OSCILLATOR WITH THE TECHNICIAN Plotting the thrust oscillator (TO) requires two user formulas. The first one calculates the daily value; this formula in The Technician's language is: ...

• ### SIDEBAR: CALCULATING TSI

ARTICLE SYNOPSIS...CALCULATING TSI Calculating the true strength index requires an introduction to exponentially smoothed moving averages (EMA): Exponential Moving Average- The EMA for day D is calculated as: EMAD = aPRD + (1-a)EMAD-1 where PR is the price on day D and a

• ### SIDEBAR: CALCULATING VIDYA by Technical Analysis, Inc.

ARTICLE SYNOPSIS...CALCULATING VIDYA by Technical Analysis, Inc. The variable index dynamic moving average (VIDYA) builds on the concept of the exponential moving average (EMA). While the EMA uses a constant (alpha) to smooth today's data, the VIDYA adjusts the alpha acco

• ### SIDEBAR: CALCULATING WEIGHTED MOVING AVERAGES

ARTICLE SYNOPSIS...CALCULATING WEIGHTED MOVING AVERAGES The first step for calculating a weighted moving average (WMA) is to decide the lookback period (n) and the alpha (a). For our example in sidebar Figure 1, we are using n = 8 and a = 0.6 to calculate the optimized we

• ### SIDEBAR: Calculating Bollinger Bands by Technical Analysis, Inc.

ARTICLE SYNOPSIS...Calculating Bollinger Bands by Technical Analysis, Inc. Bollinger band formulas for an Excel spreadsheet.

• ### SIDEBAR: Calculating DEMA2 AND THE MACD by Technical Analysis, Inc.

ARTICLE SYNOPSIS...Calculating DEMA2 AND THE MACD by Technical Analysis, Inc. This Excel spreadsheet (sidebar Figure 3) presents the DEMA2 along with the MACD using DEMA2 as the smoothing filters. Column B (labeled X value) is the time t. This column could be elsewhere, a

• ### SIDEBAR: Calculating Historical Volatility - Technical Analysis, Inc.

ARTICLE SYNOPSIS...CALCULATING HISTORICAL VOLATILITY - Technical Analysis, Inc. Historical volatility is the annualized standard deviation of the one-day price changes of the security or futures contract. To perform this calculation in a Microsoft Excel spreadsheet (as ca

• ### SIDEBAR: Calculating Momentum

ARTICLE SYNOPSIS...CALCULATING MOMENTUM Momentum is traditionally calculated as the difference between the price today and the price n days ago. The method presented here substitutes for the price n days ago an average of the previous three period's high, low and closing

• ### SIDEBAR: Calculating The Relative Strength-MACD Crossover

ARTICLE SYNOPSIS...SIDEBAR: Calculating The Relative Strength-MACD Crossover The relative strength ratio-MACD crossover indicator in this example uses the daily closing price of Boeing (BA) compared with the daily closing price of the S&P 500 index. The first day's period

• ### SIDEBAR: Calculating TrSI

ARTICLE SYNOPSIS...CALCULATING TrSI Calculating the true strength index requires an introduction to exponentially smoothed moving averages (EMA): Exponential Moving Average--The EMA for day D is calculated as: EMAD = aPRD + (1-a)EMAD-1 where PR is the price on day D and a

• ### SIDEBAR: Calculating an 11-period CCI

ARTICLE SYNOPSIS...CALCULATING AN 11-PERIOD CCI The commodity channel index (CCI) can be calculated using any lookback period chosen by the trader. The Excel spreadsheet shown in sidebar Figure 1 is an 11-period CCI for the Dow Jones Industrial Average. The first step is

• ### SIDEBAR: Calculating an 11-period CCI

ARTICLE SYNOPSIS...CALCULATING AN 11-PERIOD CCI The commodity channel index (CCI) can be calculated using any lookback period chosen by the trader. The Excel spreadsheet shown in sidebar Figure 1 is an 11-period CCI for the Dow Jones Industrial Average. The first step is

• ### SIDEBAR: Calculating an 11-period CCI by Thom Hartle

ARTICLE SYNOPSIS...Calculating an 11-period CCI by Thom Hartle Combining two classic indicators, the commodity channel index (CCI) and Bollinger bands, can be a potent timing tool for options trading. This author was inspired by John Bollinger's article ""Bollinger Bands"

• ### SIDEBAR: Calculating an 11-period CCI by Thom Hartle

ARTICLE SYNOPSIS...Calculating an 11-period CCI by Thom Hartle The commodity channel index (CCI) can be calculated using any lookback period chosen by the trader. The Excel spreadsheet shown in sidebar Figure 1 is an 1 l-period CCI for the Dow Jones Industrial Average. Th

• ### SIDEBAR: Calculating leverage and simulated trading

ARTICLE SYNOPSIS...Sidebar: Calculating leverage and simulated trading The following explanation uses a Microsoft Excel 4.0 spreadsheet calculating final equity versus leverage and simulated trading. Referring to Figure 1 from the article, the values placed in the spreads

• ### SIDEBAR: Calculating noise level

ARTICLE SYNOPSIS...CALCULATING NOISE LEVEL Some of the other methods I use to calculate noise level (NL) are: ... where P is the averaging period for the daily range; the article's Figure 3 is a plot of ADR j . Another method uses the average daily range and three stand

• ### SIDEBAR: Calculating probability

ARTICLE SYNOPSIS...Sidebar: Calculating probability Using the data from the example, we have r = 0.00093553 and sr = 0.011258649. Suppose we wish to see the probability of being at a loss for L = 4 after 36 trades?

• ### SIDEBAR: Calculating the Bandpass Indicator

ARTICLE SYNOPSIS...SIDEBAR: Calculating the Bandpass Indicator The bandpass indicator is an oscillator-type indicator using two filters. This sidebar give the formulas for using this indicator as described in John Ehler's article, in Excel. In calculating the bandpass i

• ### SIDEBAR: Calculating the Coppock Curve in SuperCharts

ARTICLE SYNOPSIS...SIDEBAR: Calculating the Coppock Curve in SuperCharts The Coppock curve in Figure 1 of the article ""The Coppock Curve"" by Elliot Middleton, labeled ""CoppockAnnual"" takes the essence of Coppock's original formulation and puts it in modern mathematics

• ### SIDEBAR: Calculating the KST by Technical Analysis, Inc.

ARTICLE SYNOPSIS...Calculating the KST by Techncial Analysis, Inc. KST formulas for short, intermediate, and long term daily or weekly data.

• ### SIDEBAR: Calculating the McClellan Indicators - Technical Analysis, Inc.

ARTICLE SYNOPSIS...CALCULATING THE McCLELLAN INDICATORS - Technical Anlaysis, Inc. The McClellan oscillator can be used for measuring changes in momentum of price, volume, advances and declines. The most common use is for measuring the momentum of the New York Stock Excha

• ### SIDEBAR: Calculating the RSI

ARTICLE SYNOPSIS...SIDEBAR: CALCULATING THE RSI The relative strength index (RSI) is a momentum indicator that uses the net difference of closing prices for up days and down days. The following are steps by which to build a 14-period RSI, using as an example the price dat

• ### SIDEBAR: Calculating the mean, standard deviation and cumulative

ARTICLE SYNOPSIS...Sidebar: Calculating the mean, standard deviation and cumulative probability density functions. Calculating the mean of a series of numbers is the same as calculating the average of a series of numbers. First, sum the numbers together and divide by the

• ### SIDEBAR: Calculating the standard deviation of the percentage change in closing prices

ARTICLE SYNOPSIS...SIDEBAR: Calculating the standard deviation of the percentage change in closing prices Calculating the ratio of two sequential prices in Lotus is straightforward. The natural log function is preprogrammed as @In(). The standard deviation of the logs can

• ### Sidebar: Calculating the KST by Technical Analysis, Inc.

ARTICLE SYNOPSIS...Sidebar: Calculating the KST by Technical Analysis, Inc. The suggested parameters for short, intermediate and long term can be found in sidebar Figure 1. There are three steps to calculating the KST indicator. First, calculate the four different rates o

• ### V.10:9 SIDEBAR: Calculating the KST by Technical Analysis, Inc.

ARTICLE SYNOPSIS...Calculating the KST by Technical Analysis, Inc. KST formulas for short, intermediate, and long term daily or weekly data.