V.11:11 (472-476): SIDEBAR: RANDOM WALK INDEX SPREADSHEET by Thom Hartle, Editor

V.11:11 (472-476): SIDEBAR: RANDOM WALK INDEX SPREADSHEET by Thom Hartle, Editor
Item# \V11\C11\SIDERAN.PDF
Availability: In Stock

Product Description


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 today's low price indicates that the market is trending or just in a random trading range. Sidebar Figure 2 is an example of setting up an Excel spreadsheet for creating the random walk index for lows. This spreadsheet is set up with the most current day's data in the bottom row. Remember that the denominator for the index uses the average range of the lookback period multiplied by the square root of the number of the days of the lookback period. The average range uses the true range, which is the greatest of two comparisons: today's high minus today's low or yesterday's close minus today's low.

*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