Technical Analysis of STOCKS & COMMODITIES
The Traders’ Magazine since 1982
has had over 1,226,237 subscribers from 174 different countries.
37,000 Page Traders’ Archive for $89.99
Article Archive For Keyword: SIDEBAR CALCULATING
DownloadSIDEBAR: 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 closing prices
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.
|
Request Information From Our Sponsors
- VectorVest, Inc.
- Executive Premier Workshop
- One-Day Options Course
- OptionsPro
- Retirement Income Workshop
- Sure-Fire Trading Systems (VectorVest, Inc.)
- Trading as a Business Workshop
- VectorVest 7 EOD
- VectorVest 7 RealTime/IntraDay
- VectorVest AutoTester
- VectorVest Educational Services
- VectorVest OnLine
- VectorVest Options Analyzer
- VectorVest ProGraphics v6.0
- VectorVest ProTrader 7
- VectorVest RealTime Derby Tool
- VectorVest Simulator
- VectorVest Variator
- VectorVest Watchdog
- StockCharts.com, Inc.
- Candle Patterns
- Candlestick Charting Explained
- Intermarket Technical Analysis
- John Murphy on Chart Analysis
- John Murphy's Chart Pattern Recognition
- John Murphy's Market Message
- MurphyExplainsMarketAnalysis-Intermarket Analysis
- MurphyExplainsMarketAnalysis-Visual Analysis
- StockCharts.com
- Technical Analysis of the Financial Markets
- The Visual Investor