Home > Boards > Stock Clubs > Technical Analysis >

Augie's Indicator Formulas

RSS Feed
      Hide Sticky   Hide Intro
Moderator: augieboo Assistants:
Search This Board: 
Last Post: 6/13/2003 11:51:41 AM - Followers: 2 - Board type: Premium - Posts Today: 0

A place to post some of the formulas I use to create indicators in Excel. Here is a small snippet of an Excel spreadsheet to use as a reference. MOVING AVERAGES [1] Simple Moving Average Assume: Data to be averaged is in column B Moving average is to go into column C Moving average is to be 13 days in duration Formula -- Type the following into cell C14 =(sum(b4:b14))/13 [2]Exponential Moving Average Assumptions: Same as above First, find the exponent to use by dividing 2 by the number of periods plus one, i.e., for a 13 day EMA we use 2 / (13 + 1) = .142857, rounded to .143 Second, subtract the exponent from 1, i.e., 1 - .143 = .857 Next, enter the following formula into cell C14: =(((sum(b4:b14)/13)*.857)+(.143*b14) [3] Rate of Change (unsmoothed) Assume: Data whose rate is to be calculated is in column B Rate of Change is to go into column C ROC is to be 13 days in duration Formula -- Type the following into cell C14 =b2/b14 That's it! **************************************************************** **************************************************************** **************************************************************** **************************************************************** NOTE: THIS IS NOT INTENDED AS A DISCUSSION BOARD. PLEASE POST ALL COMMENTS, QUESTIONS, ETC, TO ME AT THE MDA THREAD, WHICH IS #board-1320. NOTE: THIS IS NOT INTENDED AS A DISCUSSION BOARD. PLEASE POST ALL COMMENTS, QUESTIONS, ETC, TO ME AT THE MDA THREAD, WHICH IS #board-1320. NOTE: THIS IS NOT INTENDED AS A DISCUSSION BOARD. PLEASE POST ALL COMMENTS, QUESTIONS, ETC, TO ME AT THE MDA THREAD, WHICH IS #board-1320. NOTE: THIS IS NOT INTENDED AS A DISCUSSION BOARD. PLEASE POST ALL COMMENTS, QUESTIONS, ETC, TO ME AT THE MDA THREAD, WHICH IS #board-1320. **************************************************************** **************************************************************** **************************************************************** ****************************************************************
No posts yet. Be the first!
Consent Preferences