Home > Articles > Volume 14 (1996) > Chapter 2 (February 1996) > V14:2 (95): Letters to S&C

V14:2 (95): Letters to S&C

V14:2 (95): Letters to S&C
Item# \V14\C02\LETTERS.PDF
$2.95
Availability: In Stock

Product Description

LETTERS TO S&C

ENTERING AN ARRAY IN EXCEL

Editor,

I am writing for clarification on the article "Smoothing data with less lag" in the February 1994 issue of STOCKS & COMMODITIES. On page 68 is a listing for formulas calculating the DEMA2 and MACD. The formulas for cells J2 and K2, which calculate a 26-week regression, are indicated to be identical. Figure 3 displays a number for cell K2, which does not correspond with the formula. An identical issue exists for cells J5 and K5. Please advise the correct formula for both cells K2 and K5.

DAVID HADLEY Concord, CA

The single formula is entered into cells J2 and K2 as an array. Please check your manual for instructions on how to enter formulas as an array. -Editor




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