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: Spreadsheet
DownloadA Spreadsheet For A Trend-Following Approach
ARTICLE SYNOPSIS...Here's a template for a spreadsheet that anyone can use to set up a simple trend-following system
A Spreadsheet For Price Ratio Projection Analysis by Robert Miner
ARTICLE SYNOPSIS...A Spreadsheet For Price Ratio Projection Analysis by Robert Miner Traders who follow Gann and Elliott wave analysis use ratios of past price movement as guidelines for possible turning points in the future. Here, Robert Miner of Gann/Elliott Educators g
A Spreadsheet For Time Ratio Analysis by Robert Miner
ARTICLE SYNOPSIS...A Spreadsheet For Time Ratio Analysis by Robert Miner Traders using ratio of time cycle analysis will find this spreadsheet version of determining target dates of possible cycle highs or lows helpful. The author discusses the use of projected target dat
ADX Excel Spreadsheet
ARTICLE SYNOPSIS...Constructing an Excel spreadsheet requires that each step of the ADX computation be stated. Shown are each of the calculations.
Equivolume Using A Spreadsheet Program by James Leahy
ARTICLE SYNOPSIS...Equivolume Using A Spreadsheet Program by James Leahy Equivolume charting, which permits plotting price movements vs. volume instead of time, can be plotted by hand or with one of several charting programs, but a plain spreadsheet program on your person
Product Review: WaveWi$e Market spreadsheet, version 6l36
SIDEBAR: DEMA1 EXCEL SPREADSHEET by Technical Analysis, Inc.
ARTICLE SYNOPSIS...DEMA1 EXCEL SPREADSHEET by Technical Analysis This Excel spreadsheet (Figure 4) presents the calculation of the DEMA1 (column G) of the weekly closing price of the NASDAQ (column D). We will be using the regression coefficients for the initialization of
SIDEBAR: DESCRIBING A SPREADSHEET PROGRAM
ARTICLE SYNOPSIS...DESCRIBING A SPREADSHEET PROGRAM
SIDEBAR: EXCEL SPREADSHEET Thom Hartle, Editor
ARTICLE SYNOPSIS...EXCEL SPREADSHEET --Thom Hartle, Editor The Excel 3.0 spreadsheet presented here in sidebar Figure 1 shows the indicators described in ""Volume variations."" The daily high, low and close of the Standard & Poor's 500 index along with the daily total NYSE
SIDEBAR: OPTIMUM DETRENDING SPREADSHEET EXAMPLE
ARTICLE SYNOPSIS...OPTIMUM DETRENDING SPREADSHEET EXAMPLE The following is a spreadsheet example (sidebar Figure 1) and a QuickBasic source code (sidebar Figure 2) of optimum detrending. Our spreadsheet example is for detrending the price data of the bond market example u
SIDEBAR: Polarized Fractal Efficiency Spreadsheet by Technical Analysis, Inc.
ARTICLE SYNOPSIS...POLARIZED FRACTAL EFFICIENCY SPREADSHEET by Technical Analysis, Inc. The first step to calculate the 10-period polarized fractal efficiency (PFE) on a percentage basis is to calculate the first-to-last close spacing.
SIDEBAR: RANDOM WALK INDEX SPREADSHEET by Thom Hartle, Editor
ARTICLE SYNOPSIS...SIDEBAR: RANDOM WALK INDEX SPREADSHEET by Thom Hartle, Editor Sidebar Figure 1 is a bar chart with 10 days of simulated data; today's current high and low are plotted as if the market is still trading. The random walk index of the lows can measure if to
SIDEBAR: Random Walk Index Spreadsheet by Technical Analysis, Inc.
ARTICLE SYNOPSIS...Random Walk Index Spreadsheet by Technical Analysis, Inc. Random Walk index spreadsheet.
SIDEBAR: SETTING UP AN EXCEL SPREADSHEET
ARTICLE SYNOPSIS...SETTING UP AN EXCEL SPREADSHEET Following is an example of setting up an Excel spreadsheet for creating a forecast using a five-day linear regression for tomorrow's close. Sidebar Figure 1, Column A, lists the dates and Column D lists the closing prices
SIDEBAR: SPREADSHEET ANALYSIS by Technical Analysis, Inc.
ARTICLE SYNOPSIS...SPREADSHEET ANALYSIS by Technical Analysis, Inc. Here's a simple way of setting up a return versus leverage analysis in a spreadsheet (sidebar Figure 1). Specifically, this is for Lotus 1-2-3, but you should be able to follow the example and apply it to
SIDEBAR: Spreadsheet Calculations by Thom Hartle
ARTICLE SYNOPSIS...SPREADSHEET CALCULATIONS This set of oscillators is easily calculated in a spreadsheet (sidebar Figure 1). The first four column are the date, high, low and closing price of Boeing (BA). Column E is the calculation of the 24-period moving average, the b
SIDEBAR: THE CHL/LLF METHOD SPREADSHEET by Technical Analysis, Inc.
ARTICLE SYNOPSIS...THE CHL/LLF METHOD SPREADSHEET by Technical Analysis, Inc. Recall that the ""concurrent highest low"" filter (CHL) is a condition set up for the ""largest low to low fall"" trigger (LLF) and that the two are true/false situations. Therefore, the CHL fil
SIDEBAR: TREND CHANNEL SPREADSHEET
ARTICLE SYNOPSIS...TREND CHANNEL SPREADSHEET The trend-following method uses exponential smoothed moving averages (EMA) of price data. The equation for an EMA requires the previous day's EMA for the calculation of today's EMA. Consequently, the first period's closing pric
SIDEBAR: WAMI SPREADSHEET by Technical Analysis, Inc.
ARTICLE SYNOPSIS...WAMI SPREADSHEET by Technical Analysis, Inc. The spreadsheet (seen in sidebar Figure 5) provides a way to evaluate the WAMI power and phase spectrum as a function of the WAMI parameters L, M and N. The first column starting with A5 contains the frequenc
SIDEBAR: WRITING AND EXECUTING A SPREADSHEET MACRO
ARTICLE SYNOPSIS...WRITING AND EXECUTING A SPREADSHEET MACRO A macro is a series of commands or keystrokes that can be stored for use for repeated operations. For all popular spreadsheets, macros can take on two different forms. One is a series of keystrokes that can be r
Setting Up an Excel Spreadsheet for the Forecast Oscillator
ARTICLE SYNOPSIS...This article is reprinted from Technical Analysis of Stocks & Commodities magazine, Volume 10, Issue 5 to supplement my recent article "Forecast Oscillator".
WAVE WI$E Market Spreadsheet Version 6.0a by John Sweeney
Request Information From Our Sponsors
- 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
- 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