Register for free to join our community of investors and share your ideas. You will also get access to streaming quotes, interactive charts, trades, portfolio, live options flow and more tools.
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.
****************************************************************
****************************************************************
****************************************************************
****************************************************************