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

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

Excel File January 2000 Issue

Quick Scan: Mathematica Link for Excel

  • 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: EXCEL FAST FOURIER TRANSFORMS, DECEMBER COPPER DATA by Technical Analysis, Inc.

    ARTICLE SYNOPSIS...EXCEL FAST FOURIER TRANSFORMS, DECEMBER COPPER DATA by Technical Analysis, Inc. Here is the layout for preprocessing data and running a fast Fourier transform (FFT) in Excel. Column A of the spreadsheet (sidebar Figure 8) is the date column. Our first d

SIDEBAR: EXCEL FUNCTIONS

  • 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: Filtering in Excel by Scott Barrie

    ARTICLE SYNOPSIS...V.13:07 (286): SIDEBAR: Filtering in Excel by Scott Barrie Here are the Excel 4.0 formulas to perform individual market filters. For our example, we'll use the December 1994 Treasury bond futures market (sidebar Figures 1 and 2) with a 1% filter. The sp

  • 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

  • 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".

  • Sidebar: Excel codes for trend trigger factor by M.H. Pee

    ARTICLE SYNOPSIS...Stocks & Commodities V. 22:12 (28-36): Sidebar: Excel codes for trend trigger factor by M.H. Pee EXCEL CODES FOR TREND TRIGGER FACTOR The Excel spreadsheet in sidebar Figure 1 shows all the required calculations for the 15-day trend trigger factor (TTF

  • Sidebar: MOMA and Excel by Stephan Bisse

    ARTICLE SYNOPSIS...Stocks & Commodities V. 23:2 (22-27): Sidebar: MOMA and Excel by Stephan Bisse Simple moving averages are great tools for filtering out noise from time series, but all they can do is show where a time series has been. The only way that a moving average







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–2017 Technical Analysis, Inc. All rights reserved. Read our disclaimer & privacy statement.