STOCKS & COMMODITIES magazine. The Traders' Magazine

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

  • 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







S&C Subscription/Renewal




Request Information From Our Sponsors 

DEPARTMENTS: Advertising | Editorial | Circulation | Contact Us | BY PHONE: (206) 938-0570

PTSK — The Professional Traders' Starter Kit
Home — S&C Magazine | Working Money Magazine | Traders.com Advantage | Online Store | Traders’ Resource
Add a Product to Traders’ Resource | Message Boards | Subscribe/Renew | Free Trial Issue | Article Code | Search

Copyright © 1982–2019 Technical Analysis, Inc. All rights reserved. Read our disclaimer & privacy statement.