Home > Articles > Volume 12 (1994) > Chapter 4 (April 1994) > V.12:4 (146-152): SIDEBAR: EXCEL FAST FOURIER TRANSFORMS, DECEMBER COPPER DATA by Technical Analysis, Inc.

V.12:4 (146-152): SIDEBAR: EXCEL FAST FOURIER TRANSFORMS, DECEMBER COPPER DATA by Technical Analysis, Inc.

Product Description

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 date beginning with cell A4 is July 8, 1993, and the last date is November 18, 1993. The total number of periods is 95, which is entered into cell B3. Column B represents the daily closing prices. Column C is a counter beginning with 1 and ending with 95. This column is needed for other calculations. Column D is the trend calculation, the linear least-squares regression line. This formula needs to be entered as an array (check your manual for instructions) in cells D4 through D98.

FOR THOSE ORDERING ARTICLES SEPARATELY:
*Note: $2.95-$5.95 Articles are in PDF format only. No hard copy of the article(s) will be delivered. During checkout, click the "Download Now" button to immediately receive your article(s) purchase. STOCKS & COMMODITIES magazine is delivered via mail. After paying for your subscription at store.traders.com users can view the S&C Digital Edition in the subscriber's section on Traders.com.

Take Control of Your Trading.

Professional Traders' Starter Kit

All these items shown below only $299.99!

5-year subscription to Technical Analysis of STOCKS & COMMODITIES, The Traders' magazine. (Shipping outside the US is extra. Washington state addresses require sales tax based on your locale.)

5 year access to S&C Archive

5 year access to S&C Digital Edition

5-year subscription to Traders.com Advantage.

5-year subscription to Working Money.

Free book selection.

Click Here to Order