V. 11:10 (415-415): Letters To S&C by Technical Analysis, Inc.

V. 11:10 (415-415): Letters To S&C by Technical Analysis, Inc.
Item# \V11\C10\LETTERT.PDF
Availability: In Stock

Product Description

LETTERS by Technical Analysis, Inc.



In the "Relative volatility index" sidebar on pages 64-65 of the June 1993 STOCKS & COMMODITIES, the Excel spreadsheet gives the formulas for the up close volatility and down close volatility in columns E and F. Please define for me STDEVP(D2:D11). I would appreciate a numerical answer. Thank you.


The STDEVP(D2:D11) formula in Excel measures the standard deviation of the closing prices listed in cells D2 through D11. Standard deviation measures the variance about the mean. In our case, we are measuring the variance of the last 10 days of closing prices compared with the mean or average of the last 10 days of closing prices. To learn more about standard deviation, I suggest purchasing a used college statistics textbook from your local community college. Or try The Economist Guide to Business Numeracy, a paperback($17.95) just published by John Wiley & Sons, 605 Third Ave., New York, NY 10158-0012, 800-C ALL WILEY. The book covers everything from statistics for business applications to data analysis techniques, chart reading, investment accounting, forecasting and linear programming.


*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